200 MS Excel Shortcuts for Windows & Mac
I hope you must have learned Excel Shortcut Keys or at least you must have found your daily used shortcut which can be used in your daily life. There is also a Huge list of Excel Formula Shortcuts. This is based on our experience with consulting and interacting with 30,000+ students in the classroom sessions.
There are many more function keys in Excel 2007, Excel 2010 Excel 2016. But the running Basic Excel shortcuts keys which come in our daily use and save time in our daily routines are included.
File - Excel Shortcuts
Create new workbook
Open workbook
Save workbook
Save as
Print Excel sheet
Open print preview window
Close current window
Close Excel
Ribbon - Excel Shortcuts
Expand or collapse
Excel hot keys
Move to Next Ribbon Control
Move to a previous button
Accept and Confirm
Get help
Active Cell - Excel Shortcuts
Select active cell only
Show active cell on a worksheet
Move active cell clockwise in selection
Move active cell down in selection
Move active cell up in selection
Move active cell Right in a selection
Move active cell Left in a selection
General - Excel Shortcuts
Open Help
Undo last action
Redo last action
Copy selected cells
Repeat last action
Cut selected cells
Paste content from clipboard
Display Paste Special
Display Find and Replace
Find with Replace selected
Find previous match
Find next match
Create Embedded Chart
Create chart in new worksheet
Toggle auto filter
Activate filter Dropdown
Insert table
Select table row
Select table column
Select table
Selection - Excel Shortcuts
Select entire row
Select entire column
Select entire worksheet
Toggle add to selection mode
Cancel selection
Navigation - Excel Shortcuts
Move one cell right
Move one cell left
Move one cell up
Move one cell down
Move one screen Right
Move one screen left
Move one screen up
Move one screen down
Move to right edge of data region
Move to left edge of data region
Move to top edge of data region
Move to bottom edge of data region
Move to beginning of row
Move to last cell in worksheet
Move to first cell in worksheet
Turn End mode on
Number Formatting - Excel Shortcuts
Apply general format
Apply Currency Format
Apply Percentage Format
Apply Scientific Format
Apply Date Format
Apply Time Format
Apply Number Format
Extend Selection (ES) - Excel Shortcuts
ES by One Cell Right
ES by One Cell Left
ES by One cell Up
ES by One Cell Down
ES to the last Cell Right
ES to the last Cell Left
ES to the last Cell Up
ES to the Last Cell Down
ES Up One Screen
ES Down One Screen
ES Right One Screen
ES Left One Screen
ES to Start of Row
ES to the First Cell in the worksheet
ES to the last cell in the Worksheet
Toggle ES Mode
Select Special - Excel Shortcuts
Display ‘Go To’ Dialog Box
Select Row Differences
Select Column Differences
Select Cells with Comments
Select Current Region
Select Current Array
Select Direct Precedents
Select All Precedents
Select Direct Dependents
Select All Dependents
Select Visible Cells Only
Cell Edit Mode - Excel Shortcuts
Edit the Active Cell
Insert OR Edit Comment
Cancel Entry
Select One Character Right
Select One Character Left
Move One Word Right
Move One Word Left
Select One Word Right
Select to Beginning of cell
Select to End of the Cell
Delete Character to the Left of Cursor
Delete Character to the Right of Cursor
Start a new line in the same cell
Entering Data - Excel Shortcuts
Enter and Move down
Enter and Move up
Enter and Move right
Enter and Move left
Enter same data in multiple cells
Insert Current Date
Insert current time
Fill down from cell above
Fill right from cell left
Copy formulas from cell above
Copy value from cell above
Add Hyperlink
Display auto complete list
Flash Fill
Formatting - Excel Shortcuts
Format (almost) anything
Display format cells font tab
Apply or Remove bold formatting
Apply or Remove italic formatting
Apply or Remove Underscoring
Toggle strike through formatting
Align Center
Align Left
Align Right
Indent
Remove Indent
Increase font size one step
Decrease font size one step
Borders - Excel Shortcuts
Add Border Outline
Add OR Remove Border Right
Add OR Remove Border Left
Add OR Remove Border Top
Add OR Remove Border Bottom
Add OR Remove Border Upward Diagonal
Add OR Remove Border Horizontal Interior
Remove Borders
Dialog Boxes - Excel Shortcuts
Move to Next Control
Cancel and close the dialog box
Toggle between open books
Move to previous tab
Accept and apply
Check and Uncheck box
Formulas - Excel Shortcuts
Toggle Absolute & Relative references
Open Insert function dialog
AutoSum selected cells
Toggle formulas on and off
Enter Array formula
Calculate worksheets
Calculate active worksheet
Force calculate all worksheets
Evaluate part of a formula
Expand/Collapse formula bar
Display function arguments dialog box
Define name
Define names form lables
Paste name into formula
Pivot Table - Excel Shortcuts
Select entire pivot table
Toggle pivot table field checkbox
Group pivot table items
Ungroup pivot table items
Hide pivot table item
Create pivot chart on same worksheet
Open pivot table wizard
Insert calculated field
Create pivot chart on new worksheet
Grid Operations - Excel Shortcuts
Display insert dialog box
Insert rows
Insert columns
Display delete dialog box
Delete rows
Delete columns
Delete cells
Delete contents of selected cells
Hide columns
Hide rows
Unhide rows
Unhide columns
Group rows or columns
Ungroup rows or columns
Open group dialog box
Open ungroup dialog box
Hide or show outline symbols
Workbook - Excel Shortcuts
Insert new worksheet
Go to next worksheet
Go to previous worksheet
Move to next pane
Move to previous pane
Go to next workbook
Go to previous workbook
Minimize current workbook window
Maximize current workbook window
Toggle scroll lock
Others - Excel Shortcuts
Open spelling dialog box
Open thesaurus dialog box
Open macro dialog box
Open VBA editor
Duplicate object
Snap to grid
Hide or show objects
Display modify cell style
Display shortcuts menu
Display control menu