< Back
Excel: Control key shortcuts
Post
Ctrl combination shortcut keys
| Key | Description |
| Ctrl+PgDn | Switches between worksheet tabs, from left-to-right. |
| Ctrl+PgUp | Switches between worksheet tabs, from right-to-left. |
| Ctrl+Shift+& | Applies the outline border to the selected cells. |
| Ctrl+Shift_ | Removes the outline border from the selected cells. |
| Ctrl+Shift+~ | Applies the General number format. |
| Ctrl+Shift+$ | Applies the Currency format with two decimal places (negative numbers in parentheses). |
| Ctrl+Shift+% | Applies the Percentage format with no decimal places. |
| Ctrl+Shift+^ | Applies the Scientific number format with two decimal places. |
| Ctrl+Shift+# | Applies the Date format with the day, month, and year. |
| Ctrl+Shift+@ | Applies the Time format with the hour and minute, and AM or PM. |
| Ctrl+Shift+! | Applies the Number format with two decimal places, thousands separator, and minus sign (-) for negative values. |
| Ctrl+Shift+* | Selects the current region around the active cell (the data area enclosed by blank rows and blank columns).In a PivotTable, it selects the entire PivotTable report. |
| Ctrl+Shift+: | Enters the current time. |
| Ctrl+Shift+" | Copies the value from the cell above the active cell into the cell or the Formula Bar. |
| Ctrl+Shift+Plus (+) | Displays the Insert dialog box to insert blank cells. |
| Ctrl+Minus (-) | Displays the Delete dialog box to delete the selected cells. |
| Ctrl+; | Enters the current date. |
| Ctrl+` | Alternates between displaying cell values and displaying formulas in the worksheet. |
| Ctrl+' | Copies a formula from the cell above the active cell into the cell or the Formula Bar. |
| Ctrl+1 | Displays the Format Cells dialog box. |
| Ctrl+2 | Applies or removes bold formatting. |
| Ctrl+3 | Applies or removes italic formatting. |
| Ctrl+4 | Applies or removes underlining. |
| Ctrl+5 | Applies or removes strikethrough. |
| Ctrl+6 | Alternates between hiding and displaying objects. |
| Ctrl+8 | Displays or hides the outline symbols. |
| Ctrl+9 | Hides the selected rows. |
| Ctrl+0 | Hides the selected columns. |
| 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.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 | Invoke Flash Fill to automatically recognize patterns in adjacent columns and fill the current 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+K | Displays the Insert Hyperlink dialog box for new hyperlinks or the Edit Hyperlinkdialog box for selected existing hyperlinks. |
| Ctrl+L | Displays the Create Table dialog box. |
| Ctrl+N | Creates a new, blank workbook. |
| Ctrl+O | Displays the Open dialog box to open or find a file. |
| Ctrl+Shift+O | selects all cells that contain comments. |
| Ctrl+P | Displays the Print tab in Microsoft Office Backstage view. |
| Ctrl+Shift+P | opens the Format Cells dialog box with the Font tab selected. |
| 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+U | Applies or removes underlining. |
| Ctrl+Shift+U | switches between expanding and collapsing of the formula bar. |
| 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+Alt+V | displays the Paste Special dialog box. Available only after you have cut or copied an object, text, or cell contents on a worksheet or in another program. |
| 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. |