By default, if you press the Enter key after you type in some data, Excel moves the selected cell down. This can result in a lot of extra keystrokes or mouse clicks, if you need to enter data by row rather than column. Of course, you can change this action, but it’s kind of a pain if it’s just for a one-time use. Continue reading “Fast input of data by row instead of column”
Take a look at this worksheet snippet. What do you see?
Right off the bat, you should notice is that rows 11 to 15 are grouped and hidden from view. A closer look should also tell you that rows 3 to 8 are hidden. Continue reading “Don’t hide rows/columns, use Group feature”
Ever hide one or more rows at the top of your worksheet and scratch your head when you want to unhide them? Just press the F5 key and manually enter a cell address for one of the hidden rows. Continue reading “Unhide top row”