Excel shortcut table:

Category Shortcut Description

Basic Navigation Arrow Keys Move one cell up, down, left, or right.
Ctrl + Arrow Key Jump to the end of a data region.
Ctrl + Home Go to the beginning of the sheet (A1).
Ctrl + End Go to the last cell with data.
Page Up Move up one screen.
Page Down Move down one screen.
Ctrl + Page Up Move to the previous sheet.
Ctrl + Page Down Move to the next sheet.
Tab Move to the next cell to the right.
Shift + Tab Move to the previous cell.
Selection Shift + Arrow Key Extend selection by one cell.
Extend selection to the end of the data
Ctrl + Shift + Arrow Key region.
Shift + Spacebar Select the entire row.
Ctrl + Spacebar Select the entire column.
Ctrl + A Select the entire worksheet.
Ctrl + Shift + Spacebar Select the current table or region.
Ctrl + Shift + End Select from the current cell to the last cell.
Ctrl + Shift + Home Select from the current cell to the start.
Editing F2 Edit the active cell.
Enter Complete a cell entry.
Alt + Enter Start a new line in the same cell.
Backspace Delete content while editing.
Delete Clear cell content.
Ctrl + Delete Delete all text in a cell to the right.
Ctrl + X Cut.
Ctrl + C Copy.
Ctrl + V Paste.
Ctrl + Z Undo.
Ctrl + Y Redo.
Ctrl + D Fill down.
Ctrl + R Fill right.
Ctrl + “+” Insert rows or columns.
Ctrl + “-” Delete rows or columns.
Shift + F2 Add or edit a cell comment.
Formatting Ctrl + 1 Open the Format Cells dialog box.
Ctrl + B Apply or remove bold formatting.
Ctrl + I Apply or remove italic formatting.
Ctrl + U Apply or remove underline formatting.
Alt + H + H Choose a fill color.
Alt + H + F + C Choose a font color.
Ctrl + Shift + F Open the Font tab in Format Cells.
 Ctrl + Shift + P Open the Font Size dropdown.
Ctrl + Shift + “&” Add borders to the selection.
Ctrl + Shift + “_” Remove borders.
Alt + E + S + T Paste format only.
Formulas #ERROR! Start a formula.
Alt + = AutoSum.
F4 Toggle absolute and relative references.
Ctrl + ` Show or hide formulas.
Shift + F3 Open the Insert Function dialog box.
Ctrl + Shift + U Expand or collapse the formula bar.
Data Handling Ctrl + T Convert data into a table.
Ctrl + Shift + L Toggle filters.
Alt + Down Arrow Open the filter dropdown.
Ctrl + ; Enter the current date.
Ctrl + Shift + : Enter the current time.
Ctrl + K Insert a hyperlink.
Ctrl + “-” Delete a cell.
Ctrl + Shift + “+” Insert a cell.
Workbook and Worksheet Ctrl + N Create a new spreadsheet.
Ctrl + O Open an existing spreadsheet.
Ctrl + S Save the spreadsheet.
Ctrl + Shift + S Save As.
Ctrl + W Close the current spreadsheet.
Ctrl + F4 Close Google Sheets.
Ctrl + P Open the Print dialog box.
Ctrl + Tab Switch between sheets.
Shift + F11 Insert a new sheet.
Search and Replace Ctrl + F Open the Find dialog box.
Ctrl + H Open the Replace dialog box.
Ctrl + K Find.
Ctrl + Shift + K Find Next.
Mouse Shortcuts Double-Click Cell Border Jump to the last row/column of data.
Double-Click Fill Handle Auto-fill down for adjacent data.
Right-Click Drag + Drop Move or copy cells.
Miscellaneous F1 Open the Help menu.
F7 Open the Spelling dialog box.
Ctrl + Alt + V Open the Paste Special dialog box.
Ctrl + Shift + U Expand or collapse the formula bar.
Ctrl + Q Quick analysis tools.
Custom Formatting Ctrl + Shift + $ Apply currency format.
Ctrl + Shift + % Apply percentage format.
Ctrl + Shift + # Apply date format.
Ctrl + Shift + @ Apply time format.
Ctrl + Shift + ^ Apply scientific format.
Ctrl + Shift + ! Apply number format.
Adjusting Views Alt + W + F Freeze panes.
Alt + W + S Split panes.
Ctrl + Alt + S Toggle workbook split.
Ctrl + Mouse Wheel Zoom in or out.
Other Handy Shortcuts Ctrl + 9 Hide rows.
Ctrl + Shift + 9 Unhide rows.
Ctrl + 0 Hide columns.
Ctrl + Shift + 0 Unhide columns.
Ctrl + Alt + F9 Force recalculation of all worksheets.
Ctrl + Alt + Shift + F9 Recheck all formulas for dependencies.