Take a few Excel Keyboard Shortcuts

Take a few Excel Keyboard Shortcuts

Who doesn't need to save a little time here and there? Keyboard shortcuts can help you do just that. Here's a list of shortcuts for Excel that will make life a little easier:

• [Ctrl][Shift]A: Use this combination after typing a function name, and it will automatically enter the parentheses and the argument names for the function you typed.
• [Alt][F8]: Displays the Macro dialog box.
• [Alt][F11]: Opens the VBA Editor or switches to it if it's already open.
• [Ctrl]1: Displays the Format Cells dialog box.
• [Ctrl][Shift][~]: Applies the General format.
• [Ctrl][Shift][$]: Formats the current cells as Currency.
• [Ctrl][Shift][#]: Applies the Date format.
• [Shift][F10]: Displays the shortcut menu that applies to the selection.
• [F6]: Moves to the next pane in a split worksheet.
• [Shift][F6]: Moves to the previous pane.
• [Ctrl][F6]: Moves to the next workbook window.
• [Ctrl][Shift][F6]: Moves back to the last workbook window.
• [F3]: Opens a dialog box to paste a Named Range into a formula.
• [Ctrl][F3]: Opens the Define Name dialog box.
• [Ctrl][Shift][F3]: Automatically creates Named Ranges from the headers for the selected table of data with row or column headers.
• [Shift][F3]: Inserts an equal sign (=) and opens the Paste Function dialog box to help you pick a formula.
• [Alt][=]: Inserts the AutoSum function.
• [Ctrl][;]: Inserts the current date.