LIBRARY

All shortcuts

Browse every published shortcut. Start here if you want the full catalog instead of the interactive tools.

Open explorer
Microsoft Excel

Open the File menu

Open the File menu in the active application to access file-related options like New, Open, Save, and Print.

Alt + F
Microsoft Excel

Open Home Tab and Format Text

Press Alt + H to open the Home tab in the ribbon, then use additional keys to format text, numbers, or access the Find tool.

Alt + H
Microsoft Excel

Open Insert Tab and Insert Items

Open the Insert tab in the ribbon to access PivotTables, charts, add-ins, Sparklines, pictures, shapes, and more.

Alt + N
Microsoft Excel

Open Formulas Tab and Insert Functions

Opens the Formulas tab in Excel, allowing you to insert functions, trace precedents/dependents, and customize calculations.

Alt + M
Microsoft Excel

Open Review Tab

Opens the Review tab in the ribbon, providing access to spelling check, notes, threaded comments, and sheet protection.

Alt + R
Microsoft Excel

Open View Tab and Toggle Page Breaks, Gridlines, Headings

Open the View tab in the ribbon to preview page breaks and layouts, and toggle gridlines and headings on or off.

Alt + W
Microsoft Excel

Select the active tab on the ribbon and activate the access keys

Press Alt to move focus to the ribbon and display key tips for ribbon tabs and commands.

Alt
Microsoft Excel

Navigate Between Tabs with Access Keys or Arrow Keys

Press F10 to activate the ribbon, then use arrow keys to move between tabs.

F10
Microsoft Excel

Move focus to ribbon or add-in pane

Press Tab to move the focus to commands on the ribbon or add-in pane in Microsoft Excel.

Tab
Microsoft Excel

Move focus to ribbon or add-in pane

Move the focus to commands on the ribbon or add-in pane.

Shift + Tab
Microsoft Excel

Navigate ribbon items with arrow keys

Use the arrow keys to move focus between items on the ribbon in Microsoft Excel.

Arrow keys
Microsoft Excel

Show ribbon element tooltip

Displays a tooltip for the currently focused ribbon element in Microsoft Excel.

Ctrl + Shift + F10
Microsoft Excel

Activate Selected Button

Press Space to activate the currently selected button or control in a dialog, menu, or ribbon.

Space
Microsoft Excel

Activate a selected button

Press Enter to activate the currently selected button or command in a dialog box, ribbon, or other interface.

Enter
Microsoft Excel

Open list for selected command

Opens a dropdown list or menu for the currently selected command in Excel.

Microsoft Excel

Open menu for selected button

Opens the dropdown menu or list associated with the currently selected button in the Ribbon or dialog.

Alt +
Microsoft Excel

Expand or collapse the ribbon

Toggle the ribbon between expanded and collapsed states to show or hide command tabs and groups.

Ctrl + F1
Microsoft Excel

Move to submenu

When a main menu is open or selected, press ← to move to its submenu.

Microsoft Excel

Move Left Between Groups of Controls

Move the focus from one group of controls to the previous group in a dialog or form.

Ctrl +
Microsoft Excel

Move to next group of controls

Move focus from one group of controls to the next group to the right.

Ctrl +
Microsoft Excel

Move one cell up

Move the active cell up by one row in the worksheet.

Microsoft Excel

Move one cell right

Moves the active cell one column to the right within the current worksheet.

Microsoft Excel

Move to edge of data region

Ctrl+Arrow moves the active cell to the edge of the current data region (the last non-empty cell in that direction).

Ctrl + Arrow
Microsoft Excel

Move to next nonblank cell in End mode

Press End then Arrow key to enter End mode and jump to the next nonblank cell in the same column or row. If cells are blank, moves to the last cell in the row or column. End mode turns off after the move.

End , Arrow