Shortcut key | Action |
Ctrl+A | Selects the entire
worksheet. If the worksheet contains data, Ctrl+A selects the current region. Pressing Ctrl+A a second time selects the entire worksheet. When the insertion point is to the right of a function name in a formula, displays the Function Arguments dialog box. Ctrl+Shift+A inserts the argument names and parentheses when the insertion point is to the right of a function name in a formula. |
Ctrl+B | Applies or removes bold formatting. |
Ctrl+C | Copies the selected cells. |
Ctrl+D | Uses the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below. |
Ctrl+E | Adds more values to the active column by using data surrounding that column. |
Ctrl+F | Displays the Find and Replace
dialog box, with the Find tab selected. Shift+F5 also displays this tab, while Shift+F4 repeats the last Find action. Ctrl+Shift+F opens the Format Cells dialog box with the Font tab selected. |
Ctrl+G | Displays the Go To dialog box. F5 also displays this dialog box. |
Ctrl+H | Displays the Find and Replace dialog box, with the Replace tab selected. |
Ctrl+I | Applies or removes italic formatting. |
Ctrl+J | # |
Ctrl+K | Displays the Insert Hyperlink dialog box for new hyperlinks or the Edit Hyperlink dialog box for selected existing hyperlinks. |
Ctrl+L | Displays the Create Table dialog box. Ctrl+T also does same. |
Ctrl+M | # |
Ctrl+N | Creates a new, blank workbook. |
Ctrl+O | Displays the Open dialog box to open or find a file. |
Ctrl+P | Displays the Print tab in Microsoft Office Backstage view. |
Ctrl+Q | Displays the Quick Analysis options for your data when you have cells that contain that data selected. |
Ctrl+R | Uses the Fill Right command to copy the contents and format of the leftmost cell of a selected range into the cells to the right. |
Ctrl+S | Saves the active file with its current file name, location, and file format. |
Ctrl+T | Displays the Create Table dialog box. Ctrl+L also does same. |
Ctrl+U | Applies or removes underlining. |
Ctrl+V | Inserts the contents of the Clipboard at the insertion point and replaces any selection. Available only after you have cut or copied an object, text, or cell contents. |
Ctrl W | Closes the selected workbook window. |
Ctrl+X | Cuts the selected cells. |
Ctrl+Y | Repeats the last command or action, if possible. |
Ctrl+Z | Uses the Undo command to reverse the last command or to delete the last entry that you typed. |
Ctrl+F1 | Displays or hides the ribbon |
Ctrl+F2 | Displays the print preview area on the Print tab in the Backstage view. |
Ctrl+F3 | Displays name manager |
Ctrl+F4 | Close excel |
Ctrl+F5 | XL, Restore window size |
Ctrl+F6 | Next workbook window |
Ctrl+F7 | Performs the Move command on the workbook window when it is not maximized. Use the arrow keys to move the window, and when finished press Enter, or Esc to cancel. |
Ctrl+F8 | Performs the Size command (on the Control menu for the workbook window) when a workbook is not maximized. |
Ctrl+F9 | Minimize workbook |
Ctrl+F10 | Maximizes or restores the selected workbook window |
Ctrl+F11 | Inset 4.0 Macro sheet |
Ctrl+F12 | File Open dialog box |
Ctrl+1 | Format cells dialog box |
Ctrl+2 | Bold |
Ctrl+3 | Italic |
Ctrl+4 | Underline |
Ctrl+5 | Strikethrough |
Ctrl+6 | Show/Hide objects |
Ctrl+7 | Show/Hide Standard toolbar |
Ctrl+8 | Toggle Outline symbols |
Ctrl+9 | Hide rows |
Ctrl+0 | Hide columns |
CTRL+/ | Select the array containing the active cell. |
CTRL+\ | In a selected row, select the cells that don’t match the formula or static value in the active cell. |
CTRL+[ | Select all cells directly referenced by formulas in the selection. |
CTRL+] | Select cells that contain formulas that directly reference the active cell. |
Ctrl+: | Insert Current Time |
Ctrl+; | Insert Current Date |
Ctrl+" | Copy Value from Cell Above |
Ctrl++ | Insert |
Ctrl+- | Delete |
Ctrl+’ | Copy Formula from Cell Above |
Ctrl+. | # |
Ctrl+, | # |
Ctrl+< | # |
Ctrl+> | # |
Ctrl+End | Moves to the last cell on a worksheet, to the lowest used row of the rightmost used column. If the cursor is in the formula bar, Ctrl+End moves the cursor to the end of the text |
Ctrl+Enter | Fills the selected cell range with the current entry |
Ctrl+Home | Moves to the beginning of a worksheet |
Ctrl+Page Down | Moves to the next sheet in a workbook |
Ctrl+Page Up | Moves to the previous sheet in a workbook |
Ctrl+Tab | Switches to the next tab in dialog box |
Ctrl+Spacebar | Selects an entire column in a worksheet |
Ctrl+Arrow Key | Moves to the edge of the current data region in a worksheet |
Labels: Excel, Excel Shortcuts