610 Hits Varghese Nagappan Nov 25, 2021, 4:36 AM

What is the major shortcut keys available in Microsoft Excel

File

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 + W
 
 
Close Excel
Alt + F4
 
 

Ribbon

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/Return
 
Get help on selected control
F1
 

General

Open options
Alt + F + T
 
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 next match
Shift + F4
 
Find previous match
Ctrl + Shift + F4
 
Create embedded chart
Alt + F1
 
Create chart in new worksheet
F11
 
 

Tables and Filters

Insert table
Ctrl + T
 
Toggle Autofilter
Ctrl + Shift + L
 
Activate filter
Alt + ↓
 
Select table row
Shift + Space
 
Select table column
Ctrl + Space
 
Select table
Ctrl + A
 
Clear slicer filter
Alt + C
 
Toggle table total row
Ctrl + Shift + T
 

Drag and Drop

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

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
 
 
Go back to hyperlink
Ctrl + G + Enter
 
 

Selection

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
 
 
Same selection in next column
 
⌥ + Tab
 
Same selection in previous column
 
⌥ + ⇧ + Tab
 
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

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/Return
 
 
 
Move active cell up in selection
Shift + Enter/Return
 
 
Move active cell right in a selection
Tab
 
 
Move active cell left in a selection
Shift + Tab
 
 

Extend Selection

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

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;
⌘⇧Z

Cell edit mode

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
AltEnter
 
 

Entering data

Enter and move down
Enter
 
ReturnEnter 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

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

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
ShiftF9
 
 
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
 
 
Open the Name Manager
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
 
 
Zoom in
Ctrl + Alt + +
 
Zoom out
Ctrl + Alt + -
 
 
Zoom scroll
Ctrl + scroll
 

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
Fn⌃↓
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
 
 
Toggle full screen
Ctrl + Shift + F1
 

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
ShiftF7
 
 
Open Macro dialog box
AltF8
 
 
Open VBA Editor
AltF11
 
 
Duplicate object
Ctrl + D
 
Snap to grid
Alt
 
 
 
Hide or show objects
Ctrl + 6
 
 
Display Modify Cell Style dialog box
Alt + '
 
Display right-click menu
Shift + F10
 
 
Delete comment
Shift + F10 + D
 
 
Display control menu
Alt + Space
 

Explore more about

Enjoyed this article? Stay informed by joining our newsletter!

Comments

You must be logged in to post a comment.

About Author
Varghese Nagappan
Varghese Nagappan

Recent Articles
Why Legal Translation Matters: What Every Business Should Know
Jul 27, 2026, 5:41 PM simranlinguashine
Who can use Glowzi for weight loss goals?
Jul 27, 2026, 5:35 PM ukpurotyn
Is Purotyn suitable for both men and women?
Jul 27, 2026, 5:33 PM ukpurotyn
How Migration Agents in Adelaide Help You Get an Australian Visa
Jul 27, 2026, 5:30 PM Easy Migration
How Is the Aluminum Fluoride Price Index Shaping the 2026 Market Trend?
Jul 27, 2026, 5:23 PM Stephenthomas