Navigation │ Data Functions │ Formatting │ Function │ Ribbon │ Selection │ Worksheet

Below is a listing of 30 most useful shorts that will save you tons of time. They are listed by function.

To check all major shortcuts listed by function, please see 212 Excel Shortcuts.

What to doShortcuts
Move to left edge of current dataCtrl + ←
Move to the bottom of current dataCtrl + ↓
Move to the right edgeCtrl + →
Move to the top edge of the data rangeCtrl + ↑
Display "Find and Replace" dialog boxCtrl + F

2. Data, Functions, Formula bar

What to doShortcuts
AutoSum the numbersAlt + =
Select the current data or entire worksheetCtrl + A
Recognize patterns and Flash Fill columnsCtrl + E
Open the Microsoft Visual Basic for ApplicationsAlt + F11

3. Formatting Function

What to doShortcuts
Copy the selected cellsCtrl + C
Copy topmost cell into the cells belowCtrl + D
Enter the current dateCtrl + ;
Enter the current timeCtrl + Shift :
Switch displaying cell values or formulasCtrl + `

4. Function Function

What to doShortcuts
Cycle through absolute and relative referencesF4

5. Ribbon Function

What to doShortcuts
Display "Print" windowCtrl + P

6. Selection Function

What to doShortcuts
Undo the last actionCtrl+Z
Start a new line in the same cellAlt+Enter
Fill selected range with the current entryCtrl + Enter
Extend selection by one cell upShift + ↑
Extend selection by one cell downShift + ↓
Extend selection by one cell leftShift + ←
Extend selection by one cell rightShift + →
Extend selection up to the first nonblank cellCtrl + Shift + ↑
Extend selection down to the last nonblank cellCtrl + Shift + ↓
Extend the selection left to the first nonblank cellCtrl + Shift + ←
Extend selection right to the last nonblank cellCtrl + Shift + →

7. Worksheet Function

What to doShortcuts
Create a new workbookCtrl + N
Save a spreadsheetCtrl + S
Insert a new worksheetShift + F11