All shortcuts
Browse every published shortcut. Start here if you want the full catalog instead of the interactive tools.
Invoke Flash Fill
Automatically recognize patterns in adjacent columns and fill the current column based on the detected pattern.
Cycle through absolute and relative references
Press F4 to toggle a selected cell reference or range in a formula between absolute ($A$1), mixed (A$1 or $A1), and relative (A1) references.
Insert a function
Opens the Insert Function dialog to search and select a function.
Copy value from cell above
Copies the value from the cell directly above the active cell into the current cell or the formula bar.
Create embedded chart
Inserts a chart as an object in the current worksheet using the selected data range.
Create Chart in New Chart Sheet
Inserts a chart of the selected data range into a new Chart sheet.
Define a name to use in references
Open the New Name dialog to define a named range or constant for use in formulas.
Paste a Name from Paste Name Dialog Box
Open the Paste Name dialog box and paste a defined name into a formula.
Create, run, edit, or delete a macro
Open the Macro dialog to create, run, edit, or delete macros.
Open Visual Basic for Applications Editor
Open the Microsoft Visual Basic for Applications (VBA) editor to write and edit macros.
Open the Power Query Editor
Open the Power Query Editor to transform and clean data.
Refresh data in current worksheet
Refreshes the data in the active worksheet, updating external data connections and recalculating formulas.
Refresh All Data in Workbook
Refreshes all data connections and queries in the current workbook.
Delete Table
Deletes the selected table in Excel.
Move the Table
Move the selected table to a new location in the worksheet.
Rename Table
Rename the active table in Excel.
Select to last cell in column
Extends the selection from the active cell to the last used cell in the same column.
Select cells from current location to first cell of column
Extends the selection from the current cell to the first cell in the same column.
Select to last cell in row
Extends the selection from the current cell to the last used cell in the same row.
Select to First Cell in Row
Extends the selection from the current cell to the first cell in the same row.
Move to First Cell of Selected Column
Navigates to the topmost cell in the currently selected column.
Move to the last cell of selected column
Moves the active cell to the last cell in the current column that contains data or formatting.
Close dialog box or cancel process
Press Ctrl+Esc to close a dialog box or cancel an ongoing process like a paste operation.
Open Go To Dialog
Open the Go To dialog box to quickly navigate to a specific cell, range, or named reference.