Excel

220+ MS Excel Shortcuts Keys in PDF | Excel Keyboard Shortcuts

7 Mins read

MS Excel Shortcuts Keys, when starting with Microsoft Excel, knowing a few ms excel shortcuts keys will reduce your work time and make it easier to work on Excel. Using the mouse to do all the tasks reduces your productivity. Here are the most used Excel shortcuts to use when you just begin working with Microsoft Excel.

PDF GUIDE BOOKS

  • Download Excel Shortcuts for Windows & Mac
  • Basic to Advanced Excel Formulas PDF Guide

This Book will help you to get Excel Skills & Boost your career.

These MS Excel Keyboard shortcuts for beginner works with all versions of MS Excel 2003, MS Excel 2007, MS Excel 2010, MS Excel 2013, MS Excel 2016, MS Excel 2019 & Office 365. In this blog, you will learn how to use basic excel shortcuts.

File Excel Shortcuts

Descriptions
Windows Shortcuts
Mac Shortcuts
Create new workbook
CTRL + N
⌘ + N
Open workbook
CTRL O
⌘ O
Save workbook
CTRL S
⌘ S
Save as
F12
⌘ ⇧ S
Print Excel sheet
CTRL P
⌘ P
Open print preview window
CTRL F2
Close current window
CTRL W
⌘ W
Close Excel
ALT F4
⌘ Q

Ribbon Excel Shortcuts

Descriptions
Windows Shortcuts
Mac Shortcuts
Expand or collapse
CTRL F1
⌘ ⌥ R
Excel hot keys
ALT
Move to Next Ribbon Control
TAB
TAB
Move to a previous button
SHIFT TAB
SPACE
Accept and Confirm
ENTER
RETURN
Get help
F1

Active Cell Excel Shortcuts

Descriptions
Windows Shortcuts
Mac Shortcuts
Select active cell only
SHIFT BACKSPACE
⇧ DELETE
Show active cell on a worksheet
CTRL BACKSPACE
⌘ DELETE
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
TAB
Move active cell Left in a selection
SHIFT TAB
⇧ TAB

PDF GUIDE BOOKS

  • Download Excel Shortcuts for Windows & Mac
  • Basic to Advanced Excel Formulas PDF Guide

This Book will help you to get Excel Skills & Boost your career.

General Excel Shortcuts

Descriptions
Windows Shortcuts
Mac Shortcuts
Open Help
F1
⌘ /
Undo last action
CTRL Z
⌘ Z
Redo last action
CTRL Y
⌘ Y
Copy selected cells
CTRL C
⌘ C
Repeat last action
F4
⌘ Y
Cut selected cells
CTRL X
⌘ X
Paste content from clipboard
CTRL V
⌘ V
Display Paste Special
ALT E S
⌘ ^ V
Display Find and Replace
CTRL F
⌘ F
Find with Replace selected
CTRL H
^ H
Find previous match
CTRL SHIFT F4
⌘ ⇧ G
Find next match
SHIFT F4
⌘ G
Create Embedded Chart
ALT F1
Fn ⌥ F1
Create chart in new worksheet
F11
Fn F11
Toggle auto filter
CTRL SHIFT L
⌘ ⇧ F
Activate filter Dropdown
ALT ↓
⌥ ↓
Insert table
CTRL T
^ T
Select table row
SHIFT SPACE
⇧ SPACE
Select table column
CTRL SPACE
^ SPACE
Select table
CTRL A
⌘ A

Selection Excel Shortcuts

Descriptions
Windows Shortcuts
Mac Shortcuts
Select entire row
SHIFT SPACE
⇧ SPACE
Select entire column
CTRL SPACE
^ SPACE
Select entire worksheet
CTRL A
⌘ A
Toggle add to selection mode
SHIFT F8
Fn ⇧ F8
Cancel selection
ESC
ESC

Navigation Excel Shortcuts

Descriptions
Windows Shortcuts
Mac Shortcuts
Move one cell right
Move one cell left
Move one cell up
Move one cell down
Move one screen Right
ALT Pg Dn
Fn ⌥ ↓
Move one screen left
ALT Pg Up
Fn ⌥ ↑
Move one screen up
Pg Up
Fn ↑
Move one screen down
Pg Dn
Fn ↓
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
Fn ←
Move to last cell in worksheet
CTRL END
Fn ^ →
Move to first cell in worksheet
CTRL HOME
Fn ^ ←
Turn End mode on
END
Fn →

PDF GUIDE BOOKS

  • Download Excel Shortcuts for Windows & Mac
  • Basic to Advanced Excel Formulas PDF Guide

This Book will help you to get Excel Skills & Boost your career.

Number Formatting Excel Shortcuts

Descriptions
Windows Shortcuts
Mac Shortcuts
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 !
^ ⇧ !

Extend Selection Excel Shortcuts

Descriptions
Windows Shortcuts
Mac Shortcuts
ES by One Cell Right
SHIFT →
⇧ →
ES by One Cell Left
SHIFT ←
⇧ ←
ES by One cell Up
SHIFT ↑
⇧ ↑
ES by One Cell Down
SHIFT ↓
⇧ ↓
ES to the last Cell Right
CTRL SHIFT →
^ ⇧ →
ES to the last Cell Left
CTRL SHIFT ←
^ ⇧ ←
ES to the last Cell Up
CTRL SHIFT ↑
^ ⇧ ↑
ES to the Last Cell Down
CTRL SHIFT ↓
^ ⇧ ↓
ES Up One Screen
SHIFT Pg Up
Fn ⇧ ↑
ES Down One Screen
SHIFT Pg Dn
Fn ⇧ ↓
ES Right One Screen
ALT SHIFT Pg Dn
Fn ⇧ ⌥ ↓
ES Left One Screen
ALT SHIFT Pg Up
Fn ⇧ ⌥ ↑
ES to Start of Row
SHIFT HOME
Fn ⇧ ←
ES to the First Cell in the worksheet
CTRL SHIFT HOME
Fn ^ ⇧ ←
ES to the last cell in the Worksheet
CTRL SHIFT END
Fn ^ ⇧ →
Toggle ES Mode
F8
Fn F8

Cell Edit Mode Excel Shortcuts

Descriptions
Windows Shortcuts
Mac Shortcuts
Display ‘Go To’ Dialog Box
CTRL G
^ G
Select Row Differences
CTRL \
^ \
Select Column Differences
CTRL SHIFT |
^ ⇧ |
Select Cells with Comments
CTRL SHIFT O
Fn ^ ⇧ O
Select Current Region
CTRL A
⌘ A
Select Current Array
CTRL /
^ /
Select Direct Precedents
CTRL [
^ [
Select All Precedents
CTRL SHIFT {
^ ⇧ {
Select Direct Dependents
CTRL ]
^ ]
Select All Dependents
CTRL SHIFT }
^ ⇧ }
Select Visible Cells Only
ALT ;
⌘ ⇧ Z

Entering Data Excel Shortcuts

Descriptions
Windows Shortcuts
Mac Shortcuts
Enter and Move down
ENTER
RETURN
Enter and Move up
SHIFT ENTER
⇧ RETURN
Enter and Move right
TAB
TAB
Enter and Move left
SHIFT TAB
⇧ TAB
Enter same data in multiple cells
CTRL ENTER
^ RETURN
Insert Current Date
CTRL ;
^ ;
Insert current time
CTRL SHIFT :
⌘ ;
Fill down from cell above
CTRL D
^ D
Fill right from cell left
CTRL R
^ R
Copy formulas from cell above
CTRL ‘
^ ‘
Copy value from cell above
CTRL SHIFT “
^ ⇧ “
Add Hyperlink
CTRL K
⌘ K
Display auto complete list
ALT ↓
⌥ ↓
Flash Fill
CTRL E

Formatting Excel Shortcuts

Descriptions
Windows Shortcuts
Mac Shortcuts
Format (almost) anything
CTRL 1
⌘ 1
Display format cells font tab
CTRL SHIFT F
^ ⇧ F
Apply or Remove bold formatting
CTRL B
⌘ B
Apply or Remove italic formatting
CTRL I
⌘ I
Apply or Remove Underscoring
CTRL U
⌘ U
Toggle strike through formatting
CTRL 5
⌘ ⇧ X
Align Center
ALT H A C
⌘ E
Align Left
ALT H A L
⌘ L
Align Right
ALT H A R
⌘ R
Indent
ALT H 6
^ ⌥ TAB
Remove Indent
ALT H 5
^ ⌥ ⇧ TAB
Increase font size one step
ALT H FG
⌘ ⇧ >
Decrease font size one step
ALT H FK
⌘ ⇧ <

Borders Excel Shortcuts

Descriptions
Windows Shortcuts
Mac Shortcuts
Add Border Outline
CTRL SHIFT &
⌘ ⌥ 0
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
Remove Borders
CTRL SHIFT _
⌘ ⌥ _

Dialog Boxes Excel Shortcuts

Descriptions
Windows Shortcuts
Mac Shortcuts
Move to Next Control
TAB
TAB
Cancel and close the dialog box
ESC
ESC
Toggle between open books
CTRL TAB
⇧ TAB
Move to previous tab
CTRL SHIFT TAB
^ ⇧ TAB
Accept and apply
ENTER
RETURN
Check and Uncheck box
SPACE
SPACE

Formulas Excel Shortcuts

Descriptions
Windows Shortcuts
Mac Shortcuts
Toggle Absolute & Relative references
F4
⌘ T
Open Insert function dialog
SHIFT F3
Fn ⇧ F3
AutoSum selected cells
ALT =
⌘ ⇧ T
Toggle formulas on and off
CTRL ‘
^ ‘
Enter Array formula
CTRL SHIFT ENTER
^ ⇧ RETURN
Calculate worksheets
F9
Fn F9
Calculate active worksheet
SHIFT F9
Fn ⇧ F9
Force calculate all worksheets
CTRL ALT F9
Evaluate part of a formula
F9
Fn F9
Expand/Collapse formula bar
CTRL SHIFT U
^ ⇧ U
Display function arguments dialog box
CTRL A
^ A
Define name
CTRL F3
Fn ^ F3
Define names form lables
CTRL SHIFT F3
Fn ^ ⇧ F3
Paste name into formula
F3

Pivot Table Excel Shortcuts

Descriptions
Windows Shortcuts
Mac Shortcuts
Select entire pivot table
CTRL A
⌘ A
Toggle pivot table field checkbox
SPACE
SPACE
Group pivot table items
ALT SHIFT →
⌘ ⇧ K
Ungroup pivot table items
ALT SHIFT ←
⌘ ⇧ J
Hide pivot table item
CTRL –
⌘ –
Create pivot chart on same worksheet
ALT F1
Open pivot table wizard
ALT D P
⌘ ⌥ P
Insert calculated field
CTRL SHIFT +
Create pivot chart on new worksheet
F11
Fn F11

Grid Operations Excel Shortcuts

Descriptions
Windows Shortcuts
Mac Shortcuts
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
Fn DELETE
Hide columns
CTRL 0
^ 0
Hide rows
CTRL 9
^ 9
Unhide rows
CTRL SHIFT 9
^ ⇧ 9
Unhide columns
CTRL SHIFT 0
^ ⇧ 0
Group rows or columns
ALT SHIFT →
⌘ ⇧ K
Ungroup rows or columns
ALT SHIFT ←
⌘ ⇧ J
Open group dialog box
ALT SHIFT →
⌘ ⇧ K
Open ungroup dialog box
ALT SHIFT ←
⌘ ⇧ J
Hide or show outline symbols
CTRL 8
^ 8

Workbook Excel Shortcuts

Descriptions
Windows Shortcuts
Mac Shortcuts
Insert new worksheet
SHIFT F11
Fn ⇧ F11
Go to next worksheet
CTRL Pg Dn
Fn ^ ↓
Go to previous worksheet
CTRL Pg Up
Fn ^ ↑
Move to next pane
F6
Fn F6
Move to previous pane
SHIFT F6
Fn ⇧ F6
Go to next workbook
CTRL TAB
^ TAB
Go to previous workbook
CTRL SHIFT TAB
^ ⇧ TAB
Minimize current workbook window
CTRL F9
⌘ M
Maximize current workbook window
CTRL F10
Fn ^ F10
Toggle scroll lock
SCROLL LOCK
Fn ⇧ F14

Others Excel Shortcuts

Descriptions
Windows Shortcuts
Mac Shortcuts
Open spelling dialog box
F7
Fn F7
Open thesaurus dialog box
SHIFT F7
Fn ⇧ F7
Open macro dialog box
ALT F8
Fn ⌥ F8
Open VBA editor
ALT F11
Fn ⌥ F11
Duplicate object
CTRL D
⌘ D
Snap to grid
ALT
Hide or show objects
CTRL 6
^ 6
Display modify cell style
ALT ‘
⌘ ⇧ L
Display shortcuts menu
SHIFT F10
Fn ⇧ F10
Display control menu
ALT SPACE
?

Creating Reports in Excel is time-consuming but we do have Shortcuts in Excel using which we will save time in navigation, formatting, selecting, and entering Formulas for our Data. You can also learn more tricks in Excel Dashboard Course

What do you think about the idea of Excel Shortcuts here?

What if the Excel Shortcuts can ease out these tasks?

Definitely, it can.

I don’t think there is any Excel User, who vigorously uses Excel and will dislike the idea of Using Excel Shortcut keys.

This will not only save your time but also save you from the extra efforts and pain that you put into using Excel while you deal with heaps of Data.

PDF GUIDE BOOKS

  • Download Excel Shortcuts for Windows & Mac
  • Basic to Advanced Excel Formulas PDF Guide

This Book will help you to get Excel Skills & Boost your career.

FAQs

To insert Time in Excel, follow the steps:

  • Select the Tab in which you wish to insert the time
  • Press Ctrl + Shift + ; (semicolon)
  • The current time will be inserted

To insert Date in Excel, follow the steps:

  • Select the Tab in which you wish to insert the date
  • Press Ctrl + ; (semicolon)
  • The current date will be inserted

Ctrl + F is used to search in Excel

To assign your own shortcuts in Excel, follow the steps:

  • Click on File > Options tab
  • Click on Customize Ribbon
  • Select Customize option at the bottom of the Customize ribbon dialog box
  • In the Save Changes box, select the document for which you want to customize
  • In categories box, select the category or the command
  • Select New Shortcut Key Box, assign the shortcut of your choice
  • Select assign and the changes will be made.

Ctrl + Shift + ~ is the shortcut for general format cells in Excel.

Ctrl + S is the key to save in excel.

Use Ctrl+ N keys to open new sheet in excel

Related posts
ExcelTutorials

How to Find Duplicate Values in Excel

2 Mins read
You can Find duplicate values in Excel by reading this blog. An Excel sheet is a great way of packing lots of…
ExcelTutorials

How to Lock Formulas in Excel?

2 Mins read
How to Lock Formulas in Excel? Protect formula in Excel? Confused? Here is the blog to know how to lock excel formulas….
ExcelTutorials

Remove Password from Excel or Unprotected Excel

3 Mins read
How to remove password from excel spreadsheet or Unprotect Excel Spreadsheet without using any software or Password Remover. So what it includes?…