In one volume
See all of our technology books and tutorials!
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel 2019, Excel 2016, Excel 2019 for Mac, Excel 2013, Excel 2010, Excel 2007, Excel 2016 for Mac, Excel for Mac 2011, Excel for iPhone, Excel for Windows Phone 10.
This article describes keyboard shortcuts, Function keys, and some other common shortcut keys for Microsoft Excel for Windows. This includes the access keys that you can use for Ribbon commands.
TABLE OF CONTENTS
Windows Keyboard Shortcuts in Excel 1
Frequently Used Shortcuts
Ribbon Keyboard Shortcuts
Use the Access Keys for Ribbon Tabs
Work in the Ribbon with the Keyboard
Keyboard Shortcuts for Navigating in Cells
Keyboard Shortcuts for Formatting Cells
Keyboard Shortcuts in the Paste Special Dialog in Excel 2013
Keyboard Shortcuts for Making Selections and Performing Actions
Keyboard Shortcuts for Working with Data, Functions, and the Formula Bar
Power Pivot Keyboard Shortcuts
Keyboard Shortcuts in Office Add-Ins
Function Keys
Other Useful Shortcut Keys
macOS Keyboard Shortcuts in Excel
Frequently Used Shortcuts
Shortcut Conflicts
Change System Preferences for Keyboard Shortcuts with the Mouse
Work in Windows and Dialogs
Move and Scroll in a Sheet or Workbook
Enter Data on a Sheet
Work in Cells or the Formula Bar
Format and Edit Data
Select Cells, Columns, or Rows
Work with a Selection
Use Charts
Sort, Filter, and Use PivotTable Reports
Outline Data
Use Function Key Shortcuts
Change Function Key Preferences with the Mouse
Drawing
iOS Keyboard Shortcuts in Excel
Navigate the Worksheet
Format and Edit Data
Work in Cells or the Formula Bar
