Home » All Microsoft Excel Shortcut Keys (Updated 2025)
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 Key Function Ctrl + N Create a new workbook Ctrl + O Open an existing workbook Ctrl + S Save the workbook Ctrl + P Print the document Ctrl + W Close the workbook Ctrl + Z Undo the last action Ctrl + Y Redo the last action Ctrl + X Cut selected data Ctrl + C Copy selected data Ctrl + V Paste copied data Ctrl + F Open Find dialog box Ctrl + H Open Replace dialog box Ctrl + A Select all data in the worksheet Ctrl + B Apply bold formatting Ctrl + I Apply italic formatting Ctrl + U Apply underline formatting Alt + H + V + V Paste special
2. Navigation Shortcuts
Shortcut Key Function Arrow Keys Move one cell up, down, left, or right Ctrl + Arrow Key Jump to the edge of data region Home Move to the beginning of the row Ctrl + Home Move to cell A1 Ctrl + End Move to the last used cell in a worksheet Page Up Move one screen up Page Down Move one screen down Alt + Page Up Move one screen left Alt + Page Down Move one screen right
3. Cell Editing Shortcuts
Shortcut Key Function F2 Edit the active cell Ctrl + Enter Enter data in selected cells Shift + Enter Enter data and move up Tab Move to the next cell Shift + Tab Move to the previous cell Ctrl + D Copy content from the cell above Ctrl + R Copy content from the left cell Alt + Enter Insert a line break in a cell Ctrl + Space Select the entire column Shift + Space Select the entire row
Shortcut Key Function Ctrl + 1 Open 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 + 9 Hide the selected row Ctrl + Shift + 9 Unhide the hidden row Ctrl + 0 Hide the selected column Ctrl + Shift + 0 Unhide the hidden column
Shortcut Key Function = Start a formula Tab (inside formula) Auto-complete a formula Ctrl + Shift + Enter Enter 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 Key Function Ctrl + T Create a table Ctrl + L Convert range to a table Ctrl + Shift + L Apply or remove filters Ctrl + Shift + U Expand/collapse formula bar Alt + Down Arrow Open dropdown list in a data-validated cell Ctrl + Shift + : Enter current time Ctrl + ; Enter current date
7. Pivot Table Shortcuts
Shortcut Key Function Alt + D + P Create a Pivot Table Alt + J + T Open PivotTable Tools Ctrl + Shift + * (asterisk) Select entire Pivot Table F11 Create a chart from selected data
8. Chart Shortcuts
Shortcut Key Function F11 Insert a chart in a new sheet Alt + F1 Insert a chart in the same sheet Ctrl + 1 Format chart elements
9. Workbook & Worksheet Shortcuts
Shortcut Key Function Ctrl + N Create a new workbook Ctrl + O Open an existing workbook Ctrl + S Save the workbook Ctrl + P Print the workbook Ctrl + Tab Switch between open workbooks Ctrl + Shift + Tab Move to the previous workbook Ctrl + Page Down Move to the next worksheet Ctrl + Page Up Move to the previous worksheet Alt + E + L Delete the active worksheet
10. Miscellaneous Shortcuts
Shortcut Key Function Ctrl + Shift + Arrow Key Select the entire data range Ctrl + Shift + * (asterisk) Select the current data region Ctrl + Shift + F Open the Format Cells dialog box Ctrl + Shift + K Insert 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)
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:
Related Posts
April 21, 2025
April 21, 2025
April 21, 2025
April 21, 2025
April 21, 2025
April 20, 2025