Navigation Shortcuts
- Ctrl + Arrow Keys: Move to the edge of data regions.
- Ctrl + Home: Move to the beginning of the worksheet.
- Ctrl + End: Move to the last cell with data.
Selection Shortcuts
- Ctrl + Shift + Arrow Keys: Extend the selection to the edge of the data region.
- Shift + Space: Select the entire row.
- Ctrl + Space: Select the entire column.
- Ctrl + A: Select the entire worksheet or current data region.
Editing Shortcuts
- F2: Edit the active cell.
- Alt + Enter: Insert a line break within a cell.
Formatting Shortcuts
- Ctrl + 1: Open the Format Cells dialog box.
- Ctrl + Shift + $: Apply currency format.
- Ctrl + Shift + #: Apply date format.
Data Handling Shortcuts
- Ctrl + D: Fill down.
- Ctrl + R: Fill right.
- Ctrl + –: Delete selected cells/rows/columns.
- Ctrl + Shift + L: Toggle filters on or off.
- Ctrl + T: Create a table from the selected data.
Miscellaneous Shortcuts
- Ctrl + H: Replace.