| Action | Windows Shortcut | Mac Shortcut | |--------|----------------|--------------| | | F12 | ⌘ + Shift + S | | AutoSum | Alt + = | ⌘ + Shift + T | | Insert current date | Ctrl + ; | ⌘ + ; | | Insert current time | Ctrl + Shift + ; | ⌘ + Shift + ; | | Select entire column | Ctrl + Space | ^ + Space | | Select entire row | Shift + Space | ⇧ + Space | | Insert new row/column | Ctrl + Shift + + | ^ + ⇧ + + | | Delete row/column | Ctrl + - | ^ + - | | Hide row | Ctrl + 9 | ^ + 9 | | Hide column | Ctrl + 0 | ^ + 0 | | Open Format Cells | Ctrl + 1 | ⌘ + 1 | | Apply bold | Ctrl + B | ⌘ + B | | Find & Replace | Ctrl + H | ^ + H | | Go to special | Ctrl + G then Alt + S | ^ + G then ⌘ + S | | Trace precedents | Alt + M + P | ⌘ + Shift + [ | | Evaluate formula | Alt + M + V | ^ + Shift + E | | Name manager | Ctrl + F3 | ^ + F3 | | Create table | Ctrl + T | ^ + T | | Filter dropdown | Ctrl + Shift + L | ^ + ⇧ + L | | Open Power Query | Alt + A + P + T | ⌘ + Shift + P |
This replaces the static PDF. It is a searchable, digital table.
| Action | Shortcut (Win) | Shortcut (Mac) | Why it helps | | :--- | :--- | :--- | :--- | | | Ctrl + 1 | Cmd + 1 | Opens the master menu for borders, colors, and number formats. | | Currency Format | Ctrl + Shift + $ | Ctrl + Shift + $ | Applies standard 2-decimal currency format. | | Percent Format | Ctrl + Shift + % | Ctrl + Shift + % | Converts decimals to percentages instantly. | 1000 excel shortcuts pdf free download
Instead of just generating another static, cluttered list, I have developed a feature concept called This feature transforms the overwhelming "PDF" concept into a personalized, interactive learning tool.
If there is a command you use constantly that doesn't have a shortcut (like "Conditional Formatting"), right-click it and select You can then trigger it by pressing Alt + [Number] based on its position in the top-left bar. LinkedIn·Nicolas Boucherhttps://www.linkedin.com | Action | Windows Shortcut | Mac Shortcut
The best shortcut PDF is the one you create yourself.
This feature acts as a "Smart Filter" for that massive database of shortcuts. | | Currency Format | Ctrl + Shift
Stop scrolling and start jumping. These allow you to handle massive datasets in seconds.