All Microsoft Excel Shortcut Keys (Updated 2025)

By Mr Vivek Sharma

Published On:

Follow Us
All Microsoft Excel Shortcut Keys (Updated 2025)

Microsoft Excel provides a wide range of keyboard shortcuts to help users work faster and more efficiently. Here is a categorized list of all essential Microsoft Excel Shortcut KeysExcel shortcut keys.


1. General Excel Shortcuts

Shortcut KeyFunction
Ctrl + NCreate a new workbook
Ctrl + OOpen an existing workbook
Ctrl + SSave the workbook
Ctrl + PPrint the document
Ctrl + WClose the workbook
Ctrl + ZUndo the last action
Ctrl + YRedo the last action
Ctrl + XCut selected data
Ctrl + CCopy selected data
Ctrl + VPaste copied data
Ctrl + FOpen Find dialog box
Ctrl + HOpen Replace dialog box
Ctrl + ASelect all data in the worksheet
Ctrl + BApply bold formatting
Ctrl + IApply italic formatting
Ctrl + UApply underline formatting
Alt + H + V + VPaste special

2. Navigation Shortcuts

Shortcut KeyFunction
Arrow KeysMove one cell up, down, left, or right
Ctrl + Arrow KeyJump to the edge of data region
HomeMove to the beginning of the row
Ctrl + HomeMove to cell A1
Ctrl + EndMove to the last used cell in a worksheet
Page UpMove one screen up
Page DownMove one screen down
Alt + Page UpMove one screen left
Alt + Page DownMove one screen right

3. Cell Editing Shortcuts

Shortcut KeyFunction
F2Edit the active cell
Ctrl + EnterEnter data in selected cells
Shift + EnterEnter data and move up
TabMove to the next cell
Shift + TabMove to the previous cell
Ctrl + DCopy content from the cell above
Ctrl + RCopy content from the left cell
Alt + EnterInsert a line break in a cell
Ctrl + SpaceSelect the entire column
Shift + SpaceSelect the entire row

4. Formatting Shortcuts

Shortcut KeyFunction
Ctrl + 1Open the Format Cells dialog box
Ctrl + Shift + $Apply currency format
Ctrl + Shift + %Apply percentage format
Ctrl + Shift + #Apply date format
Ctrl + Shift + @Apply time format
Ctrl + Shift + !Apply number format
Ctrl + Shift + &Apply outline border
Ctrl + Shift + _Remove borders
Ctrl + 9Hide the selected row
Ctrl + Shift + 9Unhide the hidden row
Ctrl + 0Hide the selected column
Ctrl + Shift + 0Unhide the hidden column

5. Formula & Function Shortcuts

Shortcut KeyFunction
=Start a formula
Tab (inside formula)Auto-complete a formula
Ctrl + Shift + EnterEnter an array formula
Ctrl + ‘Copy the formula from the above cell
Ctrl + `[Backtick]Show all formulas in the worksheet
Alt + =Auto-sum selected range

6. Data Management Shortcuts

Shortcut KeyFunction
Ctrl + TCreate a table
Ctrl + LConvert range to a table
Ctrl + Shift + LApply or remove filters
Ctrl + Shift + UExpand/collapse formula bar
Alt + Down ArrowOpen dropdown list in a data-validated cell
Ctrl + Shift + :Enter current time
Ctrl + ;Enter current date

7. Pivot Table Shortcuts

Shortcut KeyFunction
Alt + D + PCreate a Pivot Table
Alt + J + TOpen PivotTable Tools
Ctrl + Shift + * (asterisk)Select entire Pivot Table
F11Create a chart from selected data

8. Chart Shortcuts

Shortcut KeyFunction
F11Insert a chart in a new sheet
Alt + F1Insert a chart in the same sheet
Ctrl + 1Format chart elements

9. Workbook & Worksheet Shortcuts

Shortcut KeyFunction
Ctrl + NCreate a new workbook
Ctrl + OOpen an existing workbook
Ctrl + SSave the workbook
Ctrl + PPrint the workbook
Ctrl + TabSwitch between open workbooks
Ctrl + Shift + TabMove to the previous workbook
Ctrl + Page DownMove to the next worksheet
Ctrl + Page UpMove to the previous worksheet
Alt + E + LDelete the active worksheet

10. Miscellaneous Shortcuts

Shortcut KeyFunction
Ctrl + Shift + Arrow KeySelect the entire data range
Ctrl + Shift + * (asterisk)Select the current data region
Ctrl + Shift + FOpen the Format Cells dialog box
Ctrl + Shift + KInsert a hyperlink
Ctrl + Shift + +Insert a new row or column
Ctrl + – (Minus)Delete a selected row or column

These Excel shortcut keys will help you work faster and smarter by reducing dependency on the mouse and improving productivity. 🚀📊

Let me know if you need a PDF version or more details on any specific function! 😊

All Microsoft Excel Shortcut Keys (Updated 2025)

Mr Vivek Sharma

Hello, I am Mr. Vivek Sharma, your ADCA (Advanced Diploma in Computer Applications) teacher. With a passion for technology and education, I am dedicated to preparing students for success in the IT industry. Here’s a brief introduction about me:

Join WhatsApp

Join Now

Join Telegram

Join Now

Leave a Comment