Excel Enter Key with Merged Hidden Cells
Posted on 2011-03-05
A user asked me why the enter key does not advance to the next row in a certain situation. It looks like it is because the cell she is in is part of several merged cells, the first and last of which are hidden.
Cells C1,D1,E1,F1 and G1 are merged. Columns C and G are hidden. I enter a value in what looks like D1+E1+F1 and press Enter but nothing happens. I think it is because I am really entering the value in C1 but it is hidden.
Am I on the right track?