Microsoft Excel

Close a workbook

Go to the Home tab

Copy selection

Undo recent action

Choose a fill color

Go to the Insert tab

Center align cell contents

Go to the Data tab

Open the context menu

Delete column

Hide the selected rows

Move to the Tell me or Search field on the ribbon and type a search term for assistance or Help content

Open the Home tab and format text and numbers and use the Find tool

Open the Page Layout tab and work with themes, page setup, scale, and alignment

Open the Data tab and connect to, sort, filter, analyze, and work with data

Open the View tab and preview page breaks and layouts, show and hide gridlines and headings, set zoom magnification, manage windows and panes, and view macros

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

Show the tooltip for the ribbon element currently in focus

Open the list for a selected command

When a menu or submenu is open, move to the next command

Open a context menu

Move from one group of controls to another

Move to the previous cell in a worksheet or the previous option in a dialog box

Move one cell down in a worksheet

Move one cell right in a worksheet

Enter the End mode, move to the next nonblank cell in the same column or row as the active cell, and turn off End mode. If the cells are blank, move to the last cell in the row or column

Extend the selection of cells to the last used cell on the worksheet (lower-right corner)

Move to the beginning of a worksheet

Move to the next sheet in a workbook

Move one screen up in a worksheet

Move to the previous sheet in a workbook

Open the list of validation choices on a cell that has data validation option applied to it

Exit the floating shape navigation and return to the normal navigation

Zoom in

Open the Format Cells dialog box

Edit the active cell and put the insertion point at the end of its contents. Or, if editing is turned off for the cell, move the insertion point into the formula bar. If editing a formula, toggle Point mode off or on so you can use the arrow keys to create a reference

Insert a threaded comment. Open and reply to a threaded comment

Open the Delete dialog box to delete selected cells

Enter the current date

Copy a formula from the cell above the active cell into the cell or the formula bar

Copy the selected cells

Open the Paste Special dialog box

Bold text or remove bold formatting

Apply or remove strikethrough formatting

Apply an outline border to the selected cells

Display or hide the outline symbols

Apply the General number format

Apply the Percentage format with no decimal places

Apply the Date format with the day, month, and year

Apply the Number format with two decimal places, thousands separator, and minus sign (-) for negative values

Check spelling in the active worksheet or selected range

Display the Create Table dialog box

Paste all cell contents and formatting

Paste only the values (not the formulas)

Paste only comments and notes attached to the cell

Paste all cell contents and formatting from copied cells

Paste only column widths from copied cells

Paste only the values (not formulas) and number formats from copied cells

Select the entire worksheet

Select the current and previous sheet in a workbook

Extend the selection of cells to the last nonblank cell in the same column or row as the active cell, or if the next cell is blank, to the next nonblank cell

Add a non-adjacent cell or range to a selection of cells by using the arrow keys

Fill the selected cell range with the current entry

Select an entire column in a worksheet

Select all objects on a worksheet when an object is selected

Select the current region if the worksheet contains data. Press a second time to select the current region and its summary rows. Press a third time to select the entire worksheet

Select the first command on the menu when a menu or submenu is visible

Undo the last action

Collapse grouped rows or columns

Turn on or off tooltips for checking formulas directly in the formula bar or in the cell you're editing

Expand or collapse the formula bar

Complete an entry in the formula bar and select the cell below

Select all text in the formula bar from the cursor position to the end

Calculate the active worksheet

Check dependent formulas, and then calculate all cells in all open workbooks, including cells not marked as needing to be calculated

Display the Function Arguments dialog box when the insertion point is to the right of a function name in a formula

Insert the AutoSum formula

Cycle through all combinations of absolute and relative references in a formula if a cell reference or range is selected

Copy the value from the cell above the active cell into the cell or the formula bar

Create a chart of the data in the current range in a separate Chart sheet

Paste a name from the Paste Name dialog box (if names have been defined in the workbook)

Create, run, edit, or delete a macro

Open the Power Query Editor

Stop a refresh operation

Refresh all data in the workbook

Open the context menu for the selected cell, column, or row

Copy selected data

Move the table

Save the file

Undo the last action

Select the current row

Select all cells from the current location to the first cell of the column

Select all cells from the current location to the first cell of the row

Move to the next table

Move to the last cell in the lower-right corner of selected table

Move to the last cell of the selected row

Move to the last cell of selected column

Open the AutoFilter Menu dialog box

Recalculate all formulas in the Power Pivot window