Welcome to next-gen Illumeo platform. All individual and corporate users are required to reset their account passwords before accessing the new platform. Click login and then 'Lost my Password' and follow the simple process. For any assistance, please email us at support@illumeo.com
Awesome Image

Smart Business Consultancy
in New Milton

We denounce with righteous indignation and dislike men who we are to beguiled demoralized by the charms of pleasures that moment, so we blinded desires, that they indignations.

Contact Info

  • 96 Queen Park, Los Vegas, USA
  • +1 800 555 44 00
  • mail@illumeo.com
  • Office Hrs: Today 9.00am to 6.00pm

Excel Shortcut Cheat Sheet

Excel Shortcut Cheat Sheet

Here’s a cheat sheet of the top 100 Excel shortcuts categorized by different areas of usage for Windows (with Mac equivalents where applicable). You can use this for faster navigation and productivity in Excel.

All Excel shortcuts are divided into categories including;

  • General Excel Shortcuts
  • Navigation Shortcuts
  • Data Entry & Editing Shortcuts
  • Formula Shortcuts
  • Formatting Shortcuts
  • Selection & Highlighting Shortcuts
  • Worksheet Shortcuts 
  • Pivot Table Shortcuts 
  • Excel Charts Shortcuts
  • Additional Shortcuts

You can download a PDF file of these shortcuts by clicking this link: https://app.box.com/s/u1anjl6caf3fn6k27e788g4i1howaaqt

Excel Shortcuts

General Shortcuts

Description

Shortcut

Create a new workbook –Ctrl + N
Open an existing workbook –Ctrl + O
Save the workbook –Ctrl + S
Print the workbook –Ctrl + P
Close the current workbook –Ctrl + W
Copy selected cells –Ctrl + C
Cut selected cells –Ctrl + X
Paste copied/cut cells –Ctrl + V
Undo last action –Ctrl + Z
Redo last undone action –Ctrl + Y
Open Find and Replace dialog (Find tab) –Ctrl + F
Open Find and Replace dialog (Replace tab)-Ctrl + H
Select all cells in the current sheet –Ctrl + A
Apply or remove bold formatting –Ctrl + B
Apply or remove italic formatting –Ctrl + I
Apply or remove underline formatting –Ctrl + U
Show or hide the Ribbon –Ctrl + F1
Open the Format Cells dialog –Ctrl + Shift + F
Navigation Shortcuts

Description

Shortcut

Move one cell up, down, left, or right – Arrow Keys
Move to the edge of data region (up/down/left/right)-Ctrl + Arrow Key
Select cells in the direction of arrow-Shift + Arrow Key
Move to the beginning of the worksheet –Ctrl + Home
Move to the last cell with data –Ctrl + End
Move one screen up –Page Up
Move one screen down –Page Down
Move one screen to the left –Alt + Page Up
Move one screen to the right –Alt + Page Down
Go to a specific cell –F5
Open the Go To dialog box –Ctrl + G
Data Entry and Editing

Description

Shortcut

Edit the active cellF2
Fill down from the cell aboveCtrl + D
Fill right from the cell on the leftCtrl + R
Fill selected cells with the current entryCtrl + Enter
Start a new line within a cellAlt + Enter
Insert the current dateCtrl + ; (semicolon)
Insert the current timeCtrl + Shift + : (colon)
Delete selected cells/rows/columnsCtrl + – (minus)
Insert cells/rows/columnsCtrl + Shift + + (plus)
Toggle AutoFilter for the tableCtrl + Shift + L
Formula Shortcuts

Description

Shortcut

Start a formula= (equal sign)
Insert the SUM functionAlt + = (equals)
Enter an array formulaCtrl + Shift + Enter
Toggle showing formulas in cellsCtrl + ` (backtick)
Expand or collapse the formula barCtrl + Shift + U
Calculate all worksheetsF9
Calculate the active worksheetShift + F9
Open the Insert Function dialogAlt + M + F
Go to the cell that a formula refers toCtrl + [
Go to cells that reference the current cellCtrl + ]
Formatting Shortcuts

Description

Shortcut

Open the Format Cells dialogCtrl + 1
Apply currency formatCtrl + Shift + $
Apply percentage formatCtrl + Shift + %
Apply date format (dd-mm-yyyy)Ctrl + Shift + #
Apply time format (hhAM/PM)Ctrl + Shift + @
Apply exponential number formatCtrl + Shift + ^
Apply a border around the selected cellsCtrl + Shift + &
Remove the border from the selected cellsCtrl + Shift + _
Apply general number formatCtrl + Shift + ~
Open the Fill Color dropdownAlt + H + H
Open the Font dropdownAlt + H + F
Selection and Highlighting

Description

Shortcut

Select the entire rowShift + Space
Select the entire columnCtrl + Space
Select the entire worksheetCtrl + Shift + Space
Select to the edge of the data regionCtrl + Shift + Arrow Key
Add to the selectionShift + F8
Select the entire worksheetCtrl + A (twice)
Worksheet Shortcuts

Description

Shortcut

Move to the next worksheetCtrl + Page Down
Move to the previous worksheetCtrl + Page Up
Insert a new worksheetShift + F11
Hide the selected rowsCtrl + 9
Hide the selected columnsCtrl + 0
Unhide hidden rowsCtrl + Shift + 9
Unhide hidden columnsCtrl + Shift + 0
PivotTable Shortcuts

Description

Shortcut

Open the Create PivotTable dialogAlt + N + V
Select the entire PivotTableAlt + J + T
Expand the selected item in a PivotTableAlt + Shift + Right Arrow
Collapse the selected item in a PivotTableAlt + Shift + Left Arrow
Refresh the PivotTableAlt + F5
Refresh all PivotTables in the workbookCtrl + Alt + F5
Working with Charts

Description

Shortcut

Create a chart with the selected dataF11
Create an embedded chart with the selected dataAlt + F1
Open the Chart ToolsAlt + J + C
Create a chart title using the labels in the selectionCtrl + Shift + F3
Open the list of chart elementsAlt + Down Arrow
Miscellaneous Shortcuts

Description

Shortcut

Open the Spelling checkF7
Open the Paste Special dialogAlt + E + S
AutoFit column widthAlt + H + O + I
Open the Remove Duplicates dialogAlt + A + M
Insert a hyperlinkCtrl + K

These shortcuts can help significantly speed up your workflow when using Excel, especially when you are working on large datasets or performing repetitive tasks.

Leave A Comment

Popular Post

LOGIN

lost your password?