I used to work for a financial analysis company developing Excel macros/applications in VBA. There were — and still are — some 10th level Excel blackbelts that work there. I picked up quite a few keystroke tricks while working there. Even though I don’t work there anymore, I use these every time I’m in Excel.
- ctrl-Space – select column
- shift-Space – select row
- ctrl-Arrow Key – depending on which arrow key you hit, it will move the cursor along a series of cells*
- ctrl-Page Up, ctrl-Page Down – cycles through worksheets
- ctrl-Home – selects A1 on the current worksheet
*Longer explanation: Say that A2 is selected, and column A is populated from A1 to A50. If you hit ctrl-Down Arrow cell A50 will now be selected. If you then hit ctrl-Up Arrow it will take you to A1. The same holds true for left and right. Let’s also say that cells A60-A100 are populated. If, with A1 still selected, you hit ctrl-Down Arrow once (taking you to A50) and then a second time, it jumps over the blank gap from A51-A59 and selects A60. If you hit it a third time you will be at A100. It will probably make a little more sense if you tinker around with it a little.
What are your favorite Excel keystrokes?