BET: Microsoft Excel Shortcut Keys

Microsoft Office Development and Consultancy

Home

Excel

VBA

Excel > Shortcut Keys > Shortcuts

< Previous | Next >

Function Keys

F1	Displays the Excel Help window
F2	Edits the active cell, putting the cursor at the end*
F3	Displays the Paste Name dialog box
F4	Repeats the last command or action
F5	Displays the GoTo dialog box
F6	Moves to the next item (worksheet, ribbon, task pane, zoom control)
F7	Displays the Spelling dialog box
F8	Toggles whether to extend a selection with the arrow keys
F9	Calculates All the worksheets in All the open workbooks
F10	Turns key tips on or off
F11	Displays the Chart dialog box that creates a chart (on a chart sheet) using the highlighted range
F12	Displays the Save As dialog box

Note: *This is only available with (Tools > Options, Edit tab, Edit directly in cell).

Shift + Function

Shift + F1	Redundant see below
Shift + F2	Inserts or edits a cell comment
Shift + F3	Displays the Insert Function dialog box (can be used from the formula bar)
Shift + F4	Repeats the last Find, the same as Find Next
Shift + F5	Displays the Find dialog box
Shift + F6	Moves to the previous item
Shift + F8	Toggles between switching Add Mode on or off*
Shift + F9	Calculates just the active worksheet
Shift + F10	Displays the Shortcut menu for the selected item
Shift + F11	Inserts a new worksheet (before the active sheet) into the active workbook
Shift + F12	Saves, Displays the Save As dialog box if a new workbook

Note: *This allows you to select non contiguous blocks of cells using the keyboard.

Ctrl + Function

Ctrl + F1	Toggles the display of the Ribbon
Ctrl + F2	Displays the Print Preview window
Ctrl + F3	Displays the Name Manager dialog box
Ctrl + F4	Closes the active workbook or window
Ctrl + F5	Restores the size of the active workbook or window
Ctrl + F6	Moves to the next open workbook or window
Ctrl + F7	Activates the Move window command
Ctrl + F8	Activates the Resize window command
Ctrl + F9	Minimises the size of the active workbook or window
Ctrl + F10	Maximises the size of the active workbook or window
Ctrl + F11	Redundant see below
Ctrl + F12	Displays the (File > Open) dialog box

Other + Function

Alt + F1	Creates a chart (on a chart sheet) using the highlighted range
Alt + F2	Displays the Save As dialog box
Alt + F4	Closes all the workbooks (saving first) and exits Excel
Alt + F8	Displays the Macro dialog box
Alt + F11	Toggles between the Visual Basic Editor window and the Excel window
Alt + Ctrl + F9	Calculates All cells on All worksheets in All workbooks
Alt + Shift + F1	Inserts a new worksheet (before the active sheet) into the active workbook
Alt + Shift + F2	Displays the (File > Save As) dialog box
Alt + Shift + F4	Closes all the workbooks (saving first) and exits Excel
Alt + Shift + F10	Displays the drop-down menu for the corresponding smart tag
Alt + Shift + F11	Activates the Microsoft Script Editor window
Ctrl + Shift + F3	Displays the Create Names from Selection dialog box
Ctrl + Shift + F6	Moves to the previous open workbook or window
Ctrl + Shift + F10	Activates the Menu Bar or Displays the (View > Toolbars) dialog box
Ctrl + Shift + F12	Displays the Print dialog box
Insert + F4	Read spelling errors and suggestions ??
Alt + Ctrl + Shift + F9	Calculates All cells in All worksheets in All workbooks after checking dependent formulas

Ctrl + Numbers

Ctrl + 0	Hides the columns in the current selection
Ctrl + 1	Displays the Format Cells dialog box (not using the keypad)
Ctrl + 2	Toggles bold on the current selection
Ctrl + 3	Toggles italics on the current selection
Ctrl + 4	Toggles underlying on the current selection
Ctrl + 5	Toggles the strikethrough of text on the current selection
Ctrl + 6	Toggles between hiding, displaying or displaying placeholders for objects
Ctrl + 7	??
Ctrl + 8	Toggles the display of Outline symbols on the active worksheet
Ctrl + 9	Hides the rows in the current selection
Ctrl + Shift + 0	Unhides the columns in the current selection
Ctrl + Shift + 2	Enters the value from the cell directly above into the active cell
Ctrl + Shift + 8	Selects the current region (surrounded by blank rows and columns)
Ctrl + Shift + 9	Unhides the rows in the current selection

Ctrl + Letters

Ctrl + A	Selects the current region or entire worksheet or displays the function arguments dialog box if you have typed a function.
Ctrl + A, A	Selects the whole worksheet
Ctrl + B	Toggles bold on the current selection
Ctrl + C	Copies the current selection to the clipboard
Ctrl + D	Copies the first cell in the selection downwards
Ctrl + E	Goto current Error ??
Ctrl + F	Displays the Find and Replace dialog box with the Find tab active
Ctrl + G	Displays the GoTo dialog box
Ctrl + H	Displays the Find and Replace dialog box with the Replace tab active
Ctrl + I	Toggles italics on the current selection
Ctrl + J	Toggles calculation between Manual and Automatic ??
Ctrl + K	Displays the Insert Hyperlink dialog box
Ctrl + L	Displays the Create Table dialog box
Ctrl + N	Creates a new workbook (File > New)
Ctrl + O	Displays the Open dialog box
Ctrl + P	Displays the Print dialog box
Ctrl + R	Copies the leftmost cell in the selection to the right
Ctrl + S	Saves, Displays the Save As dialog box if a new workbook
Ctrl + T	Displays the Create Table dialog box
Ctrl + U	Toggles underlining on the current selection
Ctrl + V	Pastes the entry from the clipboard
Ctrl + W	Closes the active workbook or window
Ctrl + X	Cuts the current selection to the clipboard
Ctrl + Y	Repeats the last Excel operation
Ctrl + Z	Undo the last Excel operation

Other + Letters

Alt + C	Move the selected field into the Column area (Pivot Table)
Alt + D	Displays the (Data) menu
Alt + E	Displays the (Edit) menu
Alt + F	Displays the (File) menu
Alt + H	Displays the (Help) menu
Alt + I	Displays the (Insert) menu
Alt + L	Displays the Pivot Table Field dialog box ??
Alt + O	Displays the (Format) menu
Alt + P	Move the selected field into the Page area (Pivot Table)
Alt + R	Move the selected field into the Row area (Pivot Table)
Alt + T	Displays the (Tools) menu
Alt + U	??
Alt + V	Displays the (View) menu
Alt + W	Displays the (Window) menu
Alt + Shift + B	Report on the cell borders ??
Alt + Shift + G	Report the gridline status ??
Ctrl + Shift + A	Inserts argument names given a function in the formula bar.
Ctrl + Shift + C	List cells in current column ???
Ctrl + Shift + F	Displays the Format Cells dialog box, Font tab
Ctrl + Shift + H	Selects all the hyperlinks ?? where
Ctrl + Shift + O	Selects all the cells with comments
Ctrl + Shift + P	Displays the Format Cells dialog box, Font tab
Ctrl + Shift + R	List cells in the current row ???
Ctrl + Shift + S	List all the worksheets ??
Ctrl + Shift + Z	Undo or redo the last automatic correction (AutoCorrect Smart Tag)

Entering Data

=	Start a Formula
Enter	Enters the contents of the active cell and moves to the cell below (by default)
Alt + Enter	Enters a new line (or carriage return) into a cell
Shift + Enter	Enters the contents of the active cell and moves to the cell above (by default)
Tab	Enters the contents of the active cell and moves one cell to the right
Shift + Tab	Enters the contents of the active cell and moves one cell to the left
Alt + =	Enters the SUM() function (AutoSum) to sum the adjacent block of cells
Alt + 0128	Enters the euro symbol (€) (using Number keypad)
Alt + 0162	Enters the cent symbol (¢) (using Number keypad)
Alt + 0163	Enters the pound sign symbol (£) (using Number keypad)
Alt + 0165	Enters the yen symbol (¥) (using Number keypad)
Ctrl + '	Enters the formula from the cell directly above into the active cell
Ctrl + Shift + 2	Enters the value from the cell directly above into the active cell
Ctrl + ;	Enters the current date into the active cell
Ctrl + Enter	Enters the contents of the active cell to the selected region
Ctrl + Shift + ;	Enters the current time into the active cell
Ctrl + Shift + Enter	Enters the formula as an Array Formula
Shift + Insert	Enters the data from the clipboard
Alt + Down Arrow	Displays the Pick From List drop-down list
Esc	Cancels the cell entry and restores the original contents or closes full screen view

Editing Data

Ctrl + `	Toggles between displaying cell values and formulas (single left quotation mark)
Delete	Deletes the selection or one character to the right
Backspace	Deletes the selection or one character to the left
Shift + Delete	Cuts the selection to the clipboard
Ctrl + Delete	Deletes text to the end of the line
Ctrl + -	Displays the Delete dialog box
Ctrl + Shift + =	Displays the Insert dialog box

Extending Data

Ctrl + Shift + Left Arrow	Extends the selection to the next non blank cell on the left
Ctrl + Shift + Right Arrow	Extends the selection to the next non blank cell on the right
Ctrl + Shift + Up Arrow	Extends the selection to the next non blank cell above in the same column
Ctrl + Shift + Down Arrow	Extends the selection to the next non blank cell below in the same column
Ctrl + Shift + End	Extends the selection to the last used cell on the worksheet
Ctrl + Shift + Home	Extends the selection to the beginning of the worksheet
Shift + Arrow Keys	Extends the selection by one cell in that direction
Shift + Home	Extends the selection to the first column
Shift + Page Down	Extends the selection down one screen
Shift + Page Up	Extends the selection up one screen
End, Shift + Arrow Keys	Extends the selection to the next non-blank cell in that direction
End, Shift + End	Extends the selection to the last cell in the current row*
End, Shift + Home	Extends the selection to last used cell on the worksheet

Note: *This is only available with (Options, Transition tab, Transition Navigation Keys).

Selecting Data

Alt + ;	Selects the visible cells in the current selection
Ctrl + \	Selects the cells in a selected row that do not match the value in the active cell
Ctrl + Shift + \	Selects the cells in a selected column that do not match the value in the active cell
Ctrl + /	Selects the whole array formula containing the active cell
Ctrl + Enter	Selects the first object / chart ??, completes a cell entry and stays in the same cell
*Ctrl + Shift + (8 or )**	Selects the current region (surrounded by blank rows and columns)
Ctrl + *	Selects the current region (using the * on the number keyboard)
Ctrl + [	Selects all the cells that are directly referred to by the formula in the active cell (precedents)
Ctrl + Shift + [	Selects all the cells that are directly (or indirectly) referred to by the formula in the active cell
Ctrl + ]	Selects all the cells that directly refer to the active cell (dependents)
Ctrl + Shift + ]	Selects all the cells that directly (or indirectly) refer to the active cell
Ctrl + Shift + Left Arrow	Selects one word to the left
Ctrl + Shift + Right Arrow	Selects one word to the right
Ctrl + Shift + Page Down	Selects the active worksheet and the one after it
Ctrl + Shift + Page Up	Selects the active worksheet and the one before it
Ctrl + Shift + Spacebar	Selects all the objects on the worksheet when an object is selected or selects the whole worksheet
Ctrl + Shift + End	Selects all the text after the cursor in the formula bar
Ctrl + Backspace	Selects the current active cell (scrolling if necessary)
Ctrl + Spacebar	Selects the current column (only works for a continuous block).
Shift + Arrow keys	Selects the active cell and the cell in the given direction
Shift + Backspace	Selects the active cell when multiple cells are selected
Shift + Spacebar	Selects the current row (only works for a continuous block).
Shift + Home	??
Shift + End	??

Formatting Data

Alt + '	Displays the Style dialog box
Ctrl + Shift + ( ' or ¬ or @)	Applies the Time format "hh:mm" to the selection
Ctrl + Shift + (1 or !)	Applies the Comma separated format "#,##0.00" to the selection (neg numbers ?)
Ctrl + Shift + (4 or $)	Applies the Currency format "£#,##0.00" to the selection
Ctrl + Shift + (5 or %)	Applies the Percentage format "0%" to the selection
Ctrl + Shift + (6 or ^)	Applies the Exponential format "#,##E+02" to the selection
Ctrl + Shift + (# or ~)	Applies the General format to the selection
Ctrl + (# or ~)	Applies the Custom Date format "dd-mmm-yy" to the selection
Ctrl + Shift + (7 or &)	Applies the outline border to the selection
Ctrl + Shift + (- or _ )	Removes all the borders from the selection or just outline border ?

Manoeuvring

Arrow Keys	Moves to the next cell in that direction
Ctrl + Tab	Moves to the next open workbook or window
Alt + Tab	Moves to the next application open on your computer
Alt + Shift + Tab	Moves to the previous application open on your computer
Enter	Moves to the cell directly below
Tab	Moves to the next cell on the right (or unprotected cell)
Home	Moves to the first column in the current row
End, Arrow Keys	Moves to the next non empty cell in that direction
End, Enter	Moves to the last cell in the current row that is not blank
End + Home	Moves to the last used cell on the active worksheet*
End, Home	Moves to the last used cell on the active worksheet*
Page Down	Moves to the next screen of rows (one screen down)
Page Up	Moves to the previous screen of rows (one screen up)
Shift + Enter	Moves to the cell directly above (opposite direction to Enter)
Shift + Tab	Moves to the cell directly to the left (opposite direction to Tab)
Alt + Page Down	Moves you one screen of columns to the right
Alt + Page Up	Moves you one screen of columns to the left
Ctrl + Home	Moves to cell "A1" on the active sheet
Ctrl + End	Moves to the last used cell on the active worksheet* or end of formula bar
Ctrl + Up Arrow	Moves to the first row in the current region
Ctrl + Down Arrow	Moves to the last row in the current region
Ctrl + Left Arrow	Moves to the first column in the current region or one word to the left
Ctrl + Right Arrow	Moves to the last column in the current region or one word to the right
Ctrl + Page Up	Moves to the previous worksheet in the workbook
Ctrl + Page Down	Moves to the next worksheet in the workbook
Ctrl + Shift + Tab	Moves to the previous open workbook or window
Ctrl + Backspace	Moves to the display the active cell
Scroll Lock + Arrow Keys	Moves the workbook or window one cell in that direction
Scroll Lock + End	Moves to the last cell in the current window
Scroll Lock + Home	Moves to the first cell in the current window
Scroll Lock + Page Down	Moves you down one screen (current selection unchanged)
Scroll Lock + Page Up	Moves you up one screen (current selection unchanged)

Note: *This is only updated when the workbook is closed.

Manoeuvring (within a selection)

Enter	Moves from top to bottom within a selection
Tab	Moves from left to right within a selection
Ctrl + .	Moves clockwise to the next corner within a selection
Shift + Tab	Moves from right to left within a selection (opposite direction to Tab)
Alt + Ctrl + Left Arrow	Moves to the left between non adjacent cells in a selection
Alt + Ctrl + Right Arrow	Moves to the right between non adjacent cells in a selection

Other

=	Starts a Formula
Ctrl + `	Toggles between the value layer and the formula layer (Options, View tab, "Formulas")
Ctrl + Delete	Deletes to the end of the line
Ctrl + Insert	Copies the current selection to the clipboard
Ctrl + Shift + (	Unhides any hidden rows within the selection
Ctrl + Shift + )	Unhides any hidden columns within the selection
Ctrl + Shift + /	Copy value from cell above / select the array ??
Ctrl + Shift + \	Select unequal cells
Ctrl + Shift + =	Displays the Insert dialog box
Ctrl + -	Displays the(Delete dialog box or deletes the rows currently selected
Ctrl + Esc	Displays the Windows Start Menu
Alt	Toggles the activation of the Menu Bar
Alt + Shift + Left Arrow	Displays the (Data > Group and Outline > UnGroup) dialog box
Alt + Shift + Right Arrow	Displays the (Data > Group and Outline > Group) dialog box
Alt + Backspace	Undo the last action (Edit > Undo) ??
Alt + Spacebar	Activates the Control Box in the top left hand corner
Alt + -	Displays the Excel application control menu
End	Toggles between switching End Mode on or off
Scroll Lock	Toggles between switching Scroll Lock on or off
Shift + Insert	Pastes the entry from the clipboard

Redundant Shortcut Keys

Ctrl + F2	Displays the Info Window
Ctrl + F11	Inserts an Excel 4.0 macro sheet
Shift + F1	Activates the context sensitive Whats this ? prompt (Help > Whats This)

< Previous | Top | Next >