Some people may be aware of this, but in Excel you can change the default behavior of the Enter key. By default, when you hit Enter it will move one cell down. In Excel 2007 this setting is found in Office button > Excel Options > Advanced, and it allows you to select from Up, [...]
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 [...]