Excel Keyboard Shortcuts

Moves to the next sheet tab.

Moves to the previous sheet tab.

Switches between open Excel workbooks.

Jumps to the last used cell on the sheet.

Jumps to the edge of the current data block.

Keeps the first row visible while scrolling.

Locks rows above and columns left of the selected cell.

Keeps the first column visible while scrolling sideways.

Removes all frozen rows and columns.

Adds a new worksheet.

Zooms the sheet in or out.

Searches the sheet for text.

Finds text and replaces it.

Makes the cell text bold.

Crosses out the text in selected cells.

Opens the fill colour menu for the selected cells.

Merges the selected cells and centers the text.

Copies formatting from one cell to another.

Wraps long text onto several lines in the cell.

Opens the Format Cells box.

Clears the contents of the selected cells.

Turns the selected range into a table.

Creates a chart from the selected data.

Turns filter arrows on or off for the table.

Deletes repeated rows from the selected range.

Adds a comment to the cell.

Inserts a new row above the selected row.

Deletes the selected row.

Inserts a new column to the left.

Deletes the selected column.

Selects the whole row of the active cell.

Selects the whole column of the active cell.

Hides the selected rows.

Hides the selected columns.

Groups the selected rows or columns.

Ungroups the selected rows or columns.

Adds a SUM formula for the cells above.

Totals the numbers above the active cell.

Toggles $ signs to make a reference absolute.

Shows formulas instead of results.

Puts the active cell into edit mode.

Copies the cell above into the selected cells.

Copies the cell on the left into the selected cells.

Continues a series down using Flash Fill.

Types today's date into the cell.

Types the current time into the cell.

Starts a new line inside the same cell.

Selects the whole sheet or current region.

Cuts the selected cells.

Copies the selected cells.

Pastes copied cells.

Pastes only the values, without formulas or formatting.

Opens the Paste Special box.

Reverses your last action.

Repeats the action you undid.

Saves the workbook.

Saves a copy with a new name or location.