Excel Shortcuts

Show Key Tips for the ribbon

Show or hide the ribbon

Switch to Print Preview

Switch between worksheet, ribbon, task pane, and status bar

Move to the next control or dialog box option

Move to the previous control or dialog box option

Select all cells in the worksheet

Select the current region around the active cell

Select the entire column

Select the entire row

Extend the selection by one cell

Extend selection to the last used cell

Extend selection to the first cell

Edit the active cell

Complete a cell entry

Cancel a cell entry

Fill down from cell above

Fill right from cell to the left

Undo

Redo

Enter the current date

Enter the current time

Start a formula

Toggle absolute/relative reference

Show formulas in cells

Enter array formula

AutoSum the selected cells

Expand or collapse the formula bar

Open Format Cells dialog

Apply or remove bold

Apply or remove italic

Apply or remove underline

Apply or remove strikethrough

Toggle filters

Pick a fill color

Apply All Borders

Create a new workbook

Open a workbook

Save the workbook

Print the workbook

Close the active workbook

Find in worksheet

Find and replace

Move to the next sheet

Move to the previous sheet

Insert a new worksheet

Create an embedded chart

Create a chart in a separate Chart sheet

Create a PivotTable

Open the Sort dialog

Open the Filter menu

Open the Text to Columns wizard

Remove duplicates

Zoom in or out

Switch to zoom dialog

Maximize or restore the workbook window

Restore the workbook window size