Table of Contents
Excel Keyboard Shortcuts #
| TAB | Move to the next cell, to the right of the currently selected cell. |
| CTRL+A | Select all contents of a worksheet. |
| CTRL+B | Bold all cells in the highlighted section. |
| CTRL+C | Copy all cells in the highlighted section. |
| CTRL+D | Fill down. Fills the cell beneath with the contents of the selected cell. To fill more than one cell, select the source cell and press CTRL+SHIFT+DOWN to select multiple cells. Then press CTRL+D to fill them with the contents of the original cell. |
| CTRL+F | Search current sheet |
| CTRL+G | Go to a certain area. |
| CTRL+H | Find and replace |
| CTRL+I | Puts italics on all cells in the highlighted section. |
| CTRL+K | Inserts a hyperlink. |
| CTRL+L | Opens the Create Table dialog box. |
| CTRL+N | Creates a new workbook. |
| CTRL+O | Opens a workbook. |
| CTRL+P | Print the current sheet. |
| CTRL+R | Fill right. Fills the cell to the right with the contents of the selected cell. To fill more than one cell, select the source cell and press CTRL+SHIFT+RIGHT to select multiple cells. Then press CTRL+R to fill them with the contents of the original cell. |
| CTRL+S | Saves the open worksheet. |
| CTRL+T | Open the Create Table dialog box. |
| 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 in the highlighted section. |
| CTRL+Y | Repeats the last entry (redo). |
| CTRL+Z | Undo the last action. |
| 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 | Shows or hides objects. |
| CTRL+7 | Shows or hides the toolbar. |
| CTRL+8 | Toggles the outline symbols. |
| CTRL+9 | Hides rows. |
| CTRL+0 | Hides columns. |
| CTRL+SHIFT+ COLON (:) | Enters the current time. |
| CTRL+ SEMI COLON (;) | Enters the current date. |
| CTRL+` | Changes between displaying cell values or formulas in the worksheet. |
| CTRL+’ | Copies a formula from the cell above. |
| CTRL+SHIFT+” | Copies value from cell above. |
| CTRL+- | Deletes the selected column or row. |
| CTRL+SHIFT+= | Inserts a new column or row. |
| CTRL+SHIFT+~ | Switches between showing Excel formulas or their values in cells. |
| CTRL+SHIFT+@ | Applies time formatting. |
| CTRL+SHIFT+! | Applies comma formatting. |
| CTRL+SHIFT+$ | Applies currency formatting. |
| CTRL+SHIFT+# | Applies date formatting. |
| CTRL+SHIFT+% | Applies percentage formatting. |
| CTRL+SHIFT+^ | Applies exponential formatting. |
| CTRL+SHIFT+* | Selects the current region around the active cell. |
| CTRL+SHIFT+& | Places border around selected cells. |
| CTRL+SHIFT+_ | Removes a border. |
| CTRL++ | Insert. |
| CTRL+- | Delete. |
| CTRL+SHIFT+( | Unhide rows. |
| CTRL+SHIFT+) | Unhide columns. |
| CTRL+/ | Selects the array containing the active cell. |
| CTRL+\ | Selects the cells that have a static value or don’t match the formula in the active cell. |
| CTRL+[ | Selects all cells referenced by formulas in the highlighted section. |
| CTRL+] | Selects cells that contain formulas that reference the active cell. |
| CTRL+SHIFT+{ | Selects all cells directly or indirectly referenced by formulas in the highlighted section. |
| CTRL+SHIFT+} | Selects cells which contain formulas that directly or indirectly reference the active cell. |
| CTRL+SHIFT+| (PIPE) | Selects the cells within a column that don’t match the formula or static value in the active cell. |
| CTRL+ENTER | Fills the selected cells with the current entry. |
| CTRL+SPACEBAR | Selects the entire column. |
| CTRL+SHIFT+SPACEBAR | Selects the entire worksheet. |
| CTRL+HOME | Move to cell A1. |
| CTRL+END | Move to last cell with text on the worksheet. |
| CTRL+TAB | Move between Two or more open Excel files. |
| CTRL+SHIFT+TAB | Activates the previous workbook. |
| 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 | Opens the drop-down menu for point size. |
| SHIFT+INSERT | Pastes what is stored on the clipboard. |
| SHIFT+PAGE UP | In a single column, highlights all cells above that are selected. |
| SHIFT+PAGE DOWN | In a single column, highlights all cells below that are selected. |
| SHIFT+HOME | Highlights all text to the left of the cursor. |
| SHIFT+END | Highlights all text to the right of the cursor. |
| SHIFT+UP ARROW | Extends the highlighted area up one cell. |
| SHIFT+DOWN ARROW | Extends the highlighted area down one cell. |
| SHIFT+LEFT ARROW | Extends the highlighted area left one character. |
| SHIFT +RIGHT ARROW | Extends the highlighted area right one character. |
| ALT+TAB | Cycles through applications. |
| ALT+SPACEBAR | Opens the system menu. |
| ALT+BACKSPACE | Undo. |
| ALT+ENTER | While typing text in a cell, pressing ALT+ENTER moves to the next line, allowing for multiple lines of text in one cell. |
| ALT+= | Creates a formula to sum all of the above cells. |
| ALT+’ | Allows formatting on a dialog box. |
| F1 | Opens the help menu. |
| F2 | Edits the selected cell. |
| F3 | After a name is created, F3 will paste names |
| F4 | Repeats last action. For example, if you changed the color of text in another cell, pressing F4 changes the text in cell to the same color. |
| F5 | Goes to a specific cell. For example, C6. |
| F6 | Move to the next pane. |
| F7 | Spell check selected text or document. |
| F8 | Enters Extend Mode. |
| F9 | Recalculates every workbook. |
| F10 | Activates the menu bar. |
| F11 | Creates a chart from selected data. |
| F12 | Save As option. |
| SHIFT+F1 | Opens the “What’s This?” window. |
| SHIFT+F2 | Allows the user to edit a cell comment. |
| SHIFT+F3 | Opens the Excel formula window. |
| SHIFT+F5 | Brings up a search box. |
| SHIFT+F6 | Move to previous pane. |
| SHIFT+F8 | Add to selection. |
| SHIFT+F9 | Performs calculate function on active sheet. |
| CTRL+F3 | Open Excel Name Manager. |
| CTRL+F4 | Closes current window. |
| CTRL+F5 | Restores window size. |
| CTRL+F6 | Next workbook |
| CTRL+SHIFT+F6 | Previous workbook. |
| CTRL+F7 | Moves the window |
| CTRL+F8 | Resizes the window. |
| CTRL+F9 | Minimize current window. |
| CTRL+F10 | Maximize currently selected window |
| CTRL+F11 | Inserts a Macro sheet. |
| CTRL+F12 | Opens a file. |
| CTRL+SHIFT+F3 | Creates names by using those of either row or column labels. |
| CTRL+SHIFT+F6 | Moves to the previous worksheet window. |
| CTRL+SHIFT+F12 | Prints the current worksheet. |
| ALT+F1 | Inserts a chart. |
| ALT+F2 | Save As option. |
| ALT+F4 | Exits Excel. |
| ALT+F8 | Opens the macro dialog box. |
| ALT+F11 | Opens the Visual Basic editor. |
| ALT+SHIFT+F1 | Creates a new worksheet. |
| ALT+SHIFT+F2 | Saves the current worksheet. |
