EXCEL SHORTCUT KEYS
While working with Microsoft Excel, you must have came across the situation where you want to find efficient way of working with Excel and to improve the existing skills.
Keyboard Shortcuts Guide will help you build your interest in Microsoft Excel and would take your skills to next level. This will also help to increase existing productivity level so that saved time can be utilized in learning new skills.
So Keep reading the article to add values to your existing knowledge.
Excel Shortcut Keys For - FILE
Create new workbook
Ctrl + N
⌘ + N
Open workbook
Ctrl + O
⌘ + O
Save workbook
Ctrl + S
⌘ + S
Save as
F12
⌘ + ⇧ + S
Print file
Ctrl + P
⌘ + P
Open print preview window
Ctrl + F2
Close current workbook
Ctrl + W
⌘ + W
Close Excel
Alt + F4
⌘ + Q
Excel Shortcut Keys For - RIBBON
Expand or collapse ribbon
Ctrl + F1
⌘ + ⌥ + R
Activate access keys
Alt
Move to next ribbon control
Tab
Tab
Activate or open selected control
Space
Space
Confirm control change
Enter
Return
Get help on selected control
F1
Excel Shortcut Keys For - GENERAL
Open options
Alt + F + T
⌘ + /
Undo last action
Ctrl + Z
⌘ + Z
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 the Paste Special dialog box
Ctrl + Alt + V
⌘ + ⌃ + V
Display find and replace
Ctrl + F
⌘ + F
Display find and replace, replace selected
Ctrl + H
⌃ + H
Find next match
Shift + F4
⌘ + G
Find previous match
Ctrl + Shift + F4
⌘ + ⇧ + G
Create embedded chart
Alt + F1
Fn + ⌥ + F1
Create chart in new worksheet
F11
Fn + F11
Excel Shortcut Keys For - TABLES AND FILTERS
Insert table
Ctrl + T
⌃ + T
Toggle Autofilter
Ctrl + Shift + L
⌘ + ⇧ + F
Activate filter
Alt + ↓
⌥ + ↓
Select table row
Shift + Space
⇧ + Space
Select table column
Ctrl + Space
⌃ + Space
Select table
Ctrl + A
⌘ + A
Clear slicer filter
Alt + C
⌥ + C
Toggle table total row
Ctrl + Shift + T
⌘ + ⇧ + T
Excel Shortcut Keys For - DRAG AND COPY
Drag and cut
drag
drag
Drag and copy
Ctrl + drag + L
⌥ + drag
Drag and insert
Shift + drag
⇧ + drag
Drag and insert copy
Ctrl + Shift + drag
⌥ + ⇧ + drag
Excel Shortcut Keys For - NAVIGATION
Move one cell right
→
→
Move one cell left
←
←
Move one cell up
↑
↑
Move one cell down
↓
↓
Move one screen right
Alt + PgDn
Fn + ⌥ + ↓
Move one screen left
Alt + PgUp
Fn + ⌥ + ↑
Move one screen up
PgUp
Fn + ↑
Move one screen down
PgDn
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
Fn + ←
Move to last cell in worksheet
Ctrl + End
Fn + ⌃ + →
Turn End mode on
End
Fn + →
Go back to hyperlink
Ctrl + G + Enter
⌃ + G + Return
Excel Shortcut Keys For - SELECTION
Select entire row
Shift + Space
⇧ + Space
Select entire column
Ctrl + Space
⌃ + Space
Select entire worksheet
Ctrl + A
⌘ + A
Add adjacent cells to selection
Shift + Click
⇧ + 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
Fn + ⇧ + F8
Cancel selection
Esc
Esc
Excel Shortcut Keys For - FORMATTING
Format cells
Ctrl + 1
⌘ + 1
Display Format Cells with Font tab selected
Ctrl + Shift + F
⌃ + ⇧ + F
Apply or remove bold
Ctrl + B
⌘ + B
Apply or remove italics
Ctrl + I
⌘ + I
Apply or remove underscore
Ctrl + U
⌘ + U
Apply or remove strikethrough
Ctrl + 5
⌘ + ⇧ + X
Align center
Alt + H + AC
⌘ + E
Align left
Alt + H + AL
⌘ + L
Align right
Alt + H + AR
⌘ + R
Indent
Alt + H + 6
⌃ + ⌥ + Tab
Remove indent
Alt + H + 5
⌃ + ⌥ + ⇧ + Tab
Wrap text
Alt + H + W
Align top
Alt + H + AT
Align middle
Alt + H + AM
Align bottom
Alt + H + AB
Increase font size one step
Alt + H + FK
⌘ + ⇧ + <
Decrease font size one step
Alt + H + FG
⌘ + ⇧ + >
Excel Shortcut Keys For - NUMBER FORMATTING
Apply general format
Ctrl + Shift + ~
⌃ + ⇧ + ~
Apply number format
Ctrl + Shift + !
⌃ + ⇧ + !
Apply time format
Ctrl + Shift + @
⌃ + ⇧ + @
Apply date format
Ctrl + Shift + #
⌃ + ⇧ + #
Apply currency format
Ctrl + Shift + $
⌃ + ⇧ + $
Apply percentage format
Ctrl + Shift + %
⌃ + ⇧ + %
Apply scientific format
Ctrl + Shift + ^
⌃ + ⇧ + ^
Excel Shortcut Keys For - BORDERS
Open list of border styles from Ribbon
Alt + H + B
Add border around selected cells
Ctrl + Shift + &
⌘ + ⌥ + →
Add or remove right border
Alt + H + BR
Add or remove left border
Alt + H + BL
Add or remove top border
Alt + H + BP
Add or remove bottom border
Alt + H + BO
Add all borders to all cells in selection
Alt + H + BA
Remove borders
Ctrl + Shift + –
Excel Shortcut Keys For - FORMULAS
Begin entering a formula
= OR +
Toggle absolute and relative references (in cell edit mode)
F4
⌘ + T
Open the Insert Function Dialog Box
Shift + F3
Fn + ⇧ + F3
Autosum
Alt + =
⌘ + ⇧ + T
Toggle displaying formulas on and off
Ctrl + `
⌃ + `
Insert function arguments
Ctrl + Shift + A
⌃ + ⇧ + A
Enter array formula
Ctrl + Shift + Enter
⌃ + ⇧ + Return
Calculate worksheets
F9
Fn + F9
Calculate active worksheet
Shift + F9
Force calculate all worksheets
Ctrl + Alt + F9
Evaluate part of a formula (in cell edit mode)
F9
Expand or collapse the formula bar
Ctrl + Shift + U
⌃ + ⇧ + U
Display function arguments dialog box
Ctrl + A
⌃ + A
Open Name Manager
Ctrl + F3
Create name from values in row(s)/column(s)
Ctrl + Shift + F3
Fn + ⌃ + ⇧ + F3
Paste name into formula
F3
Accept function with auto-complete
Tab
↓ + Tab
Excel Shortcut Keys For - GRID OPERATIONS
Display Insert Dialog box
Ctrl + +
⌘ + ⇧ + +
Insert selected number of rows
Ctrl + +
⌘ + ⇧ + +
Insert selected number of columns
Ctrl + +
⌘ + ⇧ + +
Display Delete dialog box
Ctrl + –
⌘ + –
Delete selected number of rows
Ctrl + –
⌘ + –
Delete selected number of columns
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
Group rows or columns (with rows/columns selected)
Alt + Shift + →
⌘ + ⇧ + K
Ungroup rows or columns (with rows/columns selected)
Alt + Shift + ←
⌘ + ⇧ + J
Hide or show outline symbols
Ctrl + 8
⌃ + 8
Excel Shortcut Keys For - PIVOT TABLES
Pivot Tables
Create pivot table
Alt + N + V
Select entire pivot table
Ctrl + A
⌘ + A
Group pivot table items
Alt + Shift + →
⌘ + ⇧ + K
Ungroup pivot table items
Alt + Shift + ←
⌘ + ⇧ + J
Hide (filter out) pivot table item
Ctrl + –
Ctrl + –
Unhide (clear filter on) pivot table item
Alt + H + SC
Insert pivot chart
Alt + NS + ZC
Learn Excel in Easy Way and Make Your Data Meaningful.
Explore Our Resources
Excel Formula Tips.
Excel Data Tips.
Excel Utilities/Templates
Excel VBA Codes/Macros
Excel VBA Course : Beginners to Advanced
We are offering Excel VBA Course for Beginners to Experts at discounted prices. The courses includes On Demand Videos, Practice Assignments, Q&A Support from our Experts. Also after successfully completion of the certification, will share the success with Certificate of Completion
This course is going to help you to excel your skills in Excel VBA with our real time case studies.
Lets get connected and start learning now. Click here to Enroll.
Secrets of Excel Data Visualization: Beginners to Advanced Course
Here is another best rated Excel Charts and Graph Course from ExcelSirJi. This courses also includes On Demand Videos, Practice Assignments, Q&A Support from our Experts.
This Course will enable you to become Excel Data Visualization Expert as it consists many charts preparation method which you will not find over the internet.
So Enroll now to become expert in Excel Data Visualization. Click here to Enroll.
Use Automated Excel Utility Tools to increase productivity
- Quickly Move or Delete Files or Folder >> Click here
- Handle Duplicate Files with Automated Utlity >> Click here
- Generate Dummy Data For Testing >> Click here
- Excel Files and Sheets Consolidator >> Click here
- Manage Outlook Emails efficiently >> CLick here
- Send Bulk Emails wiht our Excel Automation >> Click here
Hope you are enjoying learning Excel with us, if you want any support related to this article, please do comment else you can ask questions in Excel Community