Accelerating Microsoft Excel

To...	Use this shortcut
Open a new workbook	Press Ctrl+N.
Move left to right, cell by cell	Press Tab, or press the Right Arrow key.
Move right to left, cell by cell	Press Shift+Tab, or press the Left Arrow key.
Move down, cell by cell	Press Enter, or press the Down Arrow key.
Move up, cell by cell	Press Shift+Enter, or press the Up Arrow key.
Move down or up to the last empty or non-empty cell	Press Ctrl+Shift+Down Arrow or Up Arrow.
Move to the last empty or non-empty cell to the right or left	Press Ctrl+Shift+Right Arrow or Left Arrow.
Erase data in the current cell	Press Backspace.
Insert a return within a cell	Press Alt+Enter.
Return to the beginning of the row	Press HOME.
Advance to the next worksheet	Ctrl+Page Down
Go to the previous worksheet	Ctrl+Page Up
Enter the date	Press Ctrl+Semicolon (;).
Enter the time	Press Ctrl+Shift+Colon (:).
Find out about the style within the cell	Press Alt+Apostrophe (‘).
Display the Format Cells dialog box	Press Ctrl+1.
Apply the general number format	Press Ctrl+Shift+Tilde (~).
Apply the currency number format	Press Ctrl+Shift+Dollar Sign ($).
Apply the percentage number format	Press Ctrl+Shift+Percent (%).
Apply a border	Press Ctrl+Shift+Ampersand (&).
Remove a border	Press Ctrl+Shift+ underscore (_).
Hide the selected columns	Press Ctrl+0 (zero).
Hide the selected rows	Press Ctrl+9.
Unhide hidden rows within a selection	Press Ctrl+Shift+opening parenthesis.