Useful Excel Keyboard Shortcuts and Function Keys for Windows

January 14, 2017

Frequently I am gathering information about Useful Excel Keyboard Shortcuts, Which is used by typing some function keys for Windows with the help of Keyboard. Some time ago I started documenting and writing down (what is growing to be) an extremely comprehensive list of Excel shortcuts and function keys for Windows.

Here is the list of some Useful Excel Keyboard Shortcuts

You can also download cheat sheet for free by clicking here.

File: Useful Excel Keyboard Shortcuts and Function Keys

Create new workbook – Ctrl + N
Open workbook – Ctrl + O
Save workbook – Ctrl + S
Save as – F12
Print file – Ctrl + P
Open print preview window – Ctrl + F2
Close current workbook – Ctrl + F4
Close Excel – Alt + F4

Ribbon: Useful Excel Keyboard Shortcuts and Function Keys

Expand or collapse ribbon – Ctrl + F1
Activate access keys – Alt
Move to next ribbon control – Tab
Activate or open selected control – Space
Confirm control change – Enter
Get help on selected control – F1

General: Useful Excel Keyboard Shortcuts and Function Keys

Open help – F1
Undo last action – Ctrl + Z
Redo last action – Ctrl + Y
Copy selected cells – Ctrl + C
Repeat last action – F4
Cut selected cells – Ctrl + X
Paste content from clipboard – Ctrl + V
Display the Paste Special dialog box – Ctrl + Alt + V
Display find and replace – Ctrl + F
Display find and replace, replace selected – Ctrl + H
Find previous match – Ctrl + Shift + F4
Find next match – Shift + F4
Create embedded chart – Alt + F1
Create chart in new worksheet – F11
Toggle Autofilter – Ctrl + Shift + L
Activate filter – Alt + ↓
Insert table – Ctrl + T
Select table row – Shift + Space
Select table column – Ctrl + Space
Select table – Ctrl + A

Drag and Drop: Useful Excel Keyboard Shortcuts and Function Keys

Drag and cut – drag
Drag and copy – Ctrl + drag
Drag and insert – Shift + drag
Drag and insert copy – Ctrl + Shift + drag
Drag to worksheet – Alt + drag
Drag to duplicate worksheet – Ctrl + drag

Navigation: Useful Excel Keyboard Shortcuts and Function Keys

Move one cell right – →
Move one cell left – ←
Move one cell up – ↑
Move one cell down – ↓
Move one screen right – Alt + PgDn
Move one screen left – Alt + PgUp
Move one screen up – PgUp
Move one screen down – PgDn
Move to right edge of data region – Ctrl + →
Move to left edge of data region – Ctrl + ←
Move to top edge of data region – Ctrl + ↑
Move to bottom edge of data region – Ctrl + ↓
Move to beginning of row – Home
Move to last cell in worksheet – Ctrl + End
Move to first cell in worksheet – Ctrl + Home
Turn End mode on – End

Selection: Useful Excel Keyboard Shortcuts and Function Keys

Select entire row – Shift + Space
Select entire column – Ctrl + Space
Select entire worksheet – Ctrl + A
Add adjacent cells to selection – Shift + Click
Add non-adjacent cells to selection – Ctrl + Click
Move right between non-adjacent selections – Ctrl + Alt + →
Move left between non-adjacent selections – Ctrl + Alt + ←
Toggle add to selection mode – Shift + F8
Cancel selection – Esc

Active Cell: Useful Excel Keyboard Shortcuts and Function Keys

Select active cell only – Shift + Backspace
Show the active cell on worksheet – Ctrl + Backspace
Move active cell clockwise in selection – Ctrl + .
Move active cell down in selection – Enter
Move active cell up in selection – Shift + Enter
Move active cell right in a selection – Tab
Move active cell left in a selection – Shift + Tab

Extend Selection: Useful Excel Keyboard Shortcuts and Function Keys

Extend selection by one cell right – Shift + →
Extend selection by one cell left – Shift + ←
Extend selection by one cell up – Shift + ↑
Extend selection by one cell down – Shift + ↓
Extend the selection to the last cell right – Ctrl + Shift + →
Extend the selection to the last cell left – Ctrl + Shift + ←
Extend the selection to the last cell up – Ctrl + Shift + ↑
Extend the selection to the last cell down – Ctrl + Shift + ↓
Extend selection up one screen – Shift + PgUp
Extend selection down one screen – Shift + PgDn
Extend selection right one screen – Alt + Shift + PgDn
Extend selection left one screen – Alt + Shift + PgUp
Extend selection to start of row – Shift + Home
Extend selection to first cell in worksheet – Ctrl + Shift + Home
Extend selection to last cell in worksheet – Ctrl + Shift + End
Toggle extend selection mode – F8

Select Special: Useful Excel Keyboard Shortcuts and Function Keys

Display ‘Go To’ dialog box – Ctrl + G
Select cells with comments – Ctrl + Shift + O
Select current region around active cell – Ctrl + Shift + *
Select current region – Ctrl + A
Select current array – Ctrl + /
Select row differences – Ctrl + \
Select column differences – Ctrl + Shift + |
Select direct precedents – Ctrl + [
Select all precedents – Ctrl + Shift + {
Select direct dependents – Ctrl + ]
Select all dependents – Ctrl + Shift + }
Select visible cells only – Alt + ;

Cell edit mode: Useful Excel Keyboard Shortcuts and Function Keys

Edit the active cell – F2
Insert or edit comment – Shift + F2
Cancel entry – Esc
Select one character right – Shift + →
Select one character left – Shift + ←
Move one word right – Ctrl + →
Move one word left – Ctrl + ←
Select one word right – Ctrl + Shift + →
Select one word left – Ctrl + Shift + ←
Select to beginning of cell – Shift + Home
Select to end of cell – Shift + End
Delete to end of line – Ctrl + Delete
Delete character to the left of cursor – Backspace
Delete character to the right of cursor – Delete
Start a new line in the same cell – Alt + Enter

Entering data: Useful Excel Keyboard Shortcuts and Function Keys

Enter and move down – Enter
Enter and move up – Shift + Enter
Enter and move right – Tab
Enter and move left – Shift + Tab
Complete entry and stay in same cell – Ctrl + Enter
Enter same data in multiple cells – Ctrl + Enter
Insert current date – Ctrl + ;
Insert current time – Ctrl + Shift + :
Fill down from cell above – Ctrl + D
Fill right from cell left – Ctrl + R
Copy formula from cell above – Ctrl + ‘
Copy value from cell above – Ctrl + Shift + “
Add hyperlink – Ctrl + K
Display AutoComplete list – Alt + ↓
Flash fill – Ctrl + E

Formatting: Useful Excel Keyboard Shortcuts and Function Keys

Format (almost) anything – Ctrl + 1
Display Format Cells with Font tab selected – Ctrl + Shift + F
Apply or remove bold formatting – Ctrl + B
Apply or remove italic formatting – Ctrl + I
Apply or remove underscoring – Ctrl + U
Apply or remove strikethrough formatting – Ctrl + 5
Align center – Alt + H + A + C
Align left – Alt + H + A + L
Align right – Alt + H + A + R
Indent – Alt + H + 6
Remove indent – Alt + H + 5
Increase font size one step – Alt + H + F + G
Decrease font size one step – Alt + H + F + K

Number Formatting: Useful Excel Keyboard Shortcuts and Function Keys

Apply general format – Ctrl + Shift + ~
Apply currency format – Ctrl + Shift + $
Apply percentage format – Ctrl + Shift + %
Apply scientific format – Ctrl + Shift + ^
Apply date format – Ctrl + Shift + #
Apply time format – Ctrl + Shift + @
Apply number format – Ctrl + Shift + !

Borders

Add border outline – Ctrl + Shift + &
Add or remove border right – Alt + R
Add or remove border left – Alt + L
Add or remove border top – Alt + T
Add or remove border bottom – Alt + B
Add or remove border upward diagonal – Alt + D
Add or remove border horizontal interior – Alt + H
Add or remove border vertical interior – Alt + V
Remove borders – Ctrl + Shift + _

Formulas

Toggle absolute and relative references – F4
Open the Insert Function Dialog Box – Shift + F3
Autosum selected cells – Alt + =
Toggle formulas on and off – Ctrl + `
Insert function arguments – Ctrl + Shift + A
Enter array formula – Ctrl + Shift + Enter
Calculate worksheets – F9
Calculate active worksheet – Shift + F9
Force calculate all worksheets – Ctrl + Alt + F9
Evaluate part of a formula – F9
Expand or collapse the formula bar – Ctrl + Shift + U
Display function arguments dialog box – Ctrl + A
Define name – Ctrl + F3
Define name using row and column labels – Ctrl + Shift + F3
Paste name into formula – F3
Accept function with autocomplete – Tab

Grid Operations

Display Insert Dialog box – Ctrl + Shift + +
Insert rows – Ctrl + Shift + +
Insert columns – Ctrl + Shift + +
Display Delete dialog box – Ctrl + –
Delete rows – Ctrl + –
Delete columns – Ctrl + –
Delete cells – Ctrl + –
Delete contents of selected cells – Delete
Hide columns – Ctrl + 0
Hide rows – Ctrl + 9
Unhide rows – Ctrl + Shift + 9
Unhide columns – Ctrl + Shift + 0
Group rows or columns – Alt + Shift + →
Ungroup rows or columns – Alt + Shift + ←
Open Group Dialog Box – Alt + Shift + →
Open Ungroup Dialog Box – Alt + Shift + ←
Hide or show outline symbols – Ctrl + 8

Pivot Tables

Select entire pivot table – Ctrl + A
Toggle pivot table field checkbox – Space
Group pivot table items – Alt + Shift + →
Ungroup pivot table items – Alt + Shift + ←
Hide pivot table item – Ctrl + –
Create pivot chart on same worksheet – Alt + F1
Create pivot chart on new worksheet – F11
Open pivot table wizard – Alt + D + P

Workbook

Insert new worksheet – Shift + F11
Go to next worksheet – Ctrl + PgDn
Go to previous worksheet – Ctrl + PgUp
Move to next pane – F6
Move to previous pane – Shift + F6
Go to next workbook – Ctrl + Tab
Go to previous workbook – Ctrl + Shift + Tab
Minimize current workbook window – Ctrl + F9
Maximize current workbook window – Ctrl + F10
Select adjacent worksheets – Shift + Click
Select non-adjacent worksheets – Ctrl + Click
Toggle scroll lock – ScrLk

Dialog boxes

Move to next control – Tab
Move to previous control – Shift + Tab
Move to next tab – Ctrl + Tab
Move to previous tab – Ctrl + Shift + Tab
Accept and apply – Enter
Check and uncheck box – Space
Cancel and close the dialog box – Esc

Other

Open Spelling dialog box – F7
Open Thesaurus dialog box – Shift + F7
Open Macro dialog box – Alt + F8
Open VBA Editor – Alt + F11
Duplicate object – Ctrl + D
Snap to grid – Alt
Hide or show objects – Ctrl + 6
Display Modify Cell Style dialog box – Alt + ‘
Display shortcut menu – Shift + F10
Display control menu – Alt + Space