Formulas and Functions – Microsoft Excel Shortcuts
200 Excel Shortcuts for PC and Mac
So you think you’re fancy, huh? Just because you know how to copy and paste without the click of the mouse in Excel. Well, get ready to be even fancier (and more productive) because we’ve curated 200 of the best Excel keyboard shortcuts.
Formulas and Functions
These shortcuts can help advanced Excel users and even beginners build formulas and use functions quickly to create spreadsheet magic like a pro.
| Shortcut | Windows | Mac |
|---|---|---|
| Toggle relative and absolute references Cycles through all variations of absolute (locked) and relative (unlocked) cell references in a formula. | F4 | ⌘ T |
| Open Insert Function dialog If you are new to Excel, this shortcut will be quite useful to you. It opens the Insert Function dialog to help you build a formula using Excel’s built in functions. | Shift F3 | Fn Shift F3 |
| Autosum all selected cells Autosums numeric values in adjacent contiguous range of cells (rows or columns). If no numeric values exist in adjacent cells, this shortcut simply inserts the ‘SUM()’ function. | Alt = | ⌘ Shift T |
| Toggle cell formulas Makes formulas visible in the cells where they exist instead of the value. | Ctrl ' | Control ' |
| Insert the function arguments into your current formula Once you have added a function name (I.E. "SUM") to your cell, this shortcut will insert closed parenthesis ready to be filled with the required information needed to execute. | Ctrl Shift A | Control Shift A |
| Enter an array formula Once you have added a function name (I.E. "SUM") to your cell, this shortcut will insert closed brackets ready to be filled with the required information needed to execute. This is used to create array functions which can perform one or more calculations at once. For more information on array functions, see this Microsoft guide: http://bit.ly/1QYqMQP. | Ctrl Shift Enter | Control Shift Enter |
| Calculate all worksheets This shortcut can be used to activate all formulas in each worksheet tab on your overall Excel spreadsheet. | F9 | Fn F9 |
| Calculate only active worksheet This shortcut can be used to activate all formulas in your currently selected. worksheet tab. | Shift F9 | Fn Shift F9 |
| Evaluate formula If you are interested in getting a deeper understanding of how Excel functions work and how calculations are made, this shortcut can help. Implement this shortcut when working with a formula, and Excel will break it down for you. | F9 | Fn F9 |
| Hide or Show the formula bar This shortcut hides and shows the formula bar at the top of your Excel spreadsheet based on your viewing preferences. | Ctrl Shift U | Control Shift U |
| Open name manager (Windows)/Define name (Mac) dialog In Windows, this shortcut opens the Name Manger where you can add, edit and delete Named Ranges. It opens the Define Name dialog in the Mac version of Excel. | Ctrl F3 | Fn C P |
| Open name manager for columns/rows Opens the Create Names from Selection Dialog allowing you to name ranges based on columns or rows. | Ctrl Shift F3 | Fn Control Shift F3 |
| Paste name into formula With a previously defined name saved to your clipboard, this shortcut allows you to efficiently add it to various formulas. This is available as a shortcut on PCs only, but on a Mac the alternative is to go to Insert --> Name --> Paste. | F3 | |
| Accept autocomplete function The autocomplete menu shows various suggestions you can choose when working with functions. This shortcut is quite useful when you the first autocomplete option is the one you would like to implement. | Tab | Shift Tab |