The Control+ArrowKey shortcut is my new favorite shortcut. I seem to be using the heck out of it lately.
In Excel (cell navigation), it works like the End key. Control+Down Arrow is the same as End, Down. Add the Shift key for a handy way to select column of data.
In Excel (cell editing), the left and right arrows move to the next word. Find a long formula, press F2 to edit it, and start pressing Control+Left Arrow to move left one “word” at a time. Words are not quite so easy to distinguish as in a text editor, but it does a pretty good job. The up and down arrows don’t seem to do anything special. At least not that I can see.
In the VBE, left and right arrows move one word at a time, just like in cell editing. Since the Object.Property.Property type strings have a lot of periods, they make for nice breakpoints. The up and down arrows move one procedure at a time. I used to use Control+PgUp/PgDn, but I like this better. Instead of taking you to the first line of the procedure, which is usually a Sub or a procedure header, this takes you to the first line below the procedure declaration statement (Sub, Function, etc.). Also unlike PgUp/PgDn, this scrolls the cursor to the top of the code window – very handy.