Shortcut Keys At A Glance

ctrl+shift+( Unhides any hidden rows within the selection.
ctrl+shift+) Unhides any hidden columns 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 Exponential 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 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.
If the worksheet contains data, ctrl+a selects the current region. Pressing
ctrl+a a second time selects the current region and its summary rows.
Pressing ctrl+a a third 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+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 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+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, 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+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.