Excel Shortcut Keys to Speed up Your Work

Navigation Shortcuts

• CTRL + LEFT/RIGHT/UP/DOWN: Move to the next populated cell
• CTRL + END: Move to the last populated cell
• CTRL + HOME: Return to Cell A1
• CTRL + G: Go to a specific cell by entering the address
• CTRL + PAGE DOWN: Go to the next spreadsheet
• CTRL + PAGE UP: Go to the previous spreadsheet

Home Tab Shortcuts

Clipboard

• ALT + E + S + V: Paste as values

Borders

• ALT + H + B + S: Outside borders
• ALT + H + B + A: All borders
• ALT + H + B + N: No borders

Number

• ALT + H + N: Update cell format

Cells

• ALT + I + R: Insert new row
• ALT + I + C: Insert new column
• ALT + O + C + A: AutoFit column width
• ALT + O + R + A: AutoFit row height
• SHIFT + SPACE: Select entire row
  • ALT + E + D: Delete entire row
• CTRL + SPACE: Select entire column
  • ALT + E + D: Delete entire column

Editing

• ALT + D + F + F: Toggle on/off auto filter
  • ALT + A + C: Clear filter