KEY |
DESCRIPTION |
CTRL+PgUp |
Switches between worksheet tabs, from left-to-right. |
CTRL+PgDn |
Switches between worksheet tabs, from right-to-left. |
CTRL+SHIFT+( |
Unhides any hidden rows within the selection. |
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 theFunction 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+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 Hyperlink dialog 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+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. |