Microsoft Excel, developed by Microsoft, has become the world’s most widely used spreadsheet software. Since its debut in 1985, Excel has evolved into a powerful tool for data analysis, financial modeling, project management, and much more. Microsoft continuously updates Excel, introducing innovative features and enhanced usability, making it indispensable for professionals and students alike.
This comprehensive guide will focus on Excel’s functionality, history, and, most importantly, an extensive list of shortcut keys to boost your productivity.
History of Microsoft Excel
Excel was first released for Mac in 1985, followed by the first Windows version in 1987. Over the years, Excel has revolutionized data management with advanced features like pivot tables, formulas, and VBA macros. Microsoft has also integrated Excel with its Office Suite, OneDrive, and cloud services, making it an all-in-one platform for data analysis and collaboration.
Mastering keyboard shortcuts can save you hours of work. Below is a detailed list of shortcuts categorized for easy reference.
Function Keys in Excel
Key
Function
F1
Shows Excel Help
F2
Enters edit mode for the active cell
F3
Displays the Paste Name dialog box if there is a defined name
F4
Repeats the last action; switches between reference types when editing formulas
F5
Displays the Go To dialog box
F6
Moves between panels in a divided book
F7
Displays the Spelling dialog box
F8
Activates Expand Selection mode
F9
Calculates all open workbooks
F10
Activates the menu bar
F11
Creates a chart sheet
F12
Opens the Save As dialog box
Single Key Shortcuts
Key
Function
Alt
Activates the menu bar
Page Down
Scrolls down one screen
Enter
Completes a cell entry
Esc
Cancels a cell entry
Space
Toggles a checkbox in a dialog box
End
Moves to the last cell in the current range
Home
Moves to the beginning of a row
Tab
Moves to the next cell
Basic Keyboard Shortcuts in Excel
Key
Function
Ctrl+A
Select all
Ctrl+C
Copy
Ctrl+V
Paste
Ctrl+X
Cut
Ctrl+Z
Undo
Ctrl+Y
Redo
Ctrl+S
Save
Ctrl+P
Print
Ctrl+N
New workbook
Ctrl+O
Open workbook
Ctrl and Function Keys
Key
Function
Ctrl+F1
Toggle the ribbon
Ctrl+F2
Print preview
Ctrl+F3
Open Name Manager
Ctrl+F4
Close workbook
Ctrl+F5
Restore workbook window size
Ctrl+F6
Switch between open workbooks
Shift and Function Keys
Key
Function
Shift+F2
Add/edit a cell note
Shift+F3
Open Insert Function dialog box
Shift+F4
Repeat Find action
Shift+F5
Open Find dialog box
Shift+F6
Toggle focus between worksheet areas
Alt and Function Keys
Key
Function
Alt+F1
Create a chart
Alt+F2
Save As
Alt+F4
Close Excel
Alt+F8
Open Macro dialog
Alt+F11
Open VBA editor
Ctrl+Shift Keys
Key
Function
Ctrl+Shift+L
Toggle filters
Ctrl+Shift+U
Expand formula bar
Ctrl+Shift+Enter
Enter array formula
Ctrl+Shift+Home
Extend selection to start of sheet
Ctrl+Shift+End
Extend selection to last used cell
Navigation Shortcuts
Key
Function
Ctrl+Arrow Key
Move to edge of data region
Ctrl+Home
Go to cell A1
Ctrl+End
Go to last used cell
Alt+Page Down
Move one screen to the right
Alt+Page Up
Move one screen to the left
Data Selection Shortcuts
Key
Function
Ctrl+Space
Select current column
Shift+Space
Select current row
Ctrl+Shift+*
Select current region
Shift+Arrow Key
Extend selection
Data Entry and Formulas
Key
Function
Alt+=
AutoSum
Ctrl+`
Toggle formula view
Ctrl+D
Fill down
Ctrl+R
Fill right
Ctrl+Shift+;
Insert current time
Ctrl+Shift+:
Insert current date
Here’s a comprehensive list of Excel Tab Shortcuts for the Home, Insert, Page Layout, Formulas, Data, Review, and View tabs, including their sub-options:
Home Tab (Alt + H)
Clipboard Group:
Alt + H + C: Copy
Alt + H + X: Cut
Alt + H + V: Paste
Alt + H + D: Format as a date
Font Group:
Alt + H + F + F: Font dropdown
Alt + H + FS: Font size
Alt + H + FC: Font color
Alignment Group:
Alt + H + A + C: Center-align
Alt + H + A + L: Left-align
Alt + H + W: Wrap text
Number Group:
Alt + H + N + P: Apply percentage format
Alt + H + N + C: Apply currency format
Style Group:
Alt + H + S + T: Table style
Alt + H + S + J: Cell style
Alt + H + S + N: Conditional Formatting
Editing Group:
Alt + H + E + F: Find and Replace
Alt + H + E + S: Sort and Filter
Alt + H + E + A: Clear contents
Alt + H + E + U: AutoSum
Insert Tab (Alt + N)
Tables Group:
Alt + N + T: Insert Table
Alt + N + P: Insert PivotTable
Illustrations Group:
Alt + N + P: Insert Picture
Alt + N + S: Insert Shape
Alt + N + I: Insert Icon
Charts Group:
Alt + N + C: Insert Chart
Alt + N + K: Column Chart
Alt + N + L: Line Chart
Alt + N + Q: Pie Chart
Sparklines Group:
Alt + N + W: Insert Line Sparkline
Alt + N + K: Insert Column Sparkline
Text Group:
Alt + N + X: Insert Text Box
Alt + N + H: Insert Header/Footer
Links Group:
Alt + N + I: Insert Hyperlink
Symbols Group:
Alt + N + U: Insert Symbol
Alt + N + E: Insert Equation
Page Layout Tab (Alt + P)
Themes Group:
Alt + P + T: Themes dropdown
Alt + P + C: Colors dropdown
Alt + P + F: Fonts dropdown
Page Setup Group:
Alt + P + S + P: Set print area
Alt + P + O: Orientation dropdown
Alt + P + S: Paper size dropdown
Alt + P + M: Margins dropdown
Alt + P + H: Set print titles
Scale to Fit Group:
Alt + P + W: Adjust width (fit columns to page)
Alt + P + H: Adjust height (fit rows to page)
Alt + P + S: Scale percentage
Sheet Options Group:
Alt + P + G + H: Toggle gridlines visibility
Alt + P + G + P: Toggle gridlines print option
Alt + P + H + H: Toggle headings visibility
Arrange Group:
Alt + P + A + A: Align objects
Alt + P + A + S: Bring to front/send to back
Alt + P + A + G: Group or ungroup objects
Formulas Tab (Alt + M)
Function Library Group:
Alt + M + F: Insert Function
Alt + M + N: Name Manager
Alt + M + D: Define Name
AutoSum Group:
Alt + M + U: AutoSum
Alt + M + A + S: Average function
Alt + M + M + S: Min function
Financial Group:
Alt + M + F: Financial functions dropdown
Logical Group:
Alt + M + L: Logical functions dropdown
Text Group:
Alt + M + T: Text functions dropdown
Date & Time Group:
Alt + M + D: Date & Time functions dropdown
Lookup & Reference Group:
Alt + M + L: Lookup & Reference functions dropdown
Math & Trig Group:
Alt + M + H: Math & Trig functions dropdown
Formula Auditing Group:
Alt + M + R: Trace Precedents
Alt + M + D: Trace Dependents
Alt + M + A: Show Formulas
Calculation Group:
Alt + M + X: Enable Manual Calculation
Alt + M + C: Calculate Now
Alt + M + S: Calculate Sheet
Data Tab (Alt + A)
Get & Transform Data Group:
Alt + A + P: Get Data
Alt + A + Q: Queries & Connections
Sort & Filter Group:
Alt + A + S + S: Sort dialog
Alt + A + T: Toggle Filter
Alt + A + F: Reapply Filter
Data Tools Group:
Alt + A + T + E: Text to Columns
Alt + A + R: Remove Duplicates
Alt + A + V: Data Validation
Forecast Group:
Alt + A + W: What-If Analysis
Alt + A + F: Forecast Sheet
Outline Group:
Alt + A + G + G: Group rows/columns
Alt + A + G + U: Ungroup rows/columns
Connections Group:
Alt + A + C: Connections dialog
Alt + A + R + U: Refresh All Connections
Review Tab (Alt + R)
Proofing Group:
Alt + R + F: Spelling
Alt + R + G: Thesaurus
Alt + R + W: Word Count
Language Group:
Alt + R + L: Change Proofing Language
Comments Group:
Alt + R + N: New Comment
Alt + R + P: Previous Comment
Alt + R + C: Next Comment
Alt + R + D: Delete Comment
Changes Group:
Alt + R + T: Track Changes
Alt + R + C: Compare and Merge Workbooks
Alt + R + H: Protect Workbook
Alt + R + P: Protect Sheet
Alt + R + U: Unprotect Sheet
Add-Ins Group:
Alt + R + A: Manage Add-ins
View Tab (Alt + W)
Workbook Views Group:
Alt + W + L: Normal View
Alt + W + P: Page Break Preview
Alt + W + M: Page Layout View
Alt + W + R: Read Mode
Show Group:
Alt + W + F: Toggle Formula Bar
Alt + W + H: Toggle Headings visibility
Alt + W + G: Toggle Gridlines visibility
Alt + W + Z: Toggle Zoom
Alt + W + O: Toggle Outline Symbols visibility
Zoom Group:
Alt + W + Q: Zoom dialog
Alt + W + I: 100% Zoom
Alt + W + T: Fit Selection
Window Group:
Alt + W + S: Switch Windows
Alt + W + N: New Window
Alt + W + M: Minimize Window
Alt + W + F: Freeze Panes
Alt + W + U: Unfreeze Panes
Macros Group:
Alt + W + M: Macros dialog
Alt + W + X: Record Macro
Conclusion
Mastering Excel shortcuts can significantly enhance your productivity and efficiency. As you familiarize yourself with these keys, you’ll be able to navigate, analyze, and manipulate data effortlessly. Whether you’re a beginner or a seasoned Excel user, these shortcuts are a must-have in your toolkit.
FAQs
What are keyboard shortcuts in Excel? Keyboard shortcuts are combinations of keys that perform specific tasks faster than using a mouse.
How can I remember Excel keyboard shortcuts? Start with a few essential shortcuts and gradually learn more as you use them.
Are there shortcuts specific to certain Excel versions? Some shortcuts may vary between versions, but most are consistent.
Can I create custom keyboard shortcuts in Excel? Yes, you can assign macros to custom shortcuts.
How can I view all available shortcuts? Use the “Alt” key to reveal menu shortcuts and check the Help section for a full list.
