Keyboard Shortcuts Reference

1,452 shortcuts for Windows and macOS across 8 apps — Excel, Word, PowerPoint, Power BI, Access, Sheets, Docs and Slides.

Move one cell right

Move one cell left

Move one cell down

Move one cell up

Move one cell in any direction

Move to the edge of the data region

Go to the start of the row

Go to cell A1

Go to the last used cell

Move one screen down

Move one screen up

Move one screen right

Move one screen left

Go to the next worksheet

Go to the previous worksheet

Open the Go To dialog

Jump to the Name Box

Scroll back to the active cell

Move inside a selection

Move clockwise to the next corner of a selection

Move between unlocked cells on a protected sheet

Toggle End mode navigation

–

Select the entire row

Select the entire column

Select the entire worksheet

Extend the selection by one cell

Extend the selection to the edge of data

Extend the selection to A1

Extend the selection to the last used cell

Extend the selection one screen down

Extend the selection one screen up

Extend the selection to the start of the row

Select the current region around the cell

Select visible cells only

Select cells that contain comments

Select cells that feed the active cell

Select all precedent cells

Select cells that use the active cell

Select all dependent cells

Select the array containing the active cell

Select cells in a row that differ

Turn Extend Selection mode on or off

Add another range to the selection

Shrink the selection to the active cell

Select the table body

Edit the active cell

Cancel the entry

Confirm the entry and stay in the cell

Fill the whole selection with the entry

Start a new line inside a cell

Delete the character to the left

Delete the character to the right

Delete to the end of the line

Clear the cell contents

Undo the last action

Redo the last action

Repeat the last action

Insert the current date

Insert the current time

Copy the value from the cell above

Copy the formula from the cell above

Flash Fill

Open the AutoComplete list

Open the Clear menu

–

Insert a symbol

–

Toggle overtype in the formula bar

–

Copy the selection

Cut the selection

Paste

Open Paste Special

Paste values only

Paste formats only

Paste formulas only

Paste transposed

Paste as a link

Paste column widths

Fill down from the cell above

Fill right from the cell to the left

Fill the selected range with the entry

Open the Fill Series dialog

–

Open the Office Clipboard

–

Copy the selection as a picture

–

Turn on the Format Painter

–

Insert cells, rows or columns

Delete cells, rows or columns

Insert a whole row

Insert a whole column

Hide the selected rows

Unhide rows

Hide the selected columns

Unhide columns

AutoFit the column width

–

AutoFit the row height

–

Set the column width

–

Set the row height

–

Move or copy the selection by dragging

Open the Format Cells dialog

Bold

Italic

Underline

Strikethrough

Open the Font tab of Format Cells

Apply an outline border

Remove all borders

Open the Style dialog

Copy formatting only

Clear the formatting

–

Grow the font size

Shrink the font size

Open Conditional Formatting

–

Open the Cell Styles gallery

–

Format as Table

–

Open the fill colour picker

–

Open the font colour picker

–

Apply the General format

Apply the Currency format

Apply the Percentage format

Apply the Scientific format

Apply the Date format

Apply the Time format

Apply the Number format with two decimals

Apply the Accounting format

–

Increase the decimal places

–

Decrease the decimal places

–

Apply the Comma style

–

Align left

Align centre

Align right

Align top

–

Align middle

–

Align bottom

–

Wrap text

–

Merge and centre

–

Unmerge cells

–

Increase the indent

–

Decrease the indent

–

Open the Orientation menu

–

Start a formula

Open the Insert Function dialog

AutoSum the selection

Open Function Arguments for a typed function

Insert the argument names into a formula

Cycle absolute and relative references

Show or hide all formulas

Calculate the active worksheet

Calculate all open workbooks

Force a full recalculation

Rebuild dependencies and recalculate

Evaluate part of a formula

Enter a legacy array formula

Expand or collapse the formula bar

Move the cursor into the formula bar

Paste a defined name into a formula

Trace precedents

–

Trace dependents

–

Remove all tracer arrows

–

Open Evaluate Formula

–

Run Error Checking

–

Open the Watch Window

–

Select the precedent cells

Select the dependent cells

Define a name

Create names from the selection

Paste a name into a formula

Jump to the Name Box

Open the Name Manager

–

Create a table

Insert a table without a header row

Turn AutoFilter on or off

Open the filter dropdown of a column

Clear all filters

–

Reapply the filter

Open the Sort dialog

–

Sort A to Z

–

Sort Z to A

–

Remove duplicates

–

Open Data Validation

–

Open Text to Columns

–

Refresh the current query

Refresh all queries

Open the data entry form

–

Open Goal Seek

–

Open the Scenario Manager

–

Insert a slicer

–

Insert a timeline

–

Toggle the total row of a table

Create a PivotTable

–

Open the legacy PivotTable wizard

–

Refresh the PivotTable

Refresh every PivotTable

Group the selected items

Ungroup the selected items

Show or hide the field list

–

Insert a calculated field

–

Expand the selected item

–

Collapse the selected item

–

Open field settings

–

Insert a PivotChart

–

Insert a chart on the current sheet

Create a chart on a new sheet

Open Recommended Charts

–

Insert a sparkline

–

Select the next chart element

Select the previous chart element

Select the next group of elements

Format the selected chart element

Move to the next floating object

Insert a shape

–

Insert a picture

–

Insert a text box

–

Insert an icon

–

Group the selected shapes

Nudge the selected shape

Duplicate the selected shape

Find

Replace

Find the next match

Find the previous match

Close Find and Replace

Open Go To

Open Go To Special

Select all blank cells

–

Select all cells with formulas

–

Select all constants

–

Create a new workbook

Open a workbook

Save

Save As

Save As on the Backstage view

Close the workbook

Quit the application

Print Preview

Open the File tab

–

Open the application options

Open the workbook properties

–

Open the recent files list

–

Share the workbook

–

Export as PDF

–

Insert a new worksheet

Insert a macro sheet

Rename the active sheet

–

Delete the active sheet

–

Move or copy the sheet

–

Set the tab colour

–

Hide the sheet

–

Unhide a sheet

–

Protect the sheet

–

Protect the workbook structure

–

Switch to the next workbook window

Switch to the previous workbook window

Minimise the workbook window

Maximise the workbook window

Open a new window on the same workbook

–

Arrange all windows

–

Freeze panes

–

Split the window

–

Show or hide gridlines

–

Collapse or expand the ribbon

Open the Zoom dialog

–

Zoom to the selection

–

Switch to Page Layout view

–

Switch to Normal view

–

Switch to Page Break Preview

–

Toggle full screen

Open the Page Setup dialog

–

Set the print area

–

Clear the print area

–

Insert a page break

–

Remove a page break

–

Set the print titles

–

Change the page orientation

–

Change the margins

–

Change the paper size

–

Insert or edit a note

Insert a threaded comment

Go to the next comment

–

Go to the previous comment

–

Show or hide all comments

–

Delete the comment

–

Run the spell checker

Open the thesaurus

Translate the selection

–

Run the accessibility checker

–

Group rows or columns

Ungroup rows or columns

Create an auto outline

–

Clear the outline

–

Show or hide outline symbols

Open the Subtotal dialog

–

Show the detail rows

–

Hide the detail rows

–

Open the Help pane

Edit the active cell

Paste a name

Repeat, or toggle reference type

Open Go To

Move between panes and the ribbon

Check the spelling

Turn on Extend mode

Calculate all open workbooks

Show the ribbon key tips

Create a chart sheet

Open Save As

Show the shortcut menu

Close the workbook window

Restore the window size

–

Go to the next workbook window

Move the window

–

Resize the window

–

Open the Visual Basic editor

Open the Macro dialog

Open the Home tab

–

Paste

–

Paste values

–

Cut

–

Copy

–

Format Painter

–

Change the font face

–

Change the font size

–

Bold

–

Italic

–

Underline

–

Open the Borders menu

–

Fill colour

–

Font colour

–

Wrap text

–

Merge and centre

–

Open the number format list

–

Conditional formatting

–

Format as table

–

Cell styles

–

Insert cells

–

Delete cells

–

Open the Format menu

–

AutoSum

–

Open the Fill menu

–

Open the Clear menu

–

Sort and filter

–

Find and select

–

Open the Insert tab

–

PivotTable

–

Recommended PivotTables

–

Table

–

Pictures

–

Shapes

–

Icons

–

SmartArt

–

Recommended charts

–

Column or bar chart

–

Line chart

–

Pie chart

–

PivotChart

–

Sparklines

–

Slicer

–

Hyperlink

–

Text box

–

Header and footer

–

Symbol

–

Equation

–

Open the Formulas tab

–

Insert function

–

AutoSum

–

Financial functions

–

Logical functions

–

Text functions

–

Date and time functions

–

Lookup and reference functions

–

Maths and trig functions

–

Name Manager

–

Define name

–

Use a name in a formula

–

Create names from the selection

–

Trace precedents

–

Trace dependents

–

Show formulas

–

Evaluate formula

–

Watch window

–

Calculation options

–

Calculate now

–

Calculate the sheet

–

Open the Data tab

–

Get data

–

From text or CSV

–

Refresh all

–

Queries and connections

–

Sort

–

Filter

–

Clear the filter

–

Advanced filter

–

Text to columns

–

Flash Fill

–

Remove duplicates

–

Data validation

–

Consolidate

–

What-If analysis

–

Forecast sheet

–

Group

–

Ungroup

–

Subtotal

–

Solver

–

Open the Review tab

–

Spelling

–

Thesaurus

–

Check accessibility

–

New comment

–

Show comments

–

Protect the sheet

–

Protect the workbook

–

Allow users to edit ranges

–

Open the View tab

–

Normal view

–

Page layout view

–

Page break preview

–

Zoom

–

Freeze panes

–

New window

–

Arrange all

–

Split

–

Hide the window

–

Switch windows

–

Macros

–

Open the Visual Basic editor

Open the Macro dialog

Record a macro

–

Insert a macro sheet

Run the current procedure in the editor

Step into a line in the editor

Step over a line in the editor

Toggle a breakpoint in the editor

Open the Immediate window

Open the Object Browser

Show the Properties window

Show the right-click menu

Show the ribbon key tips

–

Move focus to the ribbon

Search the Tell Me box

–

Open Help

Insert a hyperlink

Remove a hyperlink

–

Insert an emoji

Copy visible cells only

Cancel a long running operation

Switch calculation to manual

–

Create a new document

Open a document

Save

Save As

Close the document

Print Preview

Quit the application

Open the File tab

–

Open the application options

Export as PDF

–

Open Help

Search the Tell Me box

–

Move one character

Move one word right

Move one word left

Move to the start of the line

Move to the end of the line

Move one paragraph up

Move one paragraph down

Move one screen up

Move one screen down

Move to the top of the document

Move to the end of the document

Go back to the previous edit point

Go to a page, section or line

Move to the top of the next page

Move to the top of the previous page

Open the Navigation pane

Select the whole document

Extend the selection one character

Extend the selection one word

Select to the start of the line

Select to the end of the line

Select one paragraph up

Select one paragraph down

Select one screen up

Select one screen down

Select to the start of the document

Select to the end of the document

Turn on Extend Selection mode

Select a vertical block of text

Select a word

Select a sentence

Select a paragraph

Cancel the selection

Copy

Cut

Paste

Paste Special

Paste as plain text

Undo

Redo or repeat

Delete the word to the left

Delete the word to the right

Copy to the Spike

Paste the Spike contents

Duplicate the last formatting action

Open the Office Clipboard

–

Insert an AutoText entry

Toggle overtype mode

–

Bold

Italic

Underline

Underline words only

Double underline

Subscript

Superscript

Small caps

All caps

Change the case of letters

Hidden text

Grow the font size

Shrink the font size

Grow the font by one point

Shrink the font by one point

Open the Font dialog

Change the font face

Change the font size

Remove character formatting

Copy the formatting

Paste the formatting

Highlight the selection

–

Align left

Align centre

Align right

Justify

Single line spacing

Double line spacing

1.5 line spacing

Add or remove space before a paragraph

Increase the indent

Decrease the indent

Create a hanging indent

Reduce a hanging indent

Remove paragraph formatting

Open the Paragraph dialog

Move the paragraph up

Move the paragraph down

Show or hide formatting marks

Apply the Normal style

Apply Heading 1

Apply Heading 2

Apply Heading 3

Apply the List Bullet style

Open the Apply Styles pane

Open the Styles pane

Open the Style Inspector

–

Update the style to match the selection

–

Promote a heading level

Demote a heading level

Start a bulleted list

Start a numbered list

Demote a list item

Promote a list item

Apply bullets from the ribbon

–

Apply numbering from the ribbon

–

Apply a multilevel list

–

Switch to Outline view

–

Expand the outline heading

–

Collapse the outline heading

–

Show only the first line of each paragraph

–

Insert a table

–

Move to the next cell

Move to the previous cell

Move to the first cell in the row

Move to the last cell in the row

Move to the first cell in the column

Move to the last cell in the column

Add a new row at the end

Insert a tab inside a cell

Select the whole table

–

Select the current row

–

Insert a row above

–

Insert a row below

–

Delete a row

–

Merge the selected cells

–

Split the selected cell

–

Open Table Properties

–

Convert text to a table

–

Sort a table

–

Insert a hyperlink

Insert a page break

Insert a column break

Insert a line break

Insert a non-breaking space

Insert a non-breaking hyphen

Insert an optional hyphen

Insert an em dash

Insert an en dash

Insert a footnote

Insert an endnote

Insert a comment

Insert a field

Update a field

Toggle field codes

Unlink a field

Insert the date field

Insert the time field

Insert the page number field

Insert an equation

Insert a picture

–

Insert a shape

–

Insert a text box

–

Insert a symbol

–

Insert a caption

–

Insert a cross-reference

–

Mark a table of contents entry

–

Mark an index entry

–

Mark a citation

–

Find

Advanced Find

Replace

Go To

Repeat the last find

Browse to the next object

Close the pane or dialog

Turn Track Changes on or off

Insert a comment

Go to the next revision or comment

–

Go to the previous revision or comment

–

Accept the change

–

Reject the change

–

Open the Reviewing pane

–

Compare documents

–

Run the spell and grammar check

Open the thesaurus

Word count

Check accessibility

–

Restrict editing

–

Read Aloud

Open the Layout tab

–

Change the margins

–

Change the orientation

–

Change the paper size

–

Insert columns

–

Insert a section break

–

Open the Page Setup dialog

–

Insert a header

–

Insert a footer

–

Insert a watermark

–

Insert a page border

–

Turn hyphenation on

–

Set line numbers

–

Switch to Print Layout view

Switch to Outline view

Switch to Draft view

Switch to Read Mode

–

Open the Zoom dialog

–

Split the window

Remove the window split

Switch between open documents

New window on the same document

–

Collapse or expand the ribbon

Show the ruler

–

Toggle full screen reading

–

Open the Mailings tab

–

Start the mail merge wizard

–

Select the recipients

–

Insert a merge field

–

Preview the results

–

Finish and merge

–

Open the References tab

–

Insert a table of contents

–

Update the table of contents

–

Insert a citation

–

Insert a bibliography

–

Insert an index

–

Open the Visual Basic editor

Open the Macro dialog

Help

Move text or graphics

Insert an AutoText entry

Repeat the last action

Go To

Go to the next pane

Spelling and grammar

Extend the selection

Update the selected fields

Show the key tips

Go to the next field

Save As

Create a new presentation

Open a presentation

Save

Save As

Close the presentation

Quit the application

Open the File tab

–

Open the application options

Export as PDF

–

Search the Tell Me box

–

Open Help

Insert a new slide

Duplicate the selected slide

Delete the selected slide

Move to the next slide

Move to the previous slide

Go to the first slide

Go to the last slide

Move the slide up

Move the slide down

Move the slide to the start

Move the slide to the end

Change the slide layout

–

Reset the slide placeholders

–

Add a section

–

Open the slide master view

–

Hide the slide

–

Select all objects on the slide

Move to the next placeholder or object

Move to the previous object

Enter or exit text editing in a shape

Deselect or exit the object

Open the Selection pane

–

Cycle between the outline and thumbnail panes

Move to the next pane clockwise

Copy

Cut

Paste

Paste Special

Paste as plain text

Undo

Redo or repeat

Find

Replace

Delete the word to the left

Delete the word to the right

Move one word right

Move one word left

Select to the end of the line

Select to the start of the line

Bold

Italic

Underline

Subscript

Superscript

Change the case of letters

Grow the font size

Shrink the font size

Open the Font dialog

Remove character formatting

Copy the formatting

Paste the formatting

Align left

Align centre

Align right

Justify

Promote a bullet level

Demote a bullet level

Insert a hyperlink

Insert a line break in text

Insert a text box

–

Insert a shape

–

Insert a picture

–

Insert an icon

–

Insert SmartArt

–

Insert a chart

–

Insert a table

–

Duplicate the selected object

Group the selected objects

Ungroup the objects

Bring to front

–

Send to back

–

Bring forward

Send backward

Nudge the object

Nudge by a small step

Constrain drawing to a square or circle

Draw from the centre out

Rotate the object 15 degrees

Open the Format pane

Align the selected objects

–

Merge shapes

–

Open the Format Shape dialog

Toggle the gridlines

Toggle the guides

Open the Grid and Guides dialog

–

Start the show from the beginning

Start the show from the current slide

Start the presenter view

Advance to the next slide

Return to the previous slide

Go to a slide by number

End the show

Black or unblack the screen

White or unwhite the screen

Show or hide the pointer

Change the pointer to a pen

Change the pointer to an arrow

Change the pointer to an eraser

Change the pointer to a highlighter

Erase all ink on the slide

Hide or show ink markup

Show all slides thumbnail grid

Zoom into the slide

Zoom out of the slide

Stop or restart an automatic show

Show the taskbar

Show the slide show help

Return to the first slide

–

Toggle live subtitles

Toggle the camera in Presenter view

–

Switch to Normal view

–

Switch to Slide Sorter view

–

Switch to Notes Page view

–

Switch to Reading view

–

Switch to Outline view

–

Show or hide the notes pane

–

Open the Zoom dialog

–

Fit the slide to the window

–

Insert a comment

Open the Comments pane

–

Go to the next comment

–

Collapse or expand the ribbon

Switch between open presentations

Run the spell checker

Check accessibility

–

Open the Animations tab

–

Open the Animation pane

–

Add an animation

–

Open the animation effect options

–

Preview the animation

–

Open the Transitions tab

–

Apply a transition to all slides

–

Set the transition duration

–

Rehearse timings

–

Record the slide show

–

Set up the slide show

–

Open the Visual Basic editor

Open the Macro dialog

Help

Enter shape edit mode

Repeat the last action

Start the slide show

Move to the next pane

Spelling

Show the key tips

Save As

New report

–

Open a report

–

Save

–

Save As

–

Print the report page

–

Undo

–

Redo

–

Refresh the data model

–

Refresh the current visual

–

Close the application

–

Open the File menu

–

Open the options and settings

–

Open Help

–

Show all keyboard shortcuts

Move focus to the ribbon

–

Move between report areas

Move to the next object

Move to the previous object

Enter a visual or container

Exit a visual or container

Show the ribbon key tips

–

Open the context menu of a visual

Move to the next report page

Move to the previous report page

Open the page navigation list

–

Move focus to the page tabs

–

Copy the selected visual

Cut the selected visual

Paste

Duplicate the selected visual

–

Delete the selected visual

Select all visuals on the page

Add multiple visuals to the selection

Move the selected visual

Resize the selected visual

–

Group the selected visuals

–

Ungroup the visuals

–

Bring the visual forward

–

Send the visual backward

–

Open the Selection pane

–

Toggle the gridlines

–

Toggle snap to grid

–

Add a new report page

–

Rename the report page

Open the data point tooltip

Move between data points

Select or clear a data point

Multi-select data points

Clear the selection in a visual

Open the visual in focus mode

–

Show the data behind the visual

Open the visual filter pane

–

Open the visual more options menu

Copy the visual as an image

–

Sort the visual descending

–

Show or hide the visual header

–

Add a visual to the page

–

Show the visual as a table

Clear the slicer selection

Multi-select slicer items

Select a range of slicer items

Open the Filters pane

–

Drill down on a data point

–

Drill up one level

–

Expand all down one level

–

Turn drill mode on or off

–

Drill through to a page

–

Reset all filters to default

–

Switch to Report view

–

Switch to Data view

–

Switch to Model view

–

Open Power Query Editor

–

Get data

–

Enter data manually

–

Transform the data

–

Manage relationships

–

Create a new measure

–

Create a new column

–

Create a quick measure

–

Manage roles for row-level security

–

Search the fields list

–

Commit the formula

Add a line break in the formula

Cancel the edit

Expand the formula bar

–

Show IntelliSense suggestions

Accept the highlighted suggestion

Indent the selected lines

Outdent the selected lines

Comment out the line

Open the Advanced Editor

–

Add a custom column

–

Remove the selected columns

–

Choose columns to keep

–

Remove rows

–

Split a column

–

Group rows

–

Merge queries

–

Append queries

–

Refresh the preview

–

Close and apply

–

Open the Queries pane

–

Show all keyboard shortcuts

Move between report sections

Open the visual menu

Enter focus mode on a visual

Exit focus mode

Show the data table for a visual

Open the filters pane

Refresh the report

Toggle full screen

Open the bookmarks pane

Add a comment

Copy a visual as an image

Search the workspace

Open the Q and A box

New database

–

Open a database

–

Save the current object

–

Save the object as

–

Print the current object

–

Print Preview

–

Close the current object

–

Close the database

–

Quit Access

–

Open the File tab

–

Open the Access options

–

Open Help

–

Search the Tell Me box

–

Show or hide the navigation pane

–

Search the navigation pane

–

Open the selected object

–

Open the object in Design view

–

Rename the selected object

–

Delete the selected object

–

Copy the selected object

–

Paste the object

–

Cycle between open objects

–

Switch to the next window

–

Show the object properties

–

Open the Immediate window

–

Open the Visual Basic editor

–

Show the Database Documenter

–

Move to the next field

–

Move to the previous field

–

Move to the first field of the record

–

Move to the last field of the record

–

Move to the next record

–

Move to the previous record

–

Move to the first record

–

Move to the last record

–

Move to the first field of the first record

–

Move to the last field of the last record

–

Move down one screen

–

Move up one screen

–

Move one screen right

–

Move one screen left

–

Go to the record number box

–

Jump to a new blank record

–

Enter or leave edit mode in a field

–

Save the current record

–

Undo typing in the field

–

Undo the change to the record

–

Undo the last action

–

Insert a new record

–

Delete the current record

–

Copy the value from the same field above

–

Insert the current date

–

Insert the current time

–

Insert the default value of the field

–

Insert a new line in a field

–

Check the spelling

–

Recalculate and refresh the fields

–

Requery the underlying data

–

Select the entire field

–

Extend the selection to the next field

–

Extend the selection to the previous field

–

Select the current record

–

Select the current column

–

Select all records

–

Extend the selection to the last record

–

Extend the selection to the first record

–

Extend the selection down one screen

–

Cancel the selection

–

Find

–

Replace

–

Find the next occurrence

–

Filter by selection

–

Apply or remove the filter

–

Clear all filters

–

Sort ascending

–

Sort descending

–

Remove the sort

–

Open the advanced filter window

–

Toggle the totals row

–

Create a new query in Design view

–

Open the query wizard

–

Run the query

–

Switch to Design view

–

Switch to SQL view

–

Switch to Datasheet view

–

Open the Zoom box for a long expression

–

Open the Expression Builder

–

Show or hide the query properties

–

Add a table to the query

–

Insert a Totals row in the grid

–

Move between the upper and lower panes

–

Switch between Form and Design view

–

Open the property sheet

–

Open the field list

–

Move the selected control

–

Resize the selected control

–

Nudge the control by grid steps

–

Select the next control

–

Select all controls

–

Align the selected controls

–

Group the controls in a layout

–

Add a form header or footer

–

Insert a page break in a report

–

Switch to Layout view

–

Switch to Report view

–

Open the Tab Order dialog

–

Open the External Data tab

–

Import from Excel

–

Export to Excel

–

Export to text or CSV

–

Export to PDF

–

Open the Linked Table Manager

–

Open the Database Tools tab

–

Open the Relationships window

–

Compact and repair the database

–

Run the Performance Analyzer

–

Encrypt with a password

–

Open the Macro Designer

–

Copy

Cut

Paste

Paste values only

Undo

Redo

Find

Find and replace

Save (Sheets saves automatically)

Open a file

Insert a link

Open the keyboard shortcuts list

Search the menus

Show or hide the menus

Open the browser find bar

Move one cell in any direction

Move to the next cell right

Move to the next cell left

Move to the start of the row

Move to the end of the row

Move to cell A1

Move to the last cell with data

Jump to the edge of the data

Move one screen down

Move one screen up

Move one screen right

Move one screen left

Go to the next sheet

Go to the previous sheet

Open the list of sheets

Go to a named range or A1 reference

Move focus out of the grid

Select the whole column

Select the whole row

Select all cells

Extend the selection by one cell

Extend the selection to the edge of data

Extend the selection to the start of the row

Extend the selection one screen down

Select the current data region

Move the active cell within the selection

Select up to cell A1

Select down to the last data cell

Edit the active cell

Cancel the entry

Add a line break inside a cell

Insert the current date

Insert the current time

Insert the date and time

Fill down from the cell above

Fill right from the cell left

Fill the selected range

Clear the cell contents

Insert a checkbox

Open the dropdown or data validation chip

Open the smart chip menu

Show the autocomplete suggestions

Insert rows above

Insert columns to the left

Insert cells and shift down

Delete the selected rows

Delete the selected columns

Hide a row

Unhide rows

Hide a column

Unhide columns

Group rows or columns

Ungroup rows or columns

Expand a grouped range

Collapse a grouped range

Resize to fit the data

Bold

Italic

Underline

Strikethrough

Centre align

Left align

Right align

Clear the formatting

Apply the top border

Apply the right border

Apply the bottom border

Apply the left border

Apply the outer border

Remove all borders

Wrap text

Merge cells

Open conditional formatting

Paste formatting only

Plain number format

Time format

Date format

Currency format

Percentage format

Exponent format

Clear the number format

Show or hide all formulas

Collapse an expanded array formula

Toggle absolute and relative references

Insert an array formula

Show or hide the formula help

Compact the formula help

Recalculate volatile functions

Insert the SUM function

Show the function list

Insert a new sheet

Turn the filter on or off

Open the filter menu of a column

Sort the range A to Z

Freeze the first row

Create a pivot table

Create a chart

Open the data validation dialog

Open Explore for quick insights

Insert or edit a comment

Insert or edit a note

Open the comment thread list

Move to the next comment

Move to the previous comment

Open the revision history

Open the share dialog

Turn on screen reader support

Open the File menu

Open the Edit menu

Open the View menu

Open the Insert menu

Open the Format menu

Open the Data menu

Open the Tools menu

Open the Extensions menu

Open the Help menu

Open the sheet context menu

Open the row or column context menu

Copy

Cut

Paste

Paste without formatting

Undo

Redo

Select all

Find

Find and replace

Find again

Find previous

Open a file

Save (Docs saves automatically)

Open the keyboard shortcuts list

Search the menus

Insert or edit a link

Open the link under the cursor

Repeat the last action

Move one word left

Move one word right

Move to the start of the line

Move to the end of the line

Move to the start of the document

Move to the end of the document

Move one paragraph up

Move one paragraph down

Select one word

Select to the end of the line

Select the paragraph

Select to the end of the document

Extend the selection one line

Select the next occurrence of the selection

Move the paragraph up

Move the paragraph down

Bold

Italic

Underline

Strikethrough

Superscript

Subscript

Increase the font size

Decrease the font size

Clear the formatting

Copy the formatting

Paste the formatting

Change the text colour

Highlight the text

Align left

Align centre

Align right

Justify

Increase the indent

Decrease the indent

Apply normal text style

Apply heading 1

Apply heading 2

Apply heading 3

Apply heading 4

Apply heading 5

Apply heading 6

Move to the next heading

Move to the previous heading

Line spacing menu

Bulleted list

Numbered list

Checklist

Indent or demote the list item

Outdent or promote the list item

Move the list item up

Move the list item down

Tick or untick a checklist item

Move to the next list item

Insert a page break

Insert a column break

Insert a comment

Insert a footnote

Insert a link

Insert an image

Insert an equation

Insert a smart chip or mention

Insert an em dash

Insert a special character

Insert a table

Insert a building block

Move to the next cell

Move to the previous cell

Add a new row below

Insert a row above

Delete the row

Move to the start of the table

Move to the end of the table

Move to the next table

Move to the previous table

Open the table properties

Insert a comment

Open the comment thread list

Move to the next comment

Move to the previous comment

Enter the current comment

Resolve the comment

Switch to suggesting mode

Accept the suggestion

Open the revision history

Open the share dialog

Email the collaborators

Show or hide the document outline

Show or hide the menus

Move to the sidebar

Move focus out of the document

Show the word count

Open the spelling and grammar check

Open the dictionary

Open Explore

Turn on screen reader support

Turn on voice typing

Zoom in the browser

Zoom out the browser

Open the File menu

Open the Edit menu

Open the View menu

Open the Insert menu

Open the Format menu

Open the Tools menu

Open the Extensions menu

Open the Help menu

Open the context menu

Copy

Cut

Paste

Paste without formatting

Undo

Redo

Select all

Find and replace

Open a file

Save (Slides saves automatically)

Open the keyboard shortcuts list

Search the menus

Insert or edit a link

Repeat the last action

New slide

Duplicate the slide

Delete the slide

Move to the next slide

Move to the previous slide

Move the slide up

Move the slide down

Move the slide to the start

Move the slide to the end

Skip or unskip the slide

Open the slide layout menu

Change the background

Move to the filmstrip

Move to the canvas

Bold

Italic

Underline

Strikethrough

Superscript

Subscript

Increase the font size

Decrease the font size

Clear the formatting

Copy the formatting

Paste the formatting

Align left

Align centre

Align right

Justify

Bulleted list

Numbered list

Increase the indent

Decrease the indent

Insert a text box

Insert an image

Insert a shape

Insert a line

Duplicate the selected object

Select the next object

Select the previous object

Enter text editing on the object

Deselect the object

Move the object

Move the object by one pixel

Group the objects

Ungroup the objects

Bring to front

Send to back

Bring forward

Send backward

Rotate the object 15 degrees clockwise

Rotate the object 1 degree

Resize while keeping the ratio

Draw from the centre out

Open the format options

Crop the selected image

Reset the image

Insert a diagram or chart

Start the presentation from the first slide

Start the presentation from the current slide

Advance to the next slide

Return to the previous slide

Go to a specific slide

Go to the first slide

Go to the last slide

Exit the presentation

Open the speaker notes

Open the audience tools

Toggle captions

Toggle the laser pointer

Blacken or unblacken the screen

Whiten or unwhiten the screen

Toggle full screen

Show the shortcut help during a show

Print the presentation

Insert a comment

Open the comment thread list

Move to the next comment

Move to the previous comment

Open the revision history

Open the share dialog

Open the speaker notes pane

Turn on screen reader support

Show or hide the menus

Zoom in

Zoom out

Show the guides

Open the File menu

Open the Edit menu

Open the View menu

Open the Insert menu

Open the Format menu

Open the Slide menu

Open the Arrange menu

Open the Tools menu

Open the Help menu

Open the context menu

Keyboard Shortcuts Reference

Basic Navigation 22

Selecting Cells & Ranges 23

Entering & Editing Data 21

Copy, Paste & Fill 17

Rows, Columns & Cells 13

Cell Formatting 18

Number Formatting 11

Alignment & Text Layout 12

Formulas & Functions 16

Formula Auditing 8

Names & References 5

Data, Tables & Validation 20

PivotTables 12

Charts & Objects 16

Find, Replace & Go To 10

Workbook & File Management 15

Worksheet Management 10

Window & View 16

Print & Page Layout 10

Comments, Notes & Review 10

Grouping & Outlining 8

Function Keys 20

Ribbon Access - Home Tab 28

Ribbon Access - Insert Tab 20

Ribbon Access - Formulas Tab 21

Ribbon Access - Data Tab 20

Ribbon Access - Review & View 21

Macros & VBA 11

Miscellaneous 11

Document Basics 13

Moving the Cursor 16

Selecting Text 17

Editing Text 15

Character Formatting 22

Paragraph Formatting 17

Styles 11

Lists & Outlines 11

Tables 19

Insert Objects & Fields 29

Find, Replace & Navigate 7

Review & Track Changes 14

Page Layout & Sections 13

Views & Window 12

Mail Merge & References 12

Macros & Function Keys 14

Presentation Basics 12

Working with Slides 16

Selecting & Navigating Objects 8

Editing Text 15

Text Formatting 20

Shapes, Pictures & Arrange 26

Slide Show Delivery 25

Views, Notes & Comments 15

Animation & Transitions 11

Macros & Function Keys 10

File & Report Basics 13

Navigation & Focus 13

Report Editing 18

Working with Visuals 14

Slicers, Filters & Drill 10

Data & Model View 13

DAX & Formula Bar 9

Power Query Editor 12

Power BI Service (browser) 14

Database Basics 13

Navigation Pane & Objects 14

Datasheet Navigation 16

Editing Records 15

Selecting in a Datasheet 10

Find, Filter & Sort 11

Queries & SQL View 12

Forms & Reports Design 15

Import, Export & Tools 12

Common Actions 16

Navigating the Sheet 17

Selecting Cells 11

Entering & Editing Data 14

Rows, Columns & Cells 14

Formatting 18