Shortcut | Description |
Tab | To Move to the next cell, to the right of the currently selected cell. |
Ctrl+A | To Select all contents of a worksheet. |
Ctrl+B | To Bold all cells in the highlighted section. |
Ctrl+C | To Copy all cells in the highlighted section. |
Ctrl+D | To 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 arrow to select multiple cells. Then press Ctrl+D to fill them with the contents of the original cell. |
Ctrl+F | To Search current sheet. |
Ctrl+G | To Go to a certain area. |
Ctrl+H | To Find and replace. |
Ctrl+I | To Puts italics on all cells in the highlighted section. |
Ctrl+K | To Inserts a hyperlink. |
Ctrl+L | To Opens the Create Table dialog box. |
Ctrl+N | To Creates a new workbook. |
Ctrl+O | To Opens a workbook. |
Ctrl+P | To Print the current sheet. |
Ctrl+R | To 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 arrow to select multiple cells. Then press Ctrl+R to fill them with the contents of the original cell. |
Ctrl+S | To Saves the open worksheet. |
Ctrl+T | To Open the Create Table dialog box. |
Ctrl+U | To Underlines all cells in the highlighted section. |
Ctrl+V | To Pastes everything copied onto the clipboard. |
Ctrl+W | To Closes the current workbook. |
Ctrl+X | To Cuts all cells in the highlighted section. |
Ctrl+Y | To Repeats the last entry (redo). |
Ctrl+Z | To Undo the last action. |
Ctrl+1 | To Changes the format of the selected cells. |
Ctrl+2 | To Bolds all cells in the highlighted section. |
Ctrl+3 | To Puts italics all cells in the highlighted section. |
Ctrl+4 | To Underlines all cells in highlighted section. |
Ctrl+5 | To Puts a strikethrough all cells in the highlighted section. |
Ctrl+6 | To Shows or hides objects. |
Ctrl+7 | To Shows or hides the toolbar. |
Ctrl+8 | To Toggles the outline symbols. |
Ctrl+9 | To Hides rows. |
Ctrl+0 | To Hides columns. |
Ctrl+Shift+: | To Enters the current time. |
Ctrl+; | To Enters the current date. |
Ctrl+` | To Changes between displaying cell values or formulas in the worksheet. |
Ctrl+’ | To Copies a formula from the cell above. |
Ctrl+Shift+” | To Copies value from cell above. |
Ctrl+- | To Deletes the selected column or row. |
Ctrl+Shift+= | To Inserts a new column or row. |
Ctrl+Shift+~ | To Switches between showing Excel formulas or their values in cells. |
Ctrl+Shift+@ | To Applies time formatting. |
Ctrl+Shift+! | To Applies comma formatting. |
Ctrl+Shift+$ | To Applies currency formatting. |
Ctrl+Shift+# | To Applies date formatting. |
Ctrl+Shift+% | To Applies percentage formatting. |
Ctrl+Shift+^ | To Applies exponential formatting. |
Ctrl+Shift+* | To Selects the current region around the active cell. |
Ctrl+Shift+& | To Places border around selected cells. |
Ctrl+Shift+_ | To Removes a border. |
Ctrl++ | To Insert. |
Ctrl+- | To Delete. |
Ctrl+Shift+( | To Unhide rows. |
Ctrl+Shift+) | To Unhide columns. |
Ctrl+/ | To Selects the array containing the active cell. |
Ctrl+\ | To Selects the cells with a static value or don’t match the formula in the active cell. |
Ctrl+[ | To Selects all cells referenced by formulas in the highlighted section. |
Ctrl+] | To Selects cells that contain formulas that reference the active cell. |
Ctrl+Shift+{ | To Selects all cells directly or indirectly referenced by formulas in the highlighted section. |
Ctrl+Shift+} | To Selects cells which contain formulas that directly or indirectly reference the active cell. |
Ctrl+Shift+| (pipe) | To Selects the cells within a column that don’t match the formula or static value in the active cell. |
Ctrl+Enter | To Fills the selected cells with the current entry. |
Ctrl+Spacebar | To Selects the entire column. |
Ctrl+Shift+Spacebar | To Selects the entire worksheet. |
Ctrl+Home | To Move to cell A1. |
Ctrl+End | To Move to last cell with text on the worksheet. |
Ctrl+Tab | To Move between Two or more open Excel files. |
Ctrl+Shift+Tab | To Activates the previous workbook. |
Ctrl+Shift+A | To Inserts argument names into a formula. |
Ctrl+Shift+F | To Opens the drop-down menu for fonts. |
Ctrl+Shift+O | To Selects all of the cells that contain comments. |
Ctrl+Shift+P | To Opens the drop-down menu for point size. |
Shift+Insert | To Pastes what is stored on the clipboard. |
Shift+Page | To In a single column, highlights all cells above that are selected. |
Up | |
Shift+Page | To In a single column, highlights all cells above that are selected. |
Down | |
Shift+Home | To Highlights all text to the left of the cursor. |
Shift+End | To Highlights all text to the right of the cursor. |
Shift+Up Arrow | To Extends the highlighted area up one cell. |
Shift+Down Arrow | To Extends the highlighted area down one cell. |
Shift+Left Arrow | To Extends the highlighted area left one character. |
Shift+Right Arrow | To Extends the highlighted area right one character. |
Alt+Tab | To Cycles through applications. |
Alt+Spacebar | To Opens the system menu. |
Alt+Backspace | To Undo. |
Alt+Enter | To While typing text in a cell, pressing Alt+Enter moves to the next line, allowing for multiple lines of text in one cell. |
Alt+= | To Creates a formula to sum all of the above cells. |
Alt+’ | To Allows formatting on a dialog box. |
F1 | To Opens the help menu. |
F2 | To Edits the selected cell. |
F3 | To After a name is created, F3 will paste names. |
F4 | To 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 | To Goes to a specific cell. For example, C6. |
F6 | To Move to the next pane. |
F7 | To Spell check selected text or document. |
F8 | To Enters Extend Mode. |
F9 | To Recalculates every workbook. |
F10 | To Activates the menu bar. |
F11 | To Creates a chart from selected data. |
F12 | To Save As option. |
Shift+F1 | To Opens the “What’s This?” window. |
Shift+F2 | To Allows the user to edit a cell comment. |
Shift+F3 | To Opens the Excel formula window. |
Shift+F5 | To Brings up a search box. |
Shift+F6 | To Move to previous pane. |
Shift+F8 | To Add to selection. |
Shift+F9 | To Performs calculate function on active sheet. |
Ctrl+F3 | To Open Excel Name Manager. |
Ctrl+F4 | To Closes current window. |
Ctrl+F5 | To Restores window size. |
Ctrl+F6 | To Next workbook. |
Ctrl+Shift+F6 | To Previous workbook. |
Ctrl+F7 | To Moves the window. |
Ctrl+F8 | To Resizes the window. |
Ctrl+F9 | To Minimize current window. |
Ctrl+F10 | To Maximize currently selected window. |
Ctrl+F11 | To Inserts a macro sheet. |
Ctrl+F12 | To Opens a file. |
Ctrl+Shift+F3 | To Creates names by using those of either row or column labels. |
Ctrl+Shift+F6 | To Moves to the previous worksheet window. |
Ctrl+Shift+F12 | To Prints the current worksheet. |
Alt+F1 | To Inserts a chart. |
Alt+F2 | To Save As option. |
Alt+F4 | To Exits Excel. |
Alt+F8 | To Opens the macro dialog box. |
Alt+F11 | To Opens the Visual Basic editor. |
Alt+Shift+F1 | To Creates a new worksheet. |
Alt+Shift+F2 | To Saves the current worksheet. |