Advanced Excel Tips
Master Excel Like a Pro
Boost your Excel skills with our free cheat sheet, a quick tutorial, and expert tips!
File Management
| Action | Windows Shortcut |
|---|---|
| New workbook | Ctrl + N |
| Save workbook | Ctrl + S |
| Open workbook | Ctrl + O |
| Close workbook | Ctrl + W |
Formatting
| Action | Windows Shortcut |
|---|---|
| Undo | Ctrl + Z |
| Redo | Ctrl + Y |
| Cut | Ctrl + X |
| Copy | Ctrl + C |
| Paste | Ctrl + V |
| Bold | Ctrl + B |
| Italic | Ctrl + I |
| Underline | Ctrl + U |
| Edit the active cell | F2 |
Rows, Columns & Borders
| Action | Windows Shortcut |
|---|---|
| Highlight cells with comments | Ctrl + Shift + O |
| Delete a row/column | Ctrl + – |
| Hide selected row | Ctrl + 9 |
| Hide selected column | Ctrl + 0 |
Special Commands
| Action | Windows Shortcut |
|---|---|
| Open Format Cells dialog | Ctrl + 1 |
| Spell check | F7 |
| Insert a hyperlink | Ctrl + K |
| Freeze panels | Alt + W + F + F |
Navigation & Selection
| Action | Windows Shortcut |
|---|---|
| Go to cell A1 | Ctrl+Home |
| Go to last used cell | Ctrl+End |
| Select the whole row | Shift+Space |
| Select the entire data region | Ctrl + A |
| Select the whole column | Ctrl + Space |
| Move one cell up, down, left or right | Arrow keys |
| Jump to the edge of data region | Ctrl + Arrow key |
| Select to the last filled cell | Ctrl + Shift+Arrow key |
Pivot Tables & Data Analysis
| Action | Windows Shortcut |
|---|---|
| Insert a PivotTable | Alt + N + V |
| Expand the selected group | Alt + Shift + → |
| Clear all filters | Alt + A + T |
| Delete a Selected Pivot Table | Ctrl + – |
Workbook Navigation
| Action | Windows Shortcut |
|---|---|
| Insert a new sheet | Alt + Shift + F1 |
| Move or copy a worksheet | Alt + E + M |
| Move to the last active cell in a data | Ctrl + Page Down |
| Move to the first active cell in a data | Ctrl + Page Up |
Data Entry & AutoFill
| Action | Windows Shortcut |
|---|---|
| Copy right (Fill right) | Ctrl + R |
| Copy down (Fill down) | Ctrl + D |
| Move to the next cell below | Enter |
| Move the selection one cell to the right | Tab |
| Add a line break within a cell | Alt + Enter |
Short Keys
| Action | Windows Shortcut |
|---|---|
| AutoSum | Alt + = |
| Show all formulas | Ctrl + ~ |
| Recalculate formulas | F9 |
| Open “Insert Function” dialog | Shift + F3 |
Tables & Filters
| Action | Windows Shortcut |
|---|---|
| Convert data to a table | Ctrl + T |
| Apply a filter | Ctrl + Shift + L |
| Sort in ascending order (A-Z) | Alt + H + S + S |
| Sort in descending order (Z-A) | Alt + H + S + O |
Excel Tips & Tricks
Work Smarter, Not Harder!
Excel Tips & Tricks
| Tip | Details |
|---|---|
| Quickly Select All Data | Press Ctrl + A to select all data in the current region. Press it twice to select the entire worksheet. |
| Apply Filters in One Click | Select your data range and press Ctrl + Shift + L to toggle filters on and off. |
| AutoFit Column Width Instantly | Press Alt + H + O + I to AutoFit column width. |
| Tip | Details |
|---|---|
| Flash Fill for Smart Data Entry | Use Ctrl + E to auto-fill a column based on detected patterns. |
| Quickly Remove Duplicates | Select your data range, go to Data → Remove Duplicates, choose columns, and click OK. Always make a backup first. |
| Insert Multiple Rows or Columns Fast | Select the number of rows/columns you want to insert, then press Ctrl + Shift + =. |
Quickly Select All Data
Press
Ctrl + A to select all data in the current region. Press it twice to select the entire worksheet.Apply Filters in One Click
Select your data range and press
Ctrl + Shift + L to toggle filters on and off.AutoFit Column Width Instantly
Press
Alt + H + O + I to AutoFit column width. You can also double-click the boundary between column headers.Flash Fill for Smart Data Entry
Use
Ctrl + E to auto-fill a column based on detected patterns.Quickly Remove Duplicates
Select your data range, go to Data → Remove Duplicates, choose columns, and click OK. Always make a backup first.
Insert Multiple Rows or Columns Fast
Select the number of rows/columns you want to insert, then press
Ctrl + Shift + =.