All keyboard shortcuts

A common request during our Excel training courses is list all Excel keyboard shortcuts. As the list is extremely long, please find all Excel keyboard shortcuts listed below.

Looking for Microsoft Excel training in Sydney? Click here for our courses.


CTRL+(
Displays any hidden rows within highlighted area.

CTRL+)
Displays any hidden columns within highlighted area.

CTRL+&
Applies outline border to highlighted cells.

CTRL+_
Takes away outline border from highlighted cells.

CTRL+~
Applies General number format.

CTRL+$
Applies Currency format with two decimal places (negative numbers in parentheses).

CTRL+%
Applies Percentage format with no decimal places.

CTRL+^
Applies Exponential number format with two decimal places.

CTRL+#
Applies Date format with day, month, and year.

CTRL+@
Applies Time format with hour and minute, and AM or PM.

CTRL+!
Applies Number format with two decimal places, thousands separator, and minus sign (-) for negative values.

CTRL+-
Shows Delete dialog box to delete highlighted cells.

CTRL+*
Selects current region around active cell (the data area enclosed by blank rows and blank columns).

CTRL+:
Enters current time.

CTRL+;
Enters current date.

CTRL+`
Alternates between displaying cell values and displaying formulas in worksheet.

CTRL+’
Copies formula from cell above active cell into cell or Formula Bar.

CTRL+”
Copies value from cell above active cell into cell or Formula Bar.

CTRL++
Shows Insert dialog box to insert blank cells.

CTRL+1
Shows Format Cells dialog box.

CTRL+2
Applies or takes away bold formatting.

CTRL+3
Applies or takes away italic formatting.

CTRL+4
Applies or takes away underlining.

CTRL+5
Applies or takes away strikethrough.

CTRL+6
Alternates between hiding objects, displaying objects, and displaying placeholders for objects.

CTRL+7
Shows or hides Standard toolbar.

CTRL+8
Shows or hides outline symbols.

CTRL+9
Hides highlighted rows.

CTRL+0
Hides highlighted columns.

CTRL+A
Selects entire worksheet or data table

CTRL+SHIFT+A
Inserts argument names and parentheses when insertion point is to right of function name in formula.

CTRL+B
Applies or takes away bold formatting.

CTRL+C
Copies highlighted cells.

CTRL+C
Followed by another CTRL+C shows Microsoft Office Clipboard.

CTRL+D
Uses Fill Down command to copy contents and format of topmost cell of highlighted range into cells below.

CTRL+F
Shows Find dialog box.

CTRL+G
Shows Go To dialog box.

CTRL+H
Shows Find and Replace dialog box.

CTRL+I
Applies or takes away italic formatting.

CTRL+K
Shows Insert Hyperlink dialog box for new hyperlinks or Edit Hyperlink dialog box for highlighted existing hyperlinks.

CTRL+L
Shows Create List dialog box.

CTRL+N
Creates new, blank file.

CTRL+O
Shows Open dialog box to open or find file.

CTRL+SHIFT+O
Selects all cells that contain comments.

CTRL+P
Shows Print dialog box.

CTRL+R
Uses Fill Right command to copy contents and format of leftmost cell of highlighted range into cells to right.

CTRL+S
Saves active file with its current file name, location, and file format.

CTRL+U
Applies or takes away underlining.

CTRL+V
Inserts contents of Clipboard at insertion point and replaces any selection.

CTRL+W
Closes highlighted workbook window.

CTRL+X
Cuts highlighted cells.

CTRL+Y
Repeats last command or action, if possible.

CTRL+Z
Uses Undo command to reverse last command or to delete last entry you typed.

CTRL+SHIFT+Z
Undo or Redo command to reverse or restore last automatic correction when AutoCorrect Smart Tags are displayed.

F1
Shows Help task pane.

CTRL+F1
CTRL+F1 closes and reopens current task pane.

ALT+F1
ALT+F1 creates chart of data in current range.

ALT+SHIFT+F1
ALT+SHIFT+F1 inserts new worksheet.

F2
Edits active cell and positions insertion point at end of cell contents.

SHIFT+F2
SHIFT+F2 edits cell comment.

F3
Pastes defined name into formula.

SHIFT+F3
SHIFT+F3 shows Insert Function dialog box.

F4
Repeats last command or action, if possible.

CTRL+F4
CTRL+F4 closes highlighted workbook window.

F5
Shows Go To dialog box.

CTRL+F5
CTRL+F5 restores window size of highlighted workbook window.

F6
Changes to next pane in worksheet that has been split (Window menu, Split command).

SHIFT+F6
SHIFT+F6 changes to previous pane in worksheet that has been split.

CTRL+F6
CTRL+F6 changes to next workbook window when more than one workbook window is open.

F7
Shows Spelling dialog box to check spelling in active worksheet or highlighted range.

CTRL+F7
Performs Move command on workbook window when not maximized. Use arrow keys to move window, then press ESC.

F8
Turns extend mode on or off. In extend mode, EXT appears in status line, and arrow keys extend highlighted area.

SHIFT+F8
SHIFT+F8 enables you to add non-adjacent cell or range to selection of cells by using arrow keys.

CTRL+F8
CTRL+F8 performs Size command (on Control menu for workbook window) when workbook is not maximized.

ALT+F8
ALT+F8 shows Macro dialog box to run, edit, or delete macro.

F9
Calculates all worksheets in all open workbooks.

F9 then enter
Calculates highlighted portion of formula and replaces with calculated value.

SHIFT+F9
SHIFT+F9 calculates active worksheet.

CTRL+ALT+F9
Forces calculation in all worksheets in all open workbooks

CTRL+ALT+SHIFT+F9
Rechecks dependent formulas then calculates all cells in all open workbooks.

F10
Selects menu bar or closes an open menu and submenu at same time.

SHIFT+F10
SHIFT+F10 shows shortcut menu for highlighted item.

ALT+SHIFT+F10
Shows menu or message for smart tag or next smart tag.

CTRL+F10
CTRL+F10 maximizes or restores highlighted workbook window.

F11
Creates chart of data in current range.

SHIFT+F11 or ALT+SHIFT+F1
SHIFT+F11 inserts new worksheet.

ALT+F11
ALT+F11 By the way, this list is copyright T7 Training Systems 2010. ALT+F11 opens Visual Basic Editor, in which you can create macro by using Visual Basic for Applications (VBA).

ALT+SHIFT+F11
ALT+SHIFT+F11 opens Microsoft Script Editor, where you can add text, edit HTML tags, and modify any script code.

F12
Shows Save As dialog box.

ENTER
Complete cell entry and select cell below.

ALT+ENTER
Start new line in same cell.

CTRL+ENTER
Fill highlighted cell range with current entry.

SHIFT+ENTER
Complete cell entry and select previous cell above.

TAB
Complete cell entry and select next cell to right.

SHIFT+TAB
Complete cell entry and select previous cell to left.

ESC
Cancel cell entry.

Arrow keys
Move one character up, down, left, or right.

HOME
Move to beginning of line.

F4 or CTRL+Y
Repeat last action.

CTRL+SHIFT+F3
Create names from row and column labels.

CTRL+D
Fill down.

CTRL+R
Fill to right.

CTRL+F3
Define name.

CTRL+K
Insert hyperlink.

CTRL+; (semicolon)
Enter date.

CTRL+SHIFT+: (colon)
Enter time.

ALT+DOWN ARROW
Display drop-down list of values in current column of range.

CTRL+Z
Undo last action.

ALT+’ (apostrophe)
Display Style dialog box.

CTRL+1
Display Format Cells dialog box.

CTRL+SHIFT+~
Apply General number format.

CTRL+SHIFT+$
Apply Currency format with two decimal places (negative numbers in parentheses).

CTRL+SHIFT+%
Apply Percentage format with no decimal places.

CTRL+SHIFT+^
Apply Exponential number format with two decimal places.

CTRL+SHIFT+#
Apply Date format with day, month, and year.

CTRL+SHIFT+@
Apply Time format with hour and minute, and AM or PM.

CTRL+SPACEBAR
Select entire column.

SHIFT+SPACEBAR
Select entire row.

SHIFT+BACKSPACE
With multiple cells highlighted, select only active cell.

CTRL+SHIFT+SPACEBAR
Selects entire worksheet.

CTRL+6
Alternate between hiding objects, displaying objects, and displaying placeholders for objects.

SHIFT+F11 or ALT+SHIFT+F1
Insert new worksheet.

CTRL+PAGE DOWN
Move to next sheet in workbook.

CTRL+PAGE UP
Move to previous sheet in workbook.

SHIFT+CTRL+PAGE UP
Select current and previous sheet.

ALT+O, H, R
Rename current sheet (Format menu, Sheet submenu, Rename command).

ALT+E, M
Move or copy current sheet (Edit menu, Move or Copy Sheet command).

ALT+E, L
Delete current sheet (Edit menu, Delete Sheet command).

ALT+TAB
Change to next program.

ALT+SHIFT+TAB
Change to previous program.

CTRL+ESC
Display Windows Start menu.

CTRL+W or CTRL+F4
Close highlighted workbook window.

CTRL+F5
Restore window size of highlighted workbook window.

F6
Change to next pane in worksheet that has been split (Window menu, Split command).

SHIFT+F6
Change to previous pane in worksheet that has been split.

CTRL+SHIFT+F6
Change to previous workbook window.

Arrow keys
Change Move one cell up, down, left, or right.

TAB
Change Move one cell to right.

SHIFT+TAB
Change Move one cell to left.

CTRL+arrow key
Change Move to edge of current data table

HOME
Change Move to beginning of row.

CTRL+HOME
Change Move to beginning of worksheet.

CTRL+END
Change Move to last cell on worksheet, in bottom-most used row of rightmost used column.

PAGE DOWN
Change Move down one screen.

PAGE UP
Change Move up one screen.

ALT+PAGE DOWN
Change Move one screen to right.

ALT+PAGE UP
Change Move one screen to left.

CTRL+BACKSPACE
Change Scroll to display active cell.

F5
Change Display Go To dialog box.

SHIFT+F5
Change Display Find dialog box.

SHIFT+F4
Change Repeat last Find action (same as Find Next).

TAB
Change Move between unlocked cells on protected worksheet.

CTRL+SHIFT+* (asterisk)
Select current region around active cell. In PivotTable report, select entire PivotTable report.

CTRL+/
Select array containing active cell.

CTRL+SHIFT+O (the letter O)
Select all cells that contain comments.

CTRL+\
In highlighted row, select cells that don’t match formula or static value in active cell.

CTRL+SHIFT+|
In highlighted column, select cells that don’t match formula or static value in active cell.

CTRL+[ (opening bracket)
Select all cells directly referenced by formulas in highlighted area.

CTRL+SHIFT+{ (opening brace)
Select all cells directly or indirectly referenced by formulas in highlighted area.

CTRL+] (closing bracket)
Select cells that contain formulas that directly reference active cell.

CTRL+SHIFT+} (closing brace)
Select cells that contain formulas that directly or indirectly reference active cell.

ALT+; (semicolon)
Select visible cells in current highlighted area.

F8
Turn extend mode on or off. In extend mode, EXT appears in status line, and arrow keys extend highlighted area.

SHIFT+F8
Add another range of cells to highlighted area; or use arrow keys to move to start of range you want to add

SHIFT+arrow key
Expand highlighted area by one cell.

CTRL+SHIFT+arrow key
Expand highlighted area to last nonblank cell in same column or row as active cell.

SHIFT+HOME
Expand highlighted area to beginning of row.

CTRL+SHIFT+HOME
Expand highlighted area to beginning of worksheet.

CTRL+SHIFT+END
Expand highlighted area to last used cell on worksheet (lower-right corner).

SHIFT+PAGE DOWN
Expand highlighted area down one screen.

SHIFT+PAGE UP
Expand highlighted area up one screen.

END+SHIFT+arrow key
Expand highlighted area to last nonblank cell in same column or row as active cell.

END+SHIFT+HOME
Expand highlighted area to last used cell on worksheet (lower-right corner).

END+SHIFT+ENTER
Expand highlighted area to last cell in current row.

SCROLL LOCK+SHIFT+HOME
Expand highlighted area to cell in upper-left corner of window.

SCROLL LOCK+SHIFT+END
Expand highlighted area to cell in lower-right corner of window.