Knowledge Center
| Shortcut | Description |
|---|---|
| Alt+’ | Allows formatting on a dialog box. |
| Alt+= | Creates a formula to sum all of the above cells. |
| Alt+Backpspace | Undo. |
| Alt+Enter | While typing text in a cell, pressing Alt+Enter will move to the next line, allowing for multiple lines of text in one cell. |
| Alt+Spacebar | Opens the system menu. |
| Alt+Tab | Cycles through applications. |
| Ctrl+0 | Hides columns. |
| Ctrl+1 | Changes the format of the selected cells. |
| Ctrl+2 | Bolds all cells in the highlighted section. |
| Ctrl+3 | Puts italics all cells in the highlighted section. |
| Ctrl+4 | Underlines all cells in highlighted section. |
| Ctrl+5 | Puts a strikethrough all cells in the highlighted section. |
| Ctrl+6 | Show hidden objects |
| Ctrl+7 | Shows or hides the toolbar. |
| Ctrl+8 | Toggles the outline symbols. |
| Ctrl+9 | Hides rows. |
| Ctrl+- | Deletes the selected column or row. |
| Ctrl+- | Delete. |
| Ctrl+/ | Selects the array containing the active cell. |
| Ctrl+; | Enters the current date. |
| Ctrl+[ | Selects all cells referenced by formulas in the highlighted section. |
| Ctrl+\ | Selects the cells that have a static value or don’t match the formula in the active cell. |
| Ctrl+] | Selects cells that contain formulas that reference the active cell. |
| Ctrl+` | Changes between displaying cell values or formulas in the worksheet. |
| Ctrl+’ | Copy above cell |
| Ctrl++ | Insert. |
| Ctrl+A | Select all contents of a worksheet. |
| Ctrl+B | Bold all cells in the highlighted section. |
| Ctrl+D | Fill Content of the selected cell on top to bottom. CTRL + D (i.e. Ctrl+ Down) |
| Ctrl+End | Move to last cell on worksheet. |
| Ctrl+Enter | Fills the selected cells with the current entry. |
| Ctrl+F | Search current sheet. |
| Ctrl+F11 | Inserts a macro sheet. |
| Ctrl+F3 | Open Excel Name Manager. |
| Ctrl+G | Go to a certain area. |
| Ctrl+H | Replace |
| Ctrl+Home | Move to cell A1. |
| Ctrl+I | Puts italics on all cells in the highlighted section. |
| Ctrl+K | Insert hyperlink |
| Ctrl+P | Print the current sheet. |
| Ctrl+Pgup | Switches between worksheet tabs, from left-to-right. |
| Ctrl+Pgdn | Switches between worksheet tabs, from right-to-left |
| Ctrl+R | Fill Right. |
| Ctrl+S | Saves the open worksheet. |
| Ctrl+Shift+! | Applies comma formatting. |
| Ctrl+Shift+# | Applies date formatting. |
| Ctrl+Shift+$ | Applies currency formatting. |
| Ctrl+Shift+% | Applies percentage formatting. |
| Ctrl+Shift+& | Places border around selected cells. |
| Ctrl+Shift+( | Unhide rows. |
| Ctrl+Shift+) | Unhide columns. |
| Ctrl+Shift+* | Selects the current region around the active cell. |
| Ctrl+Shift+: | Enter current time |
| Ctrl+Shift+@ | Applies time formatting. |
| Ctrl+Shift+^ | Applies exponential formatting. |
| Ctrl+Shift+_ | Removes a border. |
| Ctrl+Shift+{ | Selects all cells directly or indirectly referenced by formulas in the highlighted section. |
| Ctrl+Shift+| (pipe) | Selects the cells within a column that don’t match the formula or static value in the active cell. |
| Ctrl+Shift+} | Selects cells which contain formulas that directly or indirectly reference the active cell. |
| Ctrl+Shift+~ | Switches between showing Excel formulas or their values in cells. |
| Ctrl+Shift+” | Copies value from cell above. |
| Ctrl+Shift+= | Inserts a new column or row. |
| Ctrl+Shift+A | Inserts argument names into a formula. |
| Ctrl+Shift+F | Opens the drop-down menu for fonts. |
| Ctrl+Shift+O | Selects all of the cells that contain comments. |
| Ctrl+Shift+P | Launch fonts menu setting |
| Ctrl+Shift+Spacebar | Selects the entire worksheet. |
| Ctrl+Shift+Tab | Activates the previous workbook. |
| Ctrl+Spacebar | Selects the entire column. |
| Ctrl+Tab | Move between Two or more open Excel files. |
| Ctrl+U | Underlines all cells in the highlighted section. |
| Ctrl+V | Pastes everything copied onto the clipboard. |
| Ctrl+W | Closes the current workbook. |
| Ctrl+X | Cuts all cells within the highlighted section. |
| Ctrl+Y | Repeats the last entry. |
| Ctrl+Z | Undo. |
| F1+Alt | Inserts a chart. |
| F1+Alt+Shift | Creates a new worksheet. |
| F1 | Opens the Help menu. |
| F1 + Shift | Opens the “What’s This?” window. |
| F10+Ctrl | Maximize currently selected window. |
| F10 | Activates the menu bar. |
| F11+Alt | Opens the Visual Basic editor. |
| F11 | Creates a chart from selected data. |
| F12+Ctrl | Opens a file. |
| F12+Ctrl+Shift | Prints the current worksheet. |
| F12 | Save as. |
| F2+Alt | Save as. |
| F2+Alt+Shift | Saves the current worksheet. |
| F2 | Edits the selected cell. |
| F2+Shift | Allows the user to edit a cell comment. |
| F3+Ctrl+Shift | Creates names by using those of either row or column labels. |
| F3 | After a name has been created, F3 will paste names. |
| F3+Shift | Opens the Excel formula window. |
| F4+Alt | Exits Excel. |
| F4+Ctrl | Closes current Window. |
| F4 | Convert the range into absolute range.Repeats last action. |
| F5+Ctrl | Restores window size. |
| F5 | Goes to a specific cell. For example, C6. |
| F5+Shift | Brings up a search box. |
| F6+Ctrl | Next workbook. |
| F6+Ctrl+Shift | Previous workbook. |
| F6+Ctrl+Shift | Moves to the previous worksheet window. |
| F6 | Move to the next pane. |
| F6+Shift | Move to previous pane. |
| F7+Ctrl | Moves the window. |
| F7 | Spell check selected text or document. |
| F8+Alt | Opens the macro dialog box. |
| F8+Ctrl | Resizes the window. |
| F8 | Enters Extend Mode. |
| F8+Shift | Add to selection. |
| F9+Ctrl | Minimize current window. |
| F9 | Recalculates every workbook. |
| F9+Shift | Performs calculate function on active sheet. |
| Shift+Down Arrow | Extends the highlighted area down one cell. |
| Shift+End | Highlights all text to the right of the cursor. |
| Shift+Home | Highlights all text to the left of the cursor. |
| Shift+Insert | Pastes what is stored on the clipboard. |
| Shift+Left Arrow | Extends the highlighted area left one character. |
| Shift+Page Down | In a single column, highlights all cells above that which are selected. |
| Shift+Page Up | In a single column, highlights all cells above that which are selected. |
| Shift+Up Arrow | Extends the highlighted area up one cell. |
| Shift +Right Arrow | Extends the highlighted area right one character. |
| Shortcut | Description |
|---|---|
| Alt + F11 | This toggles switch displays the VBE from the application window and vice versa. |
| Ctrl + G | Displays the Immediate window. |
| Ctrl + F | Opens the Find dialog box. |
| F3 | Finds Next. |
| Shift + F3 | Finds Previous. |
| Ctrl + H | Opens the Replace dialog box. |
| Ctrl + Z | Cancels the last keyboard stroke or the last mouse operation (when possible). |
| F5 | Runs the current procedure or continues execution after pausing. |
| Ctrl + Break | Halts a procedure. |
| Shift + F5 | Terminates a procedure and resets all variables to their default values. |
| Shift + F10 | Displays the active window’s shortcut menu. |
| Ctrl + R | Opens the Project Explorer. |
| F4 | Opens the Properties window. |
| F2 | Opens the Object Browser. |
| F1 | Opens VBA Help. |
| F7 | Gives focus to the open module window. |
| Ctrl + Down Arrow | Selects the next procedure. |
| Ctrl + Up Arrow | Selects the previous procedure. |
| Ctrl + Page Down | Shifts one screen down. |
| Ctrl + Page Up | Shifts one screen up. |
| Ctrl + Shift + F2 | Goes to the last position. |
| Ctrl + Home | Goes to the beginning of module. (Also in the Immediate window.) |
| Ctrl + End | Goes to the end of module. (Also in the Immediate window.) |
| Ctrl + Right Arrow | Moves one word to the right. |
| Ctrl + Left Arrow | Moves one word to the left. |
| End | Moves to the end of the line. |
| Home | Moves to the beginning of the line. |
| Ctrl + Y | Deletes the current line. |
| Ctrl + Delete | Deletes to the end of a word. |
| Ctrl + Shift + F9 | Clears all breakpoints. |
| Project Explorer | |
| F7 Shift + Enter | Opens the selected file’s module. |
| Home | Selects the first file in the list. |
| End | Selects the last file in the list. |
| Right arrow | Expands a sublist. |
| Left arrow | Collapses a sublist. |
| Up arrow | Moves up the list one item at a time. |
| Down arrow | Moves down the list one item at a time. |