Master these shortcuts to work 10x faster in Excel. These are the ones professionals use daily.

Navigation Shortcuts

1. Ctrl + Arrow Keys - Jump to Data Edges

Ctrl + → Jump to last filled cell in row

Ctrl + ↓ Jump to last filled cell in column

Why it's powerful: Navigate huge datasets instantly without scrolling.

2. Ctrl + Home / End - Go to Start/End

Ctrl + Home → Cell A1

Ctrl + End → Last used cell in sheet

3. Ctrl + Page Up/Down - Switch Worksheets

Move between sheets without using mouse

Selection Shortcuts

4. Ctrl + Shift + Arrow - Select to Data Edge

Ctrl + Shift + ↓ Select from current cell to last filled cell in column

Use case: Select entire data range in one keystroke

5. Ctrl + A - Select All (Smart Selection)

Press once: Selects current data region

Press twice: Selects entire worksheet

6. Shift + Space / Ctrl + Space

Shift + Space → Select entire row

Ctrl + Space → Select entire column

Data Entry Shortcuts

7. Ctrl + D - Fill Down

Select cells A1:A10
A1 has value "Product"
Press Ctrl + D
→ All cells now have "Product"

Ctrl + R fills right (same logic)

8. Ctrl + ; - Insert Today's Date

Ctrl + ; (semicolon) → Today's date

Ctrl + Shift + ; → Current time

These are static values (don't update daily like =TODAY())

9. Alt + Enter - New Line in Cell

Insert line break within a single cell (multi-line text)

Productivity Shortcuts

10. Ctrl + T - Create Table

Instantly convert range to Excel Table with:

• Auto-filters
• Formatted headers
• Structured references in formulas
• Auto-expand when adding data

Bonus: Formula Shortcuts

Shortcut	Action
Alt + =	AutoSum (inserts SUM formula)
F4	Toggle absolute/relative references ($A$1)
Ctrl + `	Show formulas in cells (toggle)
F2	Edit active cell
F9	Calculate all worksheets

Power Combo: Select Entire Dataset

1. Click any cell in your data
2. Ctrl + Shift + End
→ Selects from current cell to end of data

Or:
1. Click top-left cell of data
2. Ctrl + Shift + →, then Ctrl + Shift + ↓
→ Selects entire rectangular data region

Practice Challenge

Try this workflow without using your mouse:

1. Ctrl + Home (go to A1)
2. Ctrl + Shift + End (select all data)
3. Ctrl + T (create table)
4. Enter (confirm)

You just created a formatted table in 4 keystrokes! ⚡