Excel shortcuts
- 159 shortcuts
- 12 sections
- Microsoft Office
- Also on: macOS
- Verified against official docs
Your answer helps keep this page right.
Do these shortcuts work for you?
The Navigation section jumps to the ends of the sheet with Go to Cell A1 and Go to Last Cell, and between sheets with Previous Sheet and Next Sheet. Formulas has AutoSum, Show Formulas and Toggle Absolute Reference.
Start with these
Tips for Excel
- Fill Down CtrlD fills the selection downward and Fill Right CtrlR fills it to the right.
- Insert Current Date Ctrl; and Insert Current Time CtrlShift; put the date or the time into the cell.
- Toggle Absolute Reference F4 switches a cell reference in a formula between relative and absolute.
Jump to section
Editing25
| Action | Shortcut |
|---|---|
| Edit Cell | |
| Fill Selection with Entry | |
| Insert Current Date | |
| Insert Current Time | |
| Fill Down | |
| Fill Right | |
| Copy Selection | |
| Paste Selection | |
| Undo Recent Action | |
| Remove Cell Contents | |
| Cut Selection | |
| Insert or Edit Cell Note | |
| Insert or Reply to Threaded Comment | |
| Open Insert Dialog to Insert Blank Cells | |
| Open Delete Dialog to Delete Selected Cells | |
| Copy Formula from Cell Above | |
| Open Paste Special Dialog | |
| Open Insert Hyperlink Dialog | |
| Check Spelling | |
| Start New Line in Same Cell | |
| Complete Cell Entry and Select Cell Above | |
| Repeat Last Command or Action | |
| Cancel Entry in Cell or Formula Bar | |
| Complete Formula Bar Entry and Select Cell Below | |
| Copy Value from Cell Above |
Formatting19
| Action | Shortcut |
|---|---|
| Format Cells | |
| Bold | |
| Italic | |
| Underline | |
| Currency Format | |
| Percentage Format | |
| Format Fonts in Format Cells Dialog | |
| Apply or Remove Strikethrough | |
| Switch Among Hidden, Displayed, and Placeholder Objects | |
| Apply Outline Border to Selected Cells | |
| Remove Outline Border from Selected Cells | |
| Display or Hide Outline Symbols | |
| Apply General Number Format | |
| Apply Scientific Number Format | |
| Apply Date Format with Day, Month, and Year | |
| Apply Time Format with Hour and Minute | |
| Apply Number Format with Two Decimal Places | |
| Display Quick Analysis Options | |
| Open Workbook Statistics Dialog |
Formulas17
| Action | Shortcut |
|---|---|
| AutoSum | |
| Show Formulas | |
| Array Formula | |
| Toggle Absolute Reference | |
| Accept AutoComplete | |
| Turn Formula Checking Tooltips On or Off | |
| Expand or Collapse Formula Bar | |
| Calculate All Worksheets in All Open Workbooks | |
| Calculate Active Worksheet | |
| Calculate All Open Workbooks, Changed or Not | |
| Check Dependent Formulas, Then Calculate All Cells | |
| Display Menu or Message for Error Checking Button | |
| Show Function Arguments After a Function Name | |
| Insert Argument Names and Parentheses for a Function | |
| Insert Function | |
| Define Name to Use in References | |
| Paste Name from Paste Name Dialog |
Frequently Used9
| Action | Shortcut |
|---|---|
| Close Workbook | |
| Open Workbook | |
| Save Workbook | |
| Choose Fill Color | |
| Center Align Cell Contents | |
| Add Borders | |
| Delete Column | |
| Hide Selected Rows | |
| Hide Selected Columns |
Ribbon12
| Action | Shortcut |
|---|---|
| Go to Home Tab | |
| Go to Insert Tab | |
| Go to Page Layout Tab | |
| Go to Data Tab | |
| Go to View Tab | |
| Go to Formulas Tab | |
| Go to Search Field on the Ribbon | |
| Open File Menu | |
| Open Review Tab | |
| Show Tooltip for Focused Ribbon Element | |
| Open Menu for Selected Button | |
| Expand or Collapse Ribbon |
Selection10
| Action | Shortcut |
|---|---|
| Select Current and Next Sheet | |
| Select Current and Previous Sheet | |
| Turn Extend Selection Mode On or Off | |
| Add Non-Adjacent Cell or Range to Selection | |
| Select Entire Column | |
| Select Entire Row | |
| Select All Objects When an Object Is Selected | |
| Extend Selection to Beginning of Worksheet | |
| Select Current Region Around Active Cell | |
| Select First Command When a Menu Is Visible |
Paste Special Dialog11
| Action | Shortcut |
|---|---|
| Paste All Cell Contents and Formatting | |
| Paste Only Formulas | |
| Paste Only Values | |
| Paste Only Formatting | |
| Paste Only Comments and Notes | |
| Paste Only Data Validation Settings | |
| Paste All Contents and Formatting from Copied Cells | |
| Paste All Cell Contents Without Borders | |
| Paste Only Column Widths | |
| Paste Only Formulas and Number Formats | |
| Paste Only Values and Number Formats |
Data7
| Action | Shortcut |
|---|---|
| Invoke Flash Fill for Current Column | |
| Create Embedded Chart from Current Range | |
| Create Chart in Separate Chart Sheet | |
| Create, Run, Edit, or Delete Macro | |
| Open Visual Basic for Applications Editor | |
| Open Power Query Editor | |
| Refresh All Data in Workbook |
Power Pivot10
| Action | Shortcut |
|---|---|
| Move Table | |
| Select from Current Cell to Last Cell of Column | |
| Select from Current Cell to First Cell of Column | |
| Select from Current Cell to Last Cell of Row | |
| Select from Current Cell to First Cell of Row | |
| Move to First Cell of Selected Row | |
| Move to Last Cell of Selected Row | |
| Move to First Cell of Selected Column | |
| Move to Last Cell of Selected Column | |
| Close Dialog Box or Cancel a Process |
Copilot3
| Action | Shortcut |
|---|---|
| Switch Between Edit, Chat, and Plan Mode | |
| Confirm Use of Selected Files | |
| Start Dictation for Copilot |
Function Keys19
| Action | Shortcut |
|---|---|
| Display Help Task Pane | |
| Insert New Worksheet | |
| Toggle Full Screen Mode | |
| Edit Active Cell in Formula Bar | |
| Close Selected Workbook Window | |
| Close Excel | |
| Display Go To Dialog | |
| Switch Between Worksheet, Ribbon, Task Pane, and Zoom | |
| Switch Between Worksheet, Zoom, Task Pane, and Ribbon | |
| Switch Between Two Excel Windows | |
| Switch Between All Excel Windows | |
| Move Workbook Window When Not Maximized | |
| Size Workbook Window When Not Maximized | |
| Minimize Workbook Window to an Icon | |
| Turn Key Tips On or Off | |
| Display Context Menu for Selected Item | |
| Maximize or Restore Selected Workbook Window | |
| Insert New Worksheet | |
| Display Save As Dialog |
Report a problem
GitHub is public. Email is private.
Related resources
More Microsoft Office shortcuts
Explore more Windows apps
Frequently Asked Questions
How many keyboard shortcuts does Excel have on Windows?
Excel has 159 keyboard shortcuts on Windows, organized into 12 sections: Navigation, Editing, Formatting, Formulas, and more. This page lists all of them with searchable, organized shortcut tables.
Which Excel shortcuts should I learn first?
Start with Edit Cell (F2), Fill Down (Ctrl+D), AutoSum (Alt+=), Format Cells (Ctrl+1), Go To Dialog (Ctrl+G), Insert Current Date (Ctrl+;). The sections on this page list the rest.
Can I download Excel shortcuts as a PDF?
Yes. Click the download button at the top of this page to generate a printable PDF cheat sheet with all 159 Excel shortcuts. The PDF includes organized sections, keycap-style key labels, and space for your own notes.
Where is the official Excel keyboard shortcuts documentation?
The official Excel keyboard shortcuts documentation is available on their website. Every shortcut on this page is sourced from and verified against the official documentation to ensure accuracy.
Do these Excel shortcuts work on all Windows keyboards?
Yes. These shortcuts work on standard Windows keyboards. The modifier keys are Ctrl, Alt, Shift, and the Windows key (⊞). Some laptop keyboards may have compact layouts where certain keys require an Fn modifier to access.
Maintained by Vladik Didyk