Extended Excel Shortcuts Guide

Navigation Shortcuts

• Ctrl + Arrow Keys: Move to the edge of the data region.
• Ctrl + Home: Go to cell A1.
• Ctrl + End: Move to the last used cell on the worksheet.
• Ctrl + Page Up/Page Down: Switch between worksheet tabs.

Editing Shortcuts

• Alt + Enter: Insert a new line within the same cell.
• F2: Edit the selected cell.
• Ctrl + Y: Redo the last action (opposite of Ctrl + Z).
• Ctrl + D: Copy the content of the top cell down.

Formatting Shortcuts

• Ctrl + 1: Open the Format Cells dialog box.
• Ctrl + Shift + ~: Apply General number format.
• Ctrl + Shift + %: Apply Percentage format.
• Ctrl + Shift + $: Apply Currency format.

Data Manipulation Shortcuts

• Ctrl + T: Convert data to a table.
• Alt + E, S, V: Paste Special options (after copying).
• Ctrl + Space: Select the entire column.
• Shift + Space: Select the entire row.

Quick Formula Tricks

• F9: Calculate all worksheets in all open workbooks.
• Ctrl + Shift + Enter: Enter array formulas.
• Ctrl + `: Toggle the display of formulas in cells.

Workbook and Sheet Management

• Ctrl + N: Create a new workbook.
• Ctrl + S: Save the current workbook.
• Ctrl + W: Close the current workbook.
• Alt + H, O, R: Rename the current worksheet.

Quick Selection Tricks

• Ctrl + A: Select the entire data region.
• Ctrl + Shift + * (Asterisk): Select the current region of data.
• Shift + Arrow Keys: Extend the selection in a direction.

Powerful Miscellaneous Shortcuts

• Alt + F11: Open the VBA Editor.
• Ctrl + F: Open Find and Replace.
• Ctrl + K: Insert a hyperlink.
• Alt + =: Auto-sum the selected range.