Here are some of our favorite keyboard shortcuts. We think you’ll find them pretty handy. The symbol ^ means hold down the Ctrl key while hitting the other keys.
^ Page Down – moves to the next worksheet in the file
^ Page Up – moves to the previous worksheet in the file
Alt Enter – start a new line in the same cell
^ ; – enter the current date
^Shift ; – enter the current time
^Shift ! – applies the number format with 2 decimals, commas to separate thousands and minus signs to indicate negative numbers
^Shift $ – applies the currency format with 2 decimals
^ 1 – opens the Format Cells dialog box
^ D — fills down from cell above
Give them a try. If you’ve got a favorite keyboard shortcut let us know. E-mail us at firstname.lastname@example.org.