--- title: "Microsoft Office Excel Shortcut keys" description: "Microsoft Office Excel Shortcut keys" author: "Vijay Shukla" published: 2013-04-02 updated: 2017-11-30 canonical: https://www.mindstick.com/articles/1191/microsoft-office-excel-shortcut-keys category: "shortcut keys" tags: ["shortcut keys"] reading_time: 5 minutes --- # Microsoft Office Excel Shortcut keys CTRL combination [shortcut keys](https://www.mindstick.com/blog/477/shortcut-keys-for-formatting-elements-in-pivottable-view-for-ms-access)\ | ##### Key | ##### Description | | --- | --- | | CTRL+PgUp | Switches between worksheet tabs, from left-to-right. | | CTRL+PgDn | 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](https://www.mindstick.com/blog/328/currency-format-in-javascript) with two [decimal places](https://www.mindstick.com/forum/33881/round-double-type-variable-to-two-decimal-places-in-c-sharp) (negative numbers in parentheses). | | CTRL+SHIFT+% | Applies the Percentage format with no decimal places. | | CTRL+SHIFT+^ | Applies the Exponential number format with two decimal places. | | CTRL+SHIFT+# | Applies the [Date format](https://www.mindstick.com/forum/1976/date-format-comparison-issue) 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](https://www.mindstick.com/blog/157/dialog-box-in-dot-net) to insert blank cells. | | CTRL+Minus (-) | Displays the Delete dialog box to delete the selected cells. | | CTRL+; | Enters the [current date](https://www.mindstick.com/forum/323/find-the-day-name-and-month-name-from-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 objects, displaying objects, and displaying placeholders for 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. | | CTRL+B | Applies or removes bold formatting. | | CTRL+C | Copies the selected cells. | | CTRL+C | Followed by another CTRL+C displays the Clipboard. | | 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+F | Displays the Find and Replace dialog box, with the Find tab selected. | | SHIFT+F5 | Also displays this tab, while SHIFT+F4 repeat 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 Hyperlink dialog box for selected existing hyperlinks. | | 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 dialog box. | | CTRL+SHIFT+P | Opens the Format Cells dialog box with the Font tab 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](https://answers.mindstick.com/qa/95119/what-should-i-do-in-windows-10-if-the-pdf-file-name-is-too-long-and-the-windows-options-don-t-give-me-the-possibility-to-rename-it), location, and [file format](https://www.mindstick.com/forum/12820/how-to-check-file-format). | | CTRL+T | Displays the [Create Table](https://www.mindstick.com/articles/443/how-to-create-table-in-sql-server) 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](https://answers.mindstick.com/qa/31772/which-feature-of-ms-word-helps-you-to-inserts-the-contents-of-the-clipboard-as-text-without-any-formatting) 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. | | CTRL+SHIFT+Z | Uses the Undo or Redo command to reverse or restore the last automatic correction when AutoCorrect Smart Tags are displayed. | --- Original Source: https://www.mindstick.com/articles/1191/microsoft-office-excel-shortcut-keys Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.