Save an hour of work a day with these 5 advanced Excel tricks
Work smarter, not harder. Sign up for our 5-day mini-course to receive must-learn lessons on getting Excel to do your work for you.
- How to create beautiful table formatting instantly...
- Why to rethink the way you do VLOOKUPs...
- Plus, we'll reveal why you shouldn't use PivotTables and what to use instead...
Excel shortcut keys can greatly improve your speed when conducting analysis. But often, it can be hard to remember these hotkeys — especially if you regularly switch between the Mac and PC versions of Excel.
To that end, we've compiled this handy list of all the Excel shortcuts you should know, for both Mac and PC. No platform confusion, no unintelligible symbols — just a clear list of shortcuts to make you faster. Happy Exceling!
Working with files | ||
Function | Windows | Mac |
New file | Ctrl + N | ⌘ + N |
Open | Ctrl + O | ⌘ + O |
Save | Ctrl + S | ⌘ + S |
Save as | Ctrl + Shift + S | ⌘ + Shift + S |
Ctrl + P | ⌘ + P | |
Print preview | Ctrl + F2 | |
Close workbook | Ctrl + W | ⌘ + W |
Close Excel | Ctrl + Q | ⌘ + Q |
Working with data | ||
Function | Windows | Mac |
Copy | Ctrl + C | ⌘ + C |
Cut | Ctrl + X | ⌘ + X |
Paste | Ctrl + V | ⌘ + V |
Paste special | Ctrl + Alt + V | Control + ⌘ + V |
Undo | Ctrl + Z | ⌘ + Z |
Redo | Ctrl + Y | ⌘ + Y |
Find | Ctrl + F | ⌘ + F |
Find previous | Ctrl + Shift + F4 | ⌘ + Shift + G |
Find next | Shift + F4 | ⌘ + G |
Find and replace | Ctrl + H | Control + H |
Moving within a workbook | ||
Function | Windows | Mac |
Move right | ||
Move left | ||
Move up | ||
Move down | ||
Move right to next full cell | Ctrl + | Control + |
Move left to next full cell | Ctrl + | Control + |
Move up to next full cell | Ctrl + | Control + |
Move down to next full cell | Ctrl + | Control + |
Move to beginning of row | Home | Fn + |
Move to last cell | Ctrl + End | Fn + Control + |
Move to first cell | Ctrl + Home | Fn + Control + |
Scroll right one screen | Alt + PgDn | Fn + Option + |
Scroll left one screen | Alt + PgUp | Fn + Option + |
Scroll up one screen | PgUp | Fn + |
Scroll down one screen | PgDn | Fn + |
End mode | End | Fn + |
Selecting cells | ||
Function | Windows | Mac |
Go to cell | Ctrl + G | Control + G |
Select all | Ctrl + A | ⌘ + A |
Select row | Shift + Space | Shift + Space |
Select column | Ctrl + Space | Control + Space |
Select current region | Ctrl + Shift + * | Shift + Control + Space |
Select current array | Ctrl + / | Control + / |
Select all precedents | Ctrl + Shift + { | Control + Shift + { |
Select direct dependents | Ctrl + ] | Control + ] |
Select all dependents | Ctrl + Shift + } | Control + Shift + } |
Select only visible cells | Alt + ; | ⌘ + Shift + Z |
Add cell range to selection | Shift + Click | Shift + Click |
Add one-off cells to selection | Ctrl + Click | ⌘ + Click |
Move active cell right to non-adjacent selection | Ctrl + Alt + | Control + Option + |
Move active cell left to non-adjacent selection | Ctrl + Alt + | Control + Option + |
Move selection one column left | Option + Tab | |
Move selection one column right | Option + Shift + Tab | |
Toggle selection add mode | Shift + F8 | Fn + Shift + F8 |
Clear selection | Esc | Esc |
Expand selection to the right | Shift + | Shift + |
Expand selection to the left | Shift + | Shift + |
Expand selection up | Shift + | Shift + |
Expand selection down | Shift + | Shift + |
Expand selection to last full cell to the right | Ctrl + Shift + | ⌘ + Shift + |
Expand selection to last full cell to the left | Ctrl + Shift + | ⌘ + Shift + |
Expand selection to last full cell up | Ctrl + Shift + | ⌘ + Shift + |
Expand selection to last full cell down | Ctrl + Shift + | ⌘ + Shift + |
Expand selection up full screen | Shift + PgUp | Fn + Shift + |
Expand selection down full screen | Shift + PgDn | Fn + Shift + |
Expand selection to beginning of row | Shift + Home | Fn + Shift + |
Expand selection to first worksheet cell | Ctrl + Shift + Home | Fn + Control + Shift + |
Expand selection to last worksheet cell | Ctrl + Shift + End | Fn + Control + Shift + |
Toggle extend selection mode | F8 | Fn + F8 |
Select only cells with comments | Ctrl + Shift + O | Fn + Control + Shift + O |
Select row differences | Ctrl + \ | Control + \ |
Select column differences | Ctrl + Shift + | | Control + Shift + | |
Select direct precedents | Ctrl + [ | Control + [ |
Working with active cells | ||
Function | Windows | Mac |
Only select active cell | Shift + Backspace | Shift + Delete |
Show active cell | Ctrl + Backspace | ⌘ + Delete |
Move active cell clockwise | Ctrl + . | Control + . |
Move active cell down | Enter | Return |
Move active cell up | Shift + Enter | Shift + Return |
Move active cell right | Tab | Tab |
Move active cell left | Shift + Tab | Shift + Tab |
Editing formulas | ||
Function | Windows | Mac |
Edit active cell | F2 | Control + U |
Cancel entry | Esc | Esc |
Delete to end of line | Ctrl + Delete | Control + Delete |
Delete character in back of cursor | Backspace | Backspace |
Delete character in front of cursor | Delete | Fn + Delete |
New line within cell | Alt + Enter | Control + Option + Return |
Add character to the right to selection | Shift + | Shift + |
Add character to the left to selection | Shift + | Shift + |
Move one word right | Ctrl + | Control + |
Move one word left | Ctrl + | Control + |
Add word to right to selection | Ctrl + Shift + | Control + Shift + |
Add word to left to selection | Ctrl + Shift + | Control + Shift + |
Select from beginning of cell to current position | Shift + Home | Fn + Shift + |
Select from current position to end of cell | Shift + End | Fn + Shift + |
Insert comment | Shift + F2 | Fn + Shift + F2 |
Entering data | ||
Function | Windows | Mac |
Commit and move down | Enter | Return |
Commit and move up | Shift + Enter | Shift + Return |
Commit and move right | Tab | Tab |
Commit and move left | Shift + Tab | Shift + Tab |
Commit and stay in same cell | Ctrl + Enter | Control + Return |
Enter data in multiple cells | Ctrl + Enter | Control + Return |
Insert current date | Ctrl + ; | Control + ; |
Insert current time | Ctrl + Shift + : | Control + Shift + : |
Fill from cell above | Ctrl + D | Control + D |
Fill from cell to left | Ctrl + R | Control + R |
Fill formula from cell above | Ctrl + ' | Control + ' |
Hyperlink | Ctrl + K | ⌘ + K |
Display Autocomplete | Alt + | Option + |
Using the Ribbon | ||
Function | Windows | Mac |
Show / hide Ribbon | Ctrl + F1 | ⌘ + Option + R |
Enter Windows hotkey combination | Alt | |
Help | F1 |
Formatting cells | ||
Function | Windows | Mac |
Open format dialogue | Ctrl + 1 | ⌘ + 1 |
Re-apply format | F4 | Control + Y |
Align center | Alt + H + A + C | ⌘ + E |
Align left | Alt + H + A + L | ⌘ + L |
Align right | Alt + H + A + R | ⌘ + R |
Indent | Alt + H + 6 | Control + Option + Tab |
Un-indent | Alt + H + 5 | Control + Option + Shift + Tab |
Increase font size | Alt + H + FG | ⌘ + Shift + > |
Decrease font size | Alt + H + FK | ⌘ + Shift + < |
Format as general | Ctrl + Shift + ~ | Control + Shift + ~ |
Format as currency | Ctrl + Shift + $ | Control + Shift + $ |
Format as percentage | Ctrl + Shift + % | Control + Shift + % |
Format as scientific | Ctrl + Shift + ^ | Control + Shift + ^ |
Format as date | Ctrl + Shift + # | Control + Shift + # |
Format as time | Ctrl + Shift + @ | Control + Shift + @ |
Format as number | Ctrl + Shift + ! | Control + Shift + ! |
Bold | Ctrl + B | ⌘ + B |
Italic | Ctrl + I | ⌘ + I |
Underline | Ctrl + U | ⌘ + U |
Strikethrough | Ctrl + 5 | ⌘ + Shift + X |
Add shadow | ⌘ + Shift + W | |
Add outline | ⌘ + Shift + D | |
Border all | Ctrl + Shift + & | ⌘ + Option + |
Border right | Alt + R | ⌘ + Option + |
Border left | Alt + L | ⌘ + Option + |
Border top | Alt + T | ⌘ + Option + |
Border bottom | Alt + B | ⌘ + Option + |
Border interior horizontal | Alt + H | |
Border interior vertical | Alt + V | |
Remove borders | Ctrl + Shift + _ | ⌘ + Option + _ |
Calculations | ||
Function | Windows | Mac |
Toggle reference (relative vs. absolute) | F4 | ⌘ + T |
Calculate all sheets | F9 | Fn + F9 |
Calculate only active sheet | Shift + F9 | Fn + Shift + F9 |
Autosum | Alt + = | ⌘ + Shift + T |
Insert function | Shift + F3 | Fn + Shift + F3 |
Show function arguments | Ctrl + Shift + A | Control + Shift + A |
Commit array formula | Ctrl + Shift + Enter | Control + Shift + Return |
Evaluate part of formula | F9 | Fn + F9 |
Toggle formula bar | Ctrl + Shift + U | Control + Shift + U |
Show formula builder | Ctrl + A | Control + A |
Define name | Ctrl + F3 | Control + L |
Create name | Ctrl + Shift + F3 | Control + Shift + F3 |
Paste name into formula | F3 |
Worksheets and workbooks | ||
Function | Windows | Mac |
New worksheet | Shift + F11 | Shift + F11 |
Next worksheet | Ctrl + PgDn | Fn + Control + |
Previous worksheet | Ctrl + PgUp | Fn + Control + |
Next workbook | Ctrl + Tab | Control + Tab |
Previous workbook | Ctrl + Shift + Tab | Control + Shift + Tab |
Next pane | F6 | F6 |
Previous pane | Shift + F6 | Shift + F6 |
Minimize window | Ctrl + F9 | ⌘ + M |
Maximize window | Ctrl + F1 | |
Select multiple worksheets | Shift + Click | Shift + Click |
Select one-off single worksheets | Ctrl + Click | ⌘ + Click |
Rows and columns | ||
Function | Windows | Mac |
Insert rows / columns dialogue | Ctrl + Shift + + | Control + I |
Insert rows | Ctrl + Shift + + | Control + I |
Insert columns | Ctrl + Shift + + | Control + I |
Delete dialog | Ctrl + - | Control + - |
Delete rows | Ctrl + - | Control + - |
Delete columns | Ctrl + - | Control + - |
Delete cells | Ctrl + - | Control + - |
Clear cells | Delete | Fn + Delete |
Group | Alt + Shift + | ⌘ + Shift + K |
Ungroup | Alt + Shift + | ⌘ + Shift + J |
Group dialog | Alt + Shift + | ⌘ + Shift + K |
Ungroup dialog | Alt + Shift + | ⌘ + Shift + J |
Hide columns | Ctrl + | Control + |
Hide rows | Ctrl + 9 | Control + 9 |
Unhide rows | Ctrl + Shift + 9 | Control + Shift + 9 |
Unhide columns | Ctrl + Shift + | Control + Shift + |
Toggle outline symbols | Ctrl + 8 | Control + 8 |
Charts, filters, and pivots | ||
Function | Windows | Mac |
Create chart | Alt + F1 | Fn + Option + F1 |
Create chart (new sheet) | F11 | Fn + F11 |
Autofilter | Ctrl + Shift + L | ⌘ + Shift + F |
Open filters | Alt + | Option + |
Insert table | Ctrl + T | Control + T |
Group pivot table items | Alt + Shift + | ⌘ + Shift + K |
Ungroup pivot table items | Alt + Shift + | ⌘ + Shift + J |
Hide pivot table item | Ctrl + - | Ctrl + - |
Create pivot chart | Alt + F1 | |
Create pivot chart on new sheet | F11 | Fn + F11 |
Pivot table wizard | Alt + D + P | ⌘ + Option + P |
Helper modules | ||
Function | Windows | Mac |
Spell check | F7 | F7 |
Thesaurus | Shift + F7 | Shift + F7 |
VBA editor | Alt + F11 | Fn + Option + F11 |
Macros | Alt + F8 | Fn + Option + F8 |
Hide or show | Ctrl + 6 | Control + 6 |
Duplicate | Ctrl + D | ⌘ + D |
Modify cell style | Alt + ' | ⌘ + Shift + L |
Control menu | Alt + Space | ? |
Shortcut menu | Shift + F1 | Fn + Shift + F1 |
Save an hour of work a day with these 5 advanced Excel tricks
Work smarter, not harder. Sign up for our 5-day mini-course to receive must-learn lessons on getting Excel to do your work for you.
- How to create beautiful table formatting instantly...
- Why to rethink the way you do VLOOKUPs...
- Plus, we'll reveal why you shouldn't use PivotTables and what to use instead...
Comments
As an Excel enthusiast with a deep understanding of the program, I can confidently provide insights into the advanced Excel tricks mentioned in the article. Here's an overview of the various concepts and functions covered:
-
Excel Shortcuts: The article emphasizes the importance of keyboard shortcuts to enhance efficiency. It lists shortcuts for various functions, including creating new files, opening, saving, and printing. It also covers shortcuts for working with data, moving within a workbook, and selecting cells.
-
Working with Files:
- Creating a new file: Ctrl + N (Windows) / ⌘ + N (Mac)
- Opening a file: Ctrl + O / ⌘ + O
- Saving a file: Ctrl + S / ⌘ + S
- Printing: Ctrl + P / ⌘ + P
- Closing a workbook: Ctrl + W / ⌘ + W
- Closing Excel: Ctrl + Q / ⌘ + Q
-
Working with Data:
- Copy, Cut, Paste: Ctrl + C, Ctrl + X, Ctrl + V (Windows) / ⌘ + C, ⌘ + X, ⌘ + V (Mac)
- Undo and Redo: Ctrl + Z, Ctrl + Y (Windows) / ⌘ + Z, ⌘ + Y (Mac)
- Find and Replace: Ctrl + F / ⌘ + F, Ctrl + H / Control + H
-
Moving Within a Workbook:
- Various shortcuts for moving within cells, rows, columns, and the worksheet.
-
Selecting Cells:
- Shortcuts for selecting cells, rows, columns, and specific cell ranges.
- Techniques for expanding selections, toggling selection add mode, and selecting only visible cells.
-
Working with Active Cells:
- Show active cell: Ctrl + Backspace (Windows) / ⌘ + Delete (Mac)
- Move active cell in different directions: Enter, Shift + Enter, Tab, Shift + Tab
-
Editing Formulas:
- Editing active cell: F2 (Windows) / Control + U (Mac)
- Deleting characters, adding new lines, and navigating within a cell.
-
Entering Data:
- Committing and moving in different directions: Enter, Shift + Enter, Tab, Shift + Tab
- Inserting current date and time: Ctrl + ; / Control + ;, Ctrl + Shift + : / Control + Shift + :
-
Using the Ribbon:
- Show/hide Ribbon: Ctrl + F1 / ⌘ + Option + R
-
Formatting Cells:
- Opening format dialogue: Ctrl + 1 / ⌘ + 1
- Various formatting options such as aligning text, changing font size, applying bold/italic/underline, and more.
-
Calculations:
- Toggle reference (relative vs. absolute): F4 / ⌘ + T
- Calculation-related functions and shortcuts.
-
Worksheets and Workbooks:
- Managing worksheets: Adding, navigating, minimizing, and maximizing.
- Selecting multiple worksheets.
-
Rows and Columns:
- Inserting and deleting rows and columns.
- Grouping and ungrouping.
-
Charts, Filters, and Pivots:
- Creating charts and pivot tables.
- Working with filters and creating pivot charts.
-
Helper Modules:
- Spell check, thesaurus, VBA editor, and macros.
- Managing styles, control menu, and shortcut menu.
These concepts align with the goal of saving time and working efficiently in Excel, as highlighted in the article. Understanding and incorporating these advanced tricks can indeed boost productivity for Excel users.