In one volume Applies to: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2024, Excel 2024 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2016, Excel for iPad, Excel for iPhone, Excel for Android tablets, Excel for Android phones, Excel Mobile. This updated compendium describes keyboard shortcuts, Function keys, and other common shortcut keys for Microsoft Excel for Windows, macOS, and iOS. It also includes Access keys that you can use for Ribbon commands. The shortcuts refer to the US keyboard layout. TABLE OF CONTENTS Windows Keyboard Shortcuts in ExcelFrequently Used ShortcutsRibbon Keyboard ShortcutsUse the Access Keys for Ribbon TabsWork in the Ribbon with the KeyboardKeyboard Shortcuts for Navigating in CellsKeyboard Shortcuts for Formatting CellsKeyboard Shortcuts in the Paste Special Dialog Box in ExcelKeyboard Shortcuts for Making Selections and Performing ActionsKeyboard Shortcuts for Working with Data, Functions, and the Formula BarPower Pivot Keyboard ShortcutsFunction KeysOther Useful Shortcut KeysmacOS Keyboard Shortcuts in ExcelFrequently Used ShortcutsShortcut ConflictsChange System Preferences for Keyboard Shortcuts with the MouseWork in Windows and Dialog BoxesMove and Scroll in a Sheet or WorkbookEnter Data on a SheetWork in Cells or the Formula BarFormat and Edit DataSelect Cells, Columns, or RowsWork with a SelectionUse ChartsSort, Filter, and Use PivotTable ReportsOutline DataUse Function Key ShortcutsChange Function Key Preferences with the MouseDrawingiOS Keyboard Shortcuts in ExcelNavigate the WorksheetFormat and Edit DataWork in Cells or the Formula Bar
