Navigation Shortcuts:

  1. Ctrl + Arrow Keys: Navigate to the edge of data regions.
  2. Ctrl + Home: Move to the beginning of the worksheet.
  3. Ctrl + End: Move to the end of the worksheet.
  4. Ctrl + Page Up: Move to the previous worksheet.
  5. Ctrl + Page Down: Move to the next worksheet.
  6. Alt + Page Up/Page Down: Switch between open Excel workbooks.
  7. Ctrl + G or F5: Display the “Go To” dialog box.
  8. Ctrl + Tab/Shift + Ctrl + Tab: Switch between open worksheets.
  9. Ctrl + ‘ (apostrophe): Copy the formula from the cell above.
  10. Ctrl + Shift + L: Toggle autofilter.

Selection Shortcuts:

  1. Ctrl + Space: Select the entire column.
  2. Shift + Space: Select the entire row.
  3. Ctrl + A: Select the entire worksheet.
  4. Shift + Arrow Keys: Extend the selection.
  5. Ctrl + Shift + Arrow Keys: Extend the selection to the edge of data regions.
  6. Ctrl + Shift + Space: Select the entire worksheet.
  7. Ctrl + . (period): Select cells with data around the active cell.
  8. Ctrl + Shift + “+”: Insert new cells.
  9. Ctrl + Space followed by Shift + Space: Select the current region.
  10. Shift + Backspace: Select the active cell.

Editing Shortcuts:

  1. Ctrl + X/C/V: Cut/Copy/Paste.
  2. Ctrl + Z/Y: Undo/Redo.
  3. F2: Edit the active cell.
  4. Ctrl + D: Fill down.
  5. Ctrl + R: Fill right.
  6. Ctrl + Shift + “+”: Insert new sheet.
  7. Ctrl + H: Find and replace.
  8. Ctrl + F3: Define a name.
  9. Ctrl + Space followed by Ctrl + – (minus): Delete the selected column.
  10. Ctrl + – (minus): Delete the selected cells.

Formatting Shortcuts:

  1. Ctrl + B/I/U: Bold/Italic/Underline.
  2. Ctrl + 1: Format cells dialog box.
  3. Ctrl + Shift + $: Apply currency format.
  4. Ctrl + Shift + %: Apply percentage format.
  5. Ctrl + Shift + #: Apply date format.
  6. Ctrl + Shift + @: Apply time format.
  7. Ctrl + Shift + &: Apply outline borders.
  8. Ctrl + Shift + _ (underscore): Remove borders.
  9. Alt + H + B + A: Add or remove cell shading.
  10. Alt + H + B + F: Add or remove font color.

Formula Shortcuts:

  1. = (equal sign): Start a formula.
  2. Ctrl + `: Show formulas in cells.
  3. F9: Calculate the active worksheet.
  4. Alt + =: AutoSum.
  5. Ctrl + Shift + $: Apply currency format.
  6. Ctrl + Shift + %: Apply percentage format.
  7. Ctrl + ; (semicolon): Insert the current date.
  8. Ctrl + Shift + #: Apply date format.
  9. Ctrl + Shift + @: Apply time format.
  10. Ctrl + Shift + “: Copy the value from the cell above.

Workbook Shortcuts:

  1. Ctrl + N/O/S: New/Open/Save workbook.
  2. Ctrl + P: Print the active sheet.
  3. Ctrl + W: Close the active workbook.
  4. Ctrl + F4: Close the active window.
  5. Ctrl + Shift + N: Create a new workbook.
  6. Alt + F4: Close Excel.
  7. Ctrl + F12: Open the “Save As” dialog box.
  8. F12: Save As.
  9. Alt + F + U: Save and upload to the cloud.
  10. Alt + F + O + D: Open the “Office” dialog box.

Data Shortcuts:

  1. Alt + D + L: Create data filter.
  2. Ctrl + Shift + L: Toggle autofilter.
  3. Alt + D + S: Sort.
  4. Alt + H + S + I: Sort in ascending order.
  5. Alt + H + S + D: Sort in descending order.
  6. Alt + D + A + S: AutoSum.
  7. Ctrl + T: Create a table.
  8. Ctrl + Shift + $: Apply currency format.
  9. Ctrl + Shift + %: Apply percentage format.
  10. Ctrl + Shift + #: Apply date format.

Cell Content Shortcuts:

  1. Alt + Enter: Start a new line in the same cell.
  2. Ctrl + K: Insert hyperlink.
  3. Ctrl + Space followed by Shift + Space: Select the current region.
  4. Ctrl + 5: Apply or remove strikethrough.
  5. Ctrl + J: Fill down.
  6. Ctrl + R: Fill right.
  7. Ctrl + Shift + ” (quotation mark): Copy value from the cell to the left.
  8. Ctrl + ‘ (apostrophe): Copy formula from the cell above.
  9. Ctrl + Alt + V: Paste special.
  10. Ctrl + Alt + E + S + V: Paste values.

Function Shortcuts:

  1. Alt + E + S + V: Paste special.
  2. Alt + H + F + C: Count cells.
  3. Alt + H + F + A: Average cells.
  4. Alt + H + F + M: Find the smallest value.
  5. Alt + H + F + X: Find the largest value.
  6. Alt + E + I + S: Insert new sheet.
  7. Alt + E + D + S: Delete sheet.
  8. Ctrl + Shift + “+”: Insert new cells.
  9. Ctrl + Shift + “-“: Delete cells.
  10. Alt + E + S + U: Remove duplicates.

Other Useful Shortcuts:

  1. Ctrl + Semicolon (;): Insert the current date.
  2. Ctrl + ‘: Copy formula from the cell above.
  3. Ctrl + Shift + “+”: Insert new sheet.
  4. Ctrl + Shift + “-“: Delete sheet.
  5. Ctrl + Shift + L: Toggle autofilter.
  6. Ctrl + Shift + J: Group rows.
  7. Ctrl + Shift + ‘+’: Outline symbols.
  8. Ctrl + Shift + ‘-‘: Remove outline symbols.
  9. Ctrl + F3: Define a name.
  10. Ctrl + Alt + F1: Insert a new worksheet.