Shortcuts
Keyboard shortcuts and workflow moves that save time across all applications.
Find Shortcuts by Category
Browse shortcuts by common task area.
Shortcut Finder
Business ProcessSearch by action, app, or platform to find the shortcut you need faster.
Borders
Add remove and style cell and table borders quickly.
| Shortcut | Windows | Mac | App |
|---|---|---|---|
| Apply All Inside Borders |
AltHBA |
Not Available |
Excel
▼
|
| Apply Bottom Border |
AltHBO |
Not Available |
Excel
▼
|
| Apply Double Bottom Border |
AltHBB |
Not Available |
Excel
▼
|
| Apply Left Border |
AltHBL |
Not Available |
Excel
▼
|
| Apply Outline Border |
CtrlShift& |
CmdShift& |
Excel
▼
|
| Apply Right Border |
AltHBR |
Not Available |
Excel
▼
|
| Apply Thick Outside Border |
AltHBT |
Not Available |
Excel
▼
|
| Apply Top Border |
AltHBP |
Not Available |
Excel
▼
|
| Open Borders Menu |
AltHB |
Not Available |
Excel
▼
|
| Remove All Borders |
CtrlShift_ |
CmdShift_ |
Excel
▼
|
Charts
Create, edit, and format charts and visual data elements.
| Shortcut | Windows | Mac | App |
|---|---|---|---|
| Copy Chart as Image |
CtrlC |
CmdC |
Excel
▼
|
| Create Chart on New Sheet |
F11 |
FnF11 |
Excel
▼
|
| Create Embedded Chart |
AltF1 |
FnAltF1 |
Excel
▼
|
| Format Chart Element |
Ctrl1 |
Cmd1 |
Excel
▼
|
| Insert Chart in Google Slides |
Not Available |
Not Available |
Excel
▼
|
| Move Chart |
Arrow Keys |
Arrow Keys |
Excel
▼
|
| Resize Chart |
ShiftArrow Keys |
ShiftArrow Keys |
Excel
▼
|
| Select Chart Elements |
Arrow Keys |
Arrow Keys |
Excel
▼
|
| Select Next Chart Element |
Tab |
Tab |
Excel
▼
|
| Select Previous Chart Element |
ShiftTab |
ShiftTab |
Excel
▼
|
Collaboration
Share, comment, co-author, and communicate within documents and apps.
| Shortcut | Windows | Mac | App |
|---|---|---|---|
| Accept Incoming Call |
Not Available |
Not Available |
Excel
▼
|
| Decline Incoming Call |
Not Available |
Not Available |
Excel
▼
|
| End Current Call |
Not Available |
Not Available |
Excel
▼
|
| Go to Calendar in Teams |
Not Available |
Not Available |
Excel
▼
|
| Go to Chat |
Not Available |
Not Available |
Excel
▼
|
| Go to Teams Section |
Not Available |
Not Available |
Excel
▼
|
| Mute or Unmute Microphone |
Not Available |
Not Available |
Excel
▼
|
| Open Activity Feed |
Not Available |
Not Available |
Excel
▼
|
| Open Search in Teams |
Not Available |
Not Available |
Excel
▼
|
| Raise or Lower Hand |
Not Available |
Not Available |
Excel
▼
|
| Share Document |
AltZS |
Not Available |
Excel
▼
|
| Start a New Chat |
Not Available |
Not Available |
Excel
▼
|
| Toggle Incoming Video |
Not Available |
Not Available |
Excel
▼
|
| Turn Camera On or Off |
Not Available |
Not Available |
Excel
▼
|
Current Cell Actions
Shortcuts that act on the currently active or selected cell.
| Shortcut | Windows | Mac | App |
|---|---|---|---|
| Add Strikethrough to Cell |
Ctrl5 |
CmdShiftX |
Excel
▼
|
| Apply Cell Style Comma Format |
AltHK |
Not Available |
Excel
▼
|
| Apply Cell Style Currency Format |
AltHAN |
Not Available |
Excel
▼
|
| Apply Cell Style Percent Format |
AltHP |
Not Available |
Excel
▼
|
| Clear Cell Contents and Formatting |
AltHEA |
Not Available |
Excel
▼
|
| Delete Cell Contents |
Delete |
Delete |
Excel
▼
|
| Edit Active Cell |
F2 |
FnF2 |
Excel
▼
|
| Insert Current Date into Cell |
Ctrl; |
Ctrl; |
Excel
▼
|
| Insert Current Time into Cell |
CtrlShift; |
CtrlShift; |
Excel
▼
|
| Open Cell Format Dialog |
Ctrl1 |
Cmd1 |
Excel
▼
|
| Select Current Array |
CtrlShift/ |
CtrlShift/ |
Excel
▼
|
| Toggle Cell Lock Reference |
F4 |
FnF4 |
Excel
▼
|
Data
Import, sort, filter, validate, and manage data sources.
| Shortcut | Windows | Mac | App |
|---|---|---|---|
| AutoFit Column Width |
AltHOI |
Not Available |
Excel
▼
|
| AutoFit Row Height |
AltHOA |
Not Available |
Excel
▼
|
| Collapse Grouped Rows or Columns |
AltAH |
CmdShiftJ |
Excel
▼
|
| Delete Columns |
Ctrl- |
Cmd- |
Excel
▼
|
| Delete Rows |
Ctrl- |
Cmd- |
Excel
▼
|
| Expand Grouped Rows or Columns |
AltAJ |
CmdShiftK |
Excel
▼
|
| Group Rows or Columns |
AltShiftRight Arrow |
CmdShiftK |
Excel
▼
|
| Hide Columns |
Ctrl |
Cmd |
Excel
▼
|
| Hide Rows |
Ctrl9 |
Cmd9 |
Excel
▼
|
| Insert Columns |
CtrlShift |
CmdShift |
Excel
▼
|
| Insert Rows |
CtrlShift |
CmdShift |
Excel
▼
|
| Open Data Validation Dialog |
AltAVV |
Not Available |
Excel
▼
|
| Open Sort Dialog |
AltASS |
Not Available |
Excel
▼
|
| Sort Ascending |
AltASA |
Not Available |
Excel
▼
|
| Sort Descending |
AltASD |
Not Available |
Excel
▼
|
| Ungroup Rows or Columns |
AltShiftLeft Arrow |
CmdShiftJ |
Excel
▼
|
| Unhide Columns |
CtrlShift |
CmdShift |
Excel
▼
|
| Unhide Rows |
CtrlShift9 |
CmdShift9 |
Excel
▼
|
Editing
Copy, paste, cut, undo, redo, delete, and modify content.
| Shortcut | Windows | Mac | App |
|---|---|---|---|
| Copy |
CtrlC |
CmdC |
Excel
▼
|
| Cut |
CtrlX |
CmdX |
Excel
▼
|
| Delete Selected Content |
Delete |
Delete |
Excel
▼
|
| Delete Word to the Left |
CtrlBackspace |
CmdDelete |
Excel
▼
|
| Delete Word to the Right |
Not Available |
Not Available |
Excel
▼
|
| Insert Hyperlink |
CtrlK |
CmdK |
Excel
▼
|
| Paste |
CtrlV |
CmdV |
Excel
▼
|
| Paste Special |
CtrlAltV |
CmdCtrlV |
Excel
▼
|
| Paste Values Only |
CtrlShiftV |
CmdShiftV |
Excel
▼
|
| Paste Without Formatting |
Not Available |
Not Available |
Excel
▼
|
| Redo |
CtrlY |
CmdY |
Excel
▼
|
| Repeat Last Action |
F4 |
CmdY |
Excel
▼
|
| Select All |
CtrlA |
CmdA |
Excel
▼
|
| Undo |
CtrlZ |
CmdZ |
Excel
▼
|
Editing Inside a Cell
Shortcuts for editing content while inside an active cell or text field.
| Shortcut | Windows | Mac | App |
|---|---|---|---|
| Cancel Cell Edit |
Escape |
Escape |
Excel
▼
|
| Confirm Cell Edit |
Enter |
Return |
Excel
▼
|
| Delete Character to the Left |
Backspace |
Delete |
Excel
▼
|
| Delete Character to the Right |
Delete |
FnDelete |
Excel
▼
|
| Delete Word to the Left Inside Cell |
CtrlBackspace |
CmdDelete |
Excel
▼
|
| Move Cursor One Word Left Inside Cell |
CtrlLeft Arrow |
AltLeft Arrow |
Excel
▼
|
| Move Cursor One Word Right Inside Cell |
CtrlRight Arrow |
AltRight Arrow |
Excel
▼
|
| Move Cursor to Beginning of Cell |
Home |
Home |
Excel
▼
|
| Move Cursor to End of Cell |
End |
End |
Excel
▼
|
| Select All Text Inside Cell |
CtrlA |
CmdA |
Excel
▼
|
| Start New Line Inside Cell |
AltEnter |
CtrlAltEnter |
Excel
▼
|
| Toggle Insert and Overtype Mode |
Insert |
Insert |
Excel
▼
|
Entering Data
Shortcuts for inputting confirming and cancelling data entry.
| Shortcut | Windows | Mac | App |
|---|---|---|---|
| AutoFill Flash Fill |
CtrlE |
CmdE |
Excel
▼
|
| Cancel Entry |
Escape |
Escape |
Excel
▼
|
| Confirm Entry and Move Down |
Enter |
Return |
Excel
▼
|
| Confirm Entry and Move Right |
Tab |
Tab |
Excel
▼
|
| Confirm Entry and Stay in Cell |
CtrlEnter |
CtrlReturn |
Excel
▼
|
| Copy Formula from Cell Above |
Ctrl' |
Ctrl' |
Excel
▼
|
| Copy Value from Cell Above |
CtrlD |
CmdD |
Excel
▼
|
| Fill Selected Cells with Same Entry |
CtrlEnter |
CtrlReturn |
Excel
▼
|
| Insert Current Date |
Ctrl; |
Ctrl; |
Excel
▼
|
| Insert Current Time |
CtrlShift; |
CtrlShift; |
Excel
▼
|
| Insert Line Break Without Paragraph |
Not Available |
Not Available |
Excel
▼
|
| Insert Page Break |
CtrlEnter |
CmdReturn |
Excel
▼
|
| Insert Paragraph Break |
Not Available |
Not Available |
Excel
▼
|
| Send Message or Post |
Not Available |
Not Available |
Excel
▼
|
| Start New Line in Same Cell |
AltEnter |
CtrlAltEnter |
Excel
▼
|
Extend Selection
Extend the current selection using keyboard modifiers and shift keys.
| Shortcut | Windows | Mac | App |
|---|---|---|---|
| Add to Selection with Extend Mode |
ShiftF8 |
ShiftFnF8 |
Excel
▼
|
| Extend Selection One Cell Down |
ShiftDown Arrow |
ShiftDown Arrow |
Excel
▼
|
| Extend Selection One Cell Left |
ShiftLeft Arrow |
ShiftLeft Arrow |
Excel
▼
|
| Extend Selection One Cell Right |
ShiftRight Arrow |
ShiftRight Arrow |
Excel
▼
|
| Extend Selection One Cell Up |
ShiftUp Arrow |
ShiftUp Arrow |
Excel
▼
|
| Extend Selection One Screen Down |
ShiftPage Down |
ShiftPage Down |
Excel
▼
|
| Extend Selection One Screen Up |
ShiftPage Up |
ShiftPage Up |
Excel
▼
|
| Extend Selection to Beginning of Row |
ShiftHome |
ShiftHome |
Excel
▼
|
| Extend Selection to End of Row |
ShiftEnd |
ShiftEnd |
Excel
▼
|
| Extend Selection to First Cell of Document |
CtrlShiftHome |
CmdShiftHome |
Excel
▼
|
| Extend Selection to Last Cell Down |
CtrlShiftDown Arrow |
CmdShiftDown Arrow |
Excel
▼
|
| Extend Selection to Last Cell Left |
CtrlShiftLeft Arrow |
CmdShiftLeft Arrow |
Excel
▼
|
| Extend Selection to Last Cell of Document |
CtrlShiftEnd |
CmdShiftEnd |
Excel
▼
|
| Extend Selection to Last Cell Right |
CtrlShiftRight Arrow |
CmdShiftRight Arrow |
Excel
▼
|
| Extend Selection to Last Cell Up |
CtrlShiftUp Arrow |
CmdShiftUp Arrow |
Excel
▼
|
| Toggle Extend Selection Mode |
F8 |
FnF8 |
Excel
▼
|
File
Create, open, save, print, and close files or documents.
| Shortcut | Windows | Mac | App |
|---|---|---|---|
| Close Application |
AltF4 |
CmdQ |
Excel
▼
|
| Close File |
CtrlW |
CmdW |
Excel
▼
|
| Export File |
AltFE |
Not Available |
Excel
▼
|
| New File |
CtrlN |
CmdN |
Excel
▼
|
| Open Account Settings |
AltFD |
Not Available |
Excel
▼
|
| Open File |
CtrlO |
CmdO |
Excel
▼
|
| Open File Properties |
Not Available |
Not Available |
Excel
▼
|
| Open Print Preview |
CtrlF2 |
CmdP |
Excel
▼
|
| Open Recent Files |
CtrlO |
CmdO |
Excel
▼
|
| Print File |
CtrlP |
CmdP |
Excel
▼
|
| Save As |
F12 |
CmdShiftS |
Excel
▼
|
| Save File |
CtrlS |
CmdS |
Excel
▼
|
| Share File |
AltZS |
Not Available |
Excel
▼
|
Find and Replace
Search for content replace values and navigate to specific locations.
| Shortcut | Windows | Mac | App |
|---|---|---|---|
| Close Find Bar |
Escape |
Escape |
Excel
▼
|
| Find Next Match |
ShiftF4 |
CmdG |
Excel
▼
|
| Find Previous Match |
CtrlShiftF4 |
CmdShiftG |
Excel
▼
|
| Go To Cell or Location |
CtrlG |
CmdG |
Excel
▼
|
| Open Find |
CtrlF |
CmdF |
Excel
▼
|
| Open Find and Replace |
CtrlH |
CmdH |
Excel
▼
|
| Open Go To Special |
CtrlG |
CmdG |
Excel
▼
|
| Search Within Sheet |
CtrlF |
CmdF |
Excel
▼
|
Formatting
Apply text, number, layout, and style formatting to content.
| Shortcut | Windows | Mac | App |
|---|---|---|---|
| Align Text Centre |
CtrlE |
CmdE |
Excel
▼
|
| Align Text Left |
CtrlL |
CmdL |
Excel
▼
|
| Align Text Right |
CtrlR |
CmdR |
Excel
▼
|
| Apply Heading 1 Style |
Not Available |
Not Available |
Excel
▼
|
| Apply Heading 2 Style |
Not Available |
Not Available |
Excel
▼
|
| Apply Heading 3 Style |
Not Available |
Not Available |
Excel
▼
|
| Apply Normal Style |
Not Available |
Not Available |
Excel
▼
|
| Bold Text |
CtrlB |
CmdB |
Excel
▼
|
| Clear All Formatting |
Not Available |
Not Available |
Excel
▼
|
| Copy Formatting |
Not Available |
Not Available |
Excel
▼
|
| Decrease Font Size |
CtrlShift< |
CmdShift< |
Excel
▼
|
| Decrease Indent |
Not Available |
Not Available |
Excel
▼
|
| Double Underline |
CtrlShiftD |
CmdShiftD |
Excel
▼
|
| Increase Font Size |
CtrlShift> |
CmdShift> |
Excel
▼
|
| Indent Text |
Not Available |
Not Available |
Excel
▼
|
| Italic Text |
CtrlI |
CmdI |
Excel
▼
|
| Justify Text |
Not Available |
Not Available |
Excel
▼
|
| Line Spacing Double |
Not Available |
Not Available |
Excel
▼
|
| Line Spacing Single |
Not Available |
Not Available |
Excel
▼
|
| Open Format Cells Dialog |
Ctrl1 |
Cmd1 |
Excel
▼
|
| Paste Formatting |
Not Available |
Not Available |
Excel
▼
|
| Strikethrough Text |
Ctrl5 |
CmdShiftX |
Excel
▼
|
| Subscript Text |
Ctrl= |
Cmd= |
Excel
▼
|
| Superscript Text |
CtrlShift= |
CmdShift= |
Excel
▼
|
| Underline Text |
CtrlU |
CmdU |
Excel
▼
|
Formulas
Insert, edit, and manage formulas and calculations (mainly Excel/Sheets).
| Shortcut | Windows | Mac | App |
|---|---|---|---|
| Accept Autocomplete Suggestion |
Tab |
Tab |
Excel
▼
|
| Array Formula Entry |
CtrlShiftEnter |
CtrlShiftEnter |
Excel
▼
|
| AutoSum |
Alt= |
CmdShiftT |
Excel
▼
|
| Calculate Active Sheet Only |
ShiftF9 |
ShiftFnF9 |
Excel
▼
|
| Calculate All Open Workbooks |
F9 |
FnF9 |
Excel
▼
|
| Copy Formula Down |
CtrlD |
CmdD |
Excel
▼
|
| Copy Formula Right |
CtrlR |
CmdR |
Excel
▼
|
| Evaluate Part of a Formula |
F9 |
FnF9 |
Excel
▼
|
| Expand or Collapse Formula Bar |
CtrlShiftU |
CtrlShiftU |
Excel
▼
|
| Insert Function Dialog |
ShiftF3 |
ShiftF3 |
Excel
▼
|
| Name a Cell or Range |
CtrlF3 |
CmdF3 |
Excel
▼
|
| Open Function Arguments Dialog |
CtrlShiftA |
CtrlShiftA |
Excel
▼
|
| Remove All Tracer Arrows |
AltMAA |
Not Available |
Excel
▼
|
| Start a Formula |
= |
= |
Excel
▼
|
| Toggle Absolute and Relative Reference |
F4 |
CmdT |
Excel
▼
|
| Toggle Show Formulas |
Ctrl` |
Cmd` |
Excel
▼
|
| Trace Dependents |
AltMD |
Not Available |
Excel
▼
|
| Trace Precedents |
AltMP |
Not Available |
Excel
▼
|
General
Common shortcuts that apply across multiple apps and actions.
| Shortcut | Windows | Mac | App |
|---|---|---|---|
| Check Spelling |
F7 |
FnF7 |
Excel
▼
|
| Insert Comment |
ShiftF2 |
CmdShiftF2 |
Excel
▼
|
| Insert Special Symbol or Character |
Not Available |
Not Available |
Excel
▼
|
| Minimize Window |
WindowsDown Arrow |
CmdM |
Excel
▼
|
| Open App Options or Preferences |
AltFT |
Cmd |
Excel
▼
|
| Open Context Menu |
ShiftF10 |
ShiftF10 |
Excel
▼
|
| Open Help |
F1 |
Cmd/ |
Excel
▼
|
| Open Keyboard Shortcuts List |
Not Available |
Not Available |
Excel
▼
|
| Open Search or Command Bar |
Alt/ |
Alt/ |
Excel
▼
|
| Open Tell Me or Search Menus |
AltQ |
AltQ |
Excel
▼
|
| Toggle Full Screen |
AltVU |
CtrlCmdF |
Excel
▼
|
| Zoom In |
CtrlAlt= |
Cmd= |
Excel
▼
|
| Zoom Out |
CtrlAlt- |
Cmd- |
Excel
▼
|
Mail and Calendar
Compose reply forward flag and navigate emails and calendar events in Outlook.
| Shortcut | Windows | Mac | App |
|---|---|---|---|
| Compose New Email |
Not Available |
Not Available |
Excel
▼
|
| Create New Calendar Event |
Not Available |
Not Available |
Excel
▼
|
| Create New Meeting Request |
Not Available |
Not Available |
Excel
▼
|
| Delete Email |
Not Available |
Not Available |
Excel
▼
|
| Flag Email for Follow Up |
Not Available |
Not Available |
Excel
▼
|
| Forward Email |
Not Available |
Not Available |
Excel
▼
|
| Mark Email as Read |
Not Available |
Not Available |
Excel
▼
|
| Mark Email as Unread |
Not Available |
Not Available |
Excel
▼
|
| Move Email to Folder |
Not Available |
Not Available |
Excel
▼
|
| Move to Next Email |
Not Available |
Not Available |
Excel
▼
|
| Move to Previous Email |
Not Available |
Not Available |
Excel
▼
|
| Open Selected Email |
Not Available |
Not Available |
Excel
▼
|
| Reply All to Email |
Not Available |
Not Available |
Excel
▼
|
| Reply to Email |
Not Available |
Not Available |
Excel
▼
|
| Search Emails |
Not Available |
Not Available |
Excel
▼
|
| Send Email |
Not Available |
Not Available |
Excel
▼
|
| Switch to Calendar View |
Not Available |
Not Available |
Excel
▼
|
| Switch to Contacts View |
Not Available |
Not Available |
Excel
▼
|
| Switch to Mail View |
Not Available |
Not Available |
Excel
▼
|
| Switch to Tasks View |
Not Available |
Not Available |
Excel
▼
|
Number Formatting
Apply number currency date percentage and custom formats to cells.
| Shortcut | Windows | Mac | App |
|---|---|---|---|
| Apply Accounting Format |
AltHAN |
Not Available |
Excel
▼
|
| Apply Currency Format |
CtrlShift4 |
CmdShift4 |
Excel
▼
|
| Apply Date Format |
CtrlShift3 |
CmdShift3 |
Excel
▼
|
| Apply General Number Format |
CtrlShift~ |
CmdShift~ |
Excel
▼
|
| Apply Number Format with Two Decimals |
CtrlShift1 |
CmdShift1 |
Excel
▼
|
| Apply Percentage Format |
CtrlShift5 |
CmdShift5 |
Excel
▼
|
| Apply Scientific Notation Format |
CtrlShift6 |
CmdShift6 |
Excel
▼
|
| Apply Time Format |
CtrlShift2 |
CmdShift2 |
Excel
▼
|
| Decrease Decimal Places |
AltH9 |
Not Available |
Excel
▼
|
| Increase Decimal Places |
AltH |
Not Available |
Excel
▼
|
| Open Format Cells Number Tab |
Ctrl1 |
Cmd1 |
Excel
▼
|
Others
Shortcuts that act on the currently active or selected cell.
| Shortcut | Windows | Mac | App |
|---|---|---|---|
| Accessibility Checker |
Not Available |
Not Available |
Excel
▼
|
| Bring Object to Front |
AltHGRF |
Not Available |
Excel
▼
|
| Group Objects |
CtrlG |
CmdG |
Excel
▼
|
| Insert Hyperlink |
CtrlK |
CmdK |
Excel
▼
|
| Insert Image |
AltNP |
Not Available |
Excel
▼
|
| Insert Shape |
AltNSH |
Not Available |
Excel
▼
|
| Open Macro Dialog |
AltF8 |
AltFnF8 |
Excel
▼
|
| Open Version History |
Not Available |
Not Available |
Excel
▼
|
| Open Visual Basic Editor |
AltF11 |
AltFnF11 |
Excel
▼
|
| Page Setup Dialog |
AltPSP |
Not Available |
Excel
▼
|
| Print Preview |
CtrlF2 |
CmdP |
Excel
▼
|
| Record Macro |
AltTMR |
Not Available |
Excel
▼
|
| Send Object to Back |
AltHGRK |
Not Available |
Excel
▼
|
| Translate Document or Selection |
Not Available |
Not Available |
Excel
▼
|
| Ungroup Objects |
CtrlShiftG |
CmdShiftG |
Excel
▼
|
Pivot Tables
Create, modify, and analyze PivotTables and summarized data.
| Shortcut | Windows | Mac | App |
|---|---|---|---|
| Collapse PivotTable Field |
AltShift- |
AltShift- |
Excel
▼
|
| Expand PivotTable Field |
AltShift |
AltShift |
Excel
▼
|
| Group PivotTable Items |
AltJTG |
Not Available |
Excel
▼
|
| Insert PivotTable |
AltNV |
Not Available |
Excel
▼
|
| Move to Next PivotTable Field |
Tab |
Tab |
Excel
▼
|
| Move to Previous PivotTable Field |
ShiftTab |
ShiftTab |
Excel
▼
|
| Open PivotTable Field List |
AltJTL |
Not Available |
Excel
▼
|
| Open PivotTable Options |
AltJTT |
Not Available |
Excel
▼
|
| Refresh All PivotTables |
CtrlAltF5 |
CtrlAltF5 |
Excel
▼
|
| Refresh PivotTable |
AltF5 |
CmdAltF5 |
Excel
▼
|
| Select Entire PivotTable |
CtrlA |
CmdA |
Excel
▼
|
| Ungroup PivotTable Items |
AltJTU |
Not Available |
Excel
▼
|
Review
Spell check, comments, tracking changes, and document review tools.
| Shortcut | Windows | Mac | App |
|---|---|---|---|
| Accept Tracked Change |
Not Available |
Not Available |
Excel
▼
|
| Check Spelling and Grammar |
F7 |
FnF7 |
Excel
▼
|
| Delete Comment |
AltRD |
Not Available |
Excel
▼
|
| Edit Comment |
ShiftF2 |
CmdShiftF2 |
Excel
▼
|
| Insert Comment |
ShiftF2 |
CmdShiftF2 |
Excel
▼
|
| Navigate to Next Comment |
AltRN |
Not Available |
Excel
▼
|
| Navigate to Previous Comment |
AltRP |
Not Available |
Excel
▼
|
| Open Thesaurus |
Not Available |
Not Available |
Excel
▼
|
| Reject Tracked Change |
Not Available |
Not Available |
Excel
▼
|
| Show or Hide Comments |
AltRAH |
Not Available |
Excel
▼
|
| Track Changes Toggle |
Not Available |
Not Available |
Excel
▼
|
| Word Count |
Not Available |
Not Available |
Excel
▼
|
Ribbon
Navigate and control the application ribbon and menu commands.
| Shortcut | Windows | Mac | App |
|---|---|---|---|
| Activate or Open Selected Control |
Space |
Space |
Excel
▼
|
| Activate Ribbon Access Keys |
Alt |
Alt |
Excel
▼
|
| Confirm Ribbon Control Change |
Enter |
Return |
Excel
▼
|
| Expand or Collapse Ribbon |
CtrlF1 |
CmdAltR |
Excel
▼
|
| Get Help on Selected Control |
F1 |
FnF1 |
Excel
▼
|
| Go to Data Tab |
AltA |
AltA |
Excel
▼
|
| Go to Formulas Tab |
AltM |
AltM |
Excel
▼
|
| Go to Home Tab |
AltH |
AltH |
Excel
▼
|
| Go to Insert Tab |
AltN |
AltN |
Excel
▼
|
| Go to Page Layout Tab |
AltP |
AltP |
Excel
▼
|
| Go to Review Tab |
AltR |
AltR |
Excel
▼
|
| Go to View Tab |
AltW |
AltW |
Excel
▼
|
| Move to Next Ribbon Tab |
Tab |
Tab |
Excel
▼
|
| Move to Previous Ribbon Tab |
ShiftTab |
ShiftTab |
Excel
▼
|
Selection
Select cells, text, rows, columns, or objects efficiently.
| Shortcut | Windows | Mac | App |
|---|---|---|---|
| Add to Selection with Mouse |
CtrlClick |
CmdClick |
Excel
▼
|
| Extend Selection One Cell Down |
ShiftDown Arrow |
ShiftDown Arrow |
Excel
▼
|
| Extend Selection One Cell Left |
ShiftLeft Arrow |
ShiftLeft Arrow |
Excel
▼
|
| Extend Selection One Cell Right |
ShiftRight Arrow |
ShiftRight Arrow |
Excel
▼
|
| Extend Selection One Cell Up |
ShiftUp Arrow |
ShiftUp Arrow |
Excel
▼
|
| Extend Selection to Beginning of Document |
CtrlShiftHome |
CmdShiftHome |
Excel
▼
|
| Extend Selection to End of Document |
CtrlShiftEnd |
CmdShiftEnd |
Excel
▼
|
| Extend Selection to Last Used Cell Down |
CtrlShiftDown Arrow |
CmdShiftDown Arrow |
Excel
▼
|
| Extend Selection to Last Used Cell Left |
CtrlShiftLeft Arrow |
CmdShiftLeft Arrow |
Excel
▼
|
| Extend Selection to Last Used Cell Right |
CtrlShiftRight Arrow |
CmdShiftRight Arrow |
Excel
▼
|
| Extend Selection to Last Used Cell Up |
CtrlShiftUp Arrow |
CmdShiftUp Arrow |
Excel
▼
|
| Select All |
CtrlA |
CmdA |
Excel
▼
|
| Select All Objects on Slide |
CtrlA |
CmdA |
Excel
▼
|
| Select Current Region |
CtrlShift* |
CmdShift* |
Excel
▼
|
| Select Entire Column |
CtrlSpace |
CtrlSpace |
Excel
▼
|
| Select Entire Row |
ShiftSpace |
ShiftSpace |
Excel
▼
|
| Select One Screen Down |
ShiftPage Down |
ShiftFnDown Arrow |
Excel
▼
|
| Select One Screen Up |
ShiftPage Up |
ShiftFnUp Arrow |
Excel
▼
|
| Select One Word Left |
Not Available |
Not Available |
Excel
▼
|
| Select One Word Right |
Not Available |
Not Available |
Excel
▼
|
| Select to Beginning of Line |
ShiftHome |
CmdShiftLeft Arrow |
Excel
▼
|
| Select to End of Line |
ShiftEnd |
CmdShiftRight Arrow |
Excel
▼
|
| Select Visible Cells Only |
Alt; |
CmdShiftZ |
Excel
▼
|
Slides and Presenting
Start end navigate and control slideshows during a live presentation.
| Shortcut | Windows | Mac | App |
|---|---|---|---|
| Black Screen During Presentation |
Not Available |
Not Available |
Excel
▼
|
| Duplicate Current Slide |
Not Available |
Not Available |
Excel
▼
|
| End Slideshow |
Not Available |
Not Available |
Excel
▼
|
| Erase Pen Annotations |
Not Available |
Not Available |
Excel
▼
|
| Go to Next Slide During Show |
Not Available |
Not Available |
Excel
▼
|
| Go to Previous Slide During Show |
Not Available |
Not Available |
Excel
▼
|
| Hide or Unhide Slide |
Not Available |
Not Available |
Excel
▼
|
| Insert New Slide in Presentation |
Not Available |
Not Available |
Excel
▼
|
| Jump to Specific Slide Number |
Not Available |
Not Available |
Excel
▼
|
| Open Presenter View |
Not Available |
Not Available |
Excel
▼
|
| Show or Hide Pointer During Show |
Not Available |
Not Available |
Excel
▼
|
| Start Slideshow from Beginning |
Not Available |
Not Available |
Excel
▼
|
| Start Slideshow from Current Slide |
Not Available |
Not Available |
Excel
▼
|
| Switch to Laser Pointer |
Not Available |
Not Available |
Excel
▼
|
| Toggle Pen Tool During Slideshow |
Not Available |
Not Available |
Excel
▼
|
| Toggle Subtitles During Presentation |
Not Available |
Not Available |
Excel
▼
|
| White Screen During Presentation |
Not Available |
Not Available |
Excel
▼
|
| Zoom Into Slide During Show |
Not Available |
Not Available |
Excel
▼
|
Smart Selection
Select non-contiguous cells blanks constants formulas and special ranges.
| Shortcut | Windows | Mac | App |
|---|---|---|---|
| Select All Dependent Cells |
CtrlShift] |
CtrlShift] |
Excel
▼
|
| Select All Precedent Cells |
CtrlShift[ |
CtrlShift[ |
Excel
▼
|
| Select Blank Cells in Range |
CtrlG then AltSK |
CtrlG then AltSK |
Excel
▼
|
| Select Cells with Conditional Formatting |
AltHFDT |
Not Available |
Excel
▼
|
| Select Cells with Constants |
AltHFDC |
Not Available |
Excel
▼
|
| Select Cells with Data Validation |
AltHFDV |
Not Available |
Excel
▼
|
| Select Cells with Formulas |
AltHFDF |
Not Available |
Excel
▼
|
| Select Current Region |
CtrlShift* |
CmdShift* |
Excel
▼
|
| Select Direct Dependent Cells |
Ctrl] |
Ctrl] |
Excel
▼
|
| Select Direct Precedent Cells |
Ctrl[ |
Ctrl[ |
Excel
▼
|
| Select Last Cell Used in Sheet |
CtrlEnd |
CmdEnd |
Excel
▼
|
| Select Visible Cells Only |
Alt; |
CmdShiftZ |
Excel
▼
|
Spelling and Proofing
Run spell check grammar tools thesaurus and proofing shortcuts.
| Shortcut | Windows | Mac | App |
|---|---|---|---|
| Accept AutoCorrect Suggestion |
Not Available |
Not Available |
Excel
▼
|
| Open Editor or Proofing Suggestions |
Not Available |
Not Available |
Excel
▼
|
| Open Research Pane |
Not Available |
Not Available |
Excel
▼
|
| Open Thesaurus |
Not Available |
Not Available |
Excel
▼
|
| Reject AutoCorrect Suggestion |
Not Available |
Not Available |
Excel
▼
|
| Run Spell Check |
F7 |
FnF7 |
Excel
▼
|
| Toggle Show Markup |
Not Available |
Not Available |
Excel
▼
|
| Word Count |
Not Available |
Not Available |
Excel
▼
|
Tables
Work with tables, structured data, and table formatting.
| Shortcut | Windows | Mac | App |
|---|---|---|---|
| Activate Filter Drop-Down |
AltDown Arrow |
AltDown Arrow |
Excel
▼
|
| Clear Slicer Filter |
AltC |
AltC |
Excel
▼
|
| Insert Row in Table |
Not Available |
Not Available |
Excel
▼
|
| Insert Table |
CtrlT |
CmdT |
Excel
▼
|
| Move to Next Cell in Table |
Not Available |
Not Available |
Excel
▼
|
| Move to Previous Cell in Table |
Not Available |
Not Available |
Excel
▼
|
| Select Entire Table |
CtrlA |
CmdA |
Excel
▼
|
| Select Table Column |
CtrlSpace |
CtrlSpace |
Excel
▼
|
| Select Table Row |
ShiftSpace |
ShiftSpace |
Excel
▼
|
| Select Table Row in Word |
Not Available |
Not Available |
Excel
▼
|
| Toggle AutoFilter |
CtrlShiftL |
CmdShiftF |
Excel
▼
|
| Toggle Table Total Row |
CtrlShiftT |
CtrlShiftT |
Excel
▼
|
View
Zoom, fullscreen, layout views, and display settings.
| Shortcut | Windows | Mac | App |
|---|---|---|---|
| Arrange All Windows |
AltWA |
Not Available |
Excel
▼
|
| Freeze First Column |
AltWFC |
Not Available |
Excel
▼
|
| Freeze Panes |
AltWFF |
Not Available |
Excel
▼
|
| Freeze Top Row |
AltWFR |
Not Available |
Excel
▼
|
| Open New Window |
AltWN |
Not Available |
Excel
▼
|
| Reset Zoom to 100 Percent |
AltWJ |
CmdShiftH |
Excel
▼
|
| Show Macros Dialog from View Tab |
AltWM |
Not Available |
Excel
▼
|
| Show or Hide Formula Bar |
AltWVF |
Not Available |
Excel
▼
|
| Show or Hide Gridlines |
AltWVG |
Not Available |
Excel
▼
|
| Show or Hide Headings |
AltWVH |
Not Available |
Excel
▼
|
| Show or Hide Ruler |
AltWR |
Not Available |
Excel
▼
|
| Split Window into Panes |
AltWS |
Not Available |
Excel
▼
|
| Switch to Draft View |
Not Available |
Not Available |
Excel
▼
|
| Switch to Normal View |
AltWL |
Not Available |
Excel
▼
|
| Switch to Notes Page View |
Not Available |
Not Available |
Excel
▼
|
| Switch to Outline View |
Not Available |
Not Available |
Excel
▼
|
| Switch to Page Break Preview |
AltWI |
Not Available |
Excel
▼
|
| Switch to Page Layout View |
AltWP |
Not Available |
Excel
▼
|
| Switch to Print Layout View |
Not Available |
Not Available |
Excel
▼
|
| Switch to Reading View |
Not Available |
Not Available |
Excel
▼
|
| Switch to Slide Sorter View |
Not Available |
Not Available |
Excel
▼
|
| Toggle Full Screen View |
AltVU |
CtrlCmdF |
Excel
▼
|
| Toggle Navigation Pane |
AltWK |
Not Available |
Excel
▼
|
| Unfreeze Panes |
AltWFF |
Not Available |
Excel
▼
|
| Zoom In |
AltWQ then Tab |
Cmd= |
Excel
▼
|
| Zoom Out |
AltWQ then Tab |
Cmd- |
Excel
▼
|
Workbook
Manage sheets, tabs, windows, and workbook-level actions.
| Shortcut | Windows | Mac | App |
|---|---|---|---|
| Create New Workbook |
CtrlN |
CmdN |
Excel
▼
|
| Delete Slide |
Delete |
Delete |
Excel
▼
|
| Duplicate Slide |
CtrlD |
CmdD |
Excel
▼
|
| Freeze Panes |
AltWFF |
Not Available |
Excel
▼
|
| Insert New Sheet |
ShiftF11 |
ShiftFnF11 |
Excel
▼
|
| Insert New Slide |
CtrlM |
CmdShiftN |
Excel
▼
|
| Maximize Current Workbook Window |
CtrlF10 |
CtrlFnF10 |
Excel
▼
|
| Minimize Current Workbook Window |
CtrlF9 |
CtrlFnF9 |
Excel
▼
|
| Move Slide Down |
AltShiftPage Down |
Not Available |
Excel
▼
|
| Move Slide Up |
AltShiftPage Up |
Not Available |
Excel
▼
|
| Move to Next Sheet Tab |
CtrlPage Down |
FnCtrlDown Arrow |
Excel
▼
|
| Move to Previous Sheet Tab |
CtrlPage Up |
FnCtrlUp Arrow |
Excel
▼
|
| Protect Sheet |
AltRPS |
Not Available |
Excel
▼
|
| Rename Sheet |
AltHOR |
Not Available |
Excel
▼
|
| Split Window |
AltWS |
Not Available |
Excel
▼
|
| Switch to Next Open Workbook |
CtrlTab |
Cmd` |
Excel
▼
|
| Switch to Previous Open Workbook |
CtrlShiftTab |
CmdShift` |
Excel
▼
|
zoom-and-view
| Shortcut | Windows | Mac | App |
|---|---|---|---|
| Freeze Panes |
AltWFF |
Not Available |
Excel
▼
|
| Full Screen Mode |
AltVU |
Not Available |
Excel
▼
|
| New Window |
AltWN |
Not Available |
Excel
▼
|
| Reset Zoom to 100 Percent |
CtrlAlt |
CmdShift |
Excel
▼
|
| Show or Hide Formula Bar |
CtrlShiftU |
CtrlShiftU |
Excel
▼
|
| Show or Hide Gridlines |
AltWVG |
Not Available |
Excel
▼
|
| Show or Hide Ruler |
AltWR |
Not Available |
Excel
▼
|
| Split View |
AltWS |
Not Available |
Excel
▼
|
| Switch Between Open Windows |
CtrlTab |
Cmd` |
Excel
▼
|
| Toggle Reading View |
AltWF |
Not Available |
Excel
▼
|
| Zoom In |
CtrlAlt= |
Cmd= |
Excel
▼
|
| Zoom Out |
CtrlAlt- |
Cmd- |
Excel
▼
|