BookmarkPrint
Contents
Home > Microsoft Office > Excel > Keyboard Shortcuts - Excel


Keyboard Shortcuts - Excel
A list of keyboard shortcuts to use in Excel 2016, 2013, and 2010.
Quick links to sections in this article: 
File Commands  Working in Worksheet/Workbook       Working With Cells 
Formatting Numbers       Formatting Text Working With Formulas 
Using the Clipboard  Display/Hide  Find/Replace 

File Commands[Ctrl] + [N]  Creates a new, blank file.
[Ctrl] + [O]  Displays the Open dialog box to open or find a file.
[Ctrl] + [P]  Displays the Print tab.
[Ctrl] + [S]  Saves the active file with its current file name, location, and file format.
Working in Worksheet/Workbook[Ctrl] + [A]  Selects the entire worksheet. If the worksheet contains data, it will select the current region. Pressing it 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] + [W]  Closes the selected workbook window.
[Ctrl] + [G]  Displays the Go To dialog box.
[Ctrl] + [L]  Displays the Create Table dialog box.
[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] + [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] + [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 you typed.
Working With Cells[Ctrl] + [1]  Displays the Format Cells dialog box.
[Ctrl] + [Shift] + [&]  Applies the outline border to the selected cells.
[Ctrl] + [Shift] + [_]  Removes the outline border from the selected cells.
[Ctrl] + [-] (minus)  Displays the Delete dialog box to delete the selected cells.
[Ctrl] + [Shift] + [+] (plus)  Displays the Insert dialog box to insert blank cells. 
[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] + [;]  Enters the current date.
[Ctrl] + [Shift] + [O]  Selects all cells that contains comments.
Formatting Numbers[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.
Formatting Text[Ctrl] + [2]  Applies or removes bold formatting.
[Ctrl] + [B]  Applies or removes bold formatting.
[Ctrl] + [3]  Applies or removes italic formatting.
[Ctrl] + [I]  (capital i) Applies or removes italic formatting.
[Ctrl] + [4]  Applies or removes underlining.
[Ctrl] + [U]  Applies or removes underlining.
[Ctrl] + [5]  Applies or removes strikethrough.
[Ctrl] + [Shift] + [P]  Opens the Format Cells dialog box to the Font tab.
[Ctrl] + [Shift] + [F]  Opens the Format Cells dialog box to the Font tab.
[Ctrl] + [K]  Displays the Insert Hyperlink dialog box for new hyperlinks or the Edit Hyperlink dialog box for selected existing hyperlinks.
Working With Formulas[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] + ["]  Copies the value from the cell above the active cell into the cell or the Formula bar.
[Ctrl] + [Shift] + [U]  Switches between expanding and collapsing the formula bar.
[Ctrl] + [Shift] + [A]  Inserts the argument names and parentheses when the insertion point is to the right of a function name in a formula.
Using the Clipboard[Ctrl] + [C]  Copies the selected cells.
[Ctrl] + [X]  Cuts the selected cells.
[Ctrl] + [V]  Inserts the contents of the Clipboard at the insertion point and replaces any selection. Available only after you cut or copied an object, text, or cell contents.
[Ctrl] + [Alt] + [V]  Displays the Paste Special dialog box.
Display/Hide[Ctrl] + [Shift] + [(]  Displays any hidden rows within the selection.
[Ctrl] + [9]  Hides the selected rows.
[Ctrl] + [0]  Hides the selected columns.
[Ctrl] + [6]  Alternates between hiding and displaying objects.
[Ctrl] + [8]  Displays or hides the outline symbols.
Find/Replace[Ctrl] + [F]  Opens the Find and Replace dialog box to the Find tab.
[Ctrl] + [H]  Opens the Find and Replace dialog box to the Replace tab.
[Shift] + [F4]  Repeats the last Find function. 

Adapted from:
http://office.microsoft.com/en-us/excel-help/keyboard-shortcuts-in-excel-2010-HP010342494.aspx


Related Articles


helpdesk.etown.edu/helpconsole2012/kb/default.aspx?pageid=keyboard_shortcuts1