Excel Keyboard Shortcuts PDF

## Excel Keyboard Shortcuts ### Window Navigation | Shortcut | Description | |---|---| | 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. | | Ct...

## Excel Keyboard Shortcuts ### Window Navigation | Shortcut | Description | |---|---| | 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. | ### Cell Formatting | Shortcut | Description | |---|---| | 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+: | Enters the current time. | | Ctrl+; | 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. | ### Navigation and Editing | Shortcut | Description | |---|---| | 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 will change 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. | ### Other Shortcuts | Shortcut | Description | |---|---| | 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+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+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. | | Ctrl+Z | Undo the last action. |