Excel Office

Excel How Tos, Tutorials, Tips & Tricks, Shortcuts

230 Excel Shortcut Keys

Many times, people wonder and call their colleagues wizard following how proficient they are in using Microsoft Office Excel.

There’s no magic in excel like using shortcut keys to manipulate records swiftly without breaking your back.

The excel shortcut keys make us work 10 times faster than using the normal conventional way to solve office challenges.

For easy and quick result, we have compiled over 230 Comprehensive Keyboard shortcuts in Excel for Windows.

Below is a listing of most of the major shortcut keys and key combinations usable in Microsoft Excel.

File tab Shortcut Keys

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

General Excel Shortcut

Copy selected cells Ctrl+C
Create chart in new worksheet F11
Create embedded chart Alt+F1
Cut selected cells Ctrl+X
Display find and replace Ctrl+F
Display find and replace, replace selected Ctrl+H
Display the Paste Special dialog box Ctrl+AltV
Find next match Shift+F4
Find previous match Ctrl+Shift+F4
Open help F1
Open options Alt+FT
Paste content from clipboard Ctrl+V
Redo last action Ctrl+Y
Repeat last action F4
Undo last action Ctrl+Z

Cell edit mode Shortcut Keys in Excel

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

Excel Shortcut for Entering data

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

Selection Shortcut Keys in Excel

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

Active Cell Shortcuts

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

Excel Shortcut for Extend Selection

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

Select Special Shortcut

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

Shortcut for Formatting

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

Number Formatting Shortcut Keys

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

Borders Shortcut in Excel

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

Excel Shortcut Keys for Formulas

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

Shortcut for Ribbon

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

Shortcut for Tables and Filters in Excel

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

Drag and Drop buttons

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

Excel Shortcut Keys for Navigation

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

Grid Operations

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

Pivot Tables

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

Excel Workbook Shortcut Keys

Accept and apply Enter
Cancel and close the dialog box Esc
Check and uncheck box Space
Go to next workbook Ctrl+Tab
Go to next worksheet CtrlPgDn
Go to previous workbook Ctrl+Shift+Tab
Go to previous worksheet Ctrl+PgUp
Insert new worksheet Shift+F11
Maximize current workbook window Ctrl+F10
Minimize current workbook window Ctrl+F9
Move to next control Tab
Move to next pane F6
Move to next tab Ctrl+Tab
Move to previous control Shift+Tab
Move to previous pane Shift+F6
Move to previous tab Ctrl+Shift+Tab
Select adjacent worksheets Shift+Click
Select non-adjacent worksheets Ctrl+Click
Toggle full screen Ctrl+Shift+F1
Toggle scroll lock ScrLk

Others Excel Shortcuts

Open Spelling dialog box F7
Delete comment Shift+F10D
Display control menu Alt+Space
Display Modify Cell Style dialog box Alt+’
Display right-click menu Shift+F10
Duplicate object Ctrl+D
Hide or show objects Ctrl+6
Open Macro dialog box Alt+F8
Open Thesaurus dialog box Shift+F7
Open VBA Editor Alt+F11
Snap to grid Alt

Leave a Reply

Your email address will not be published. Required fields are marked *