It might be impossible to commit all the combinations in this guide to memory, but even one or two essential shortcuts can have a massive impact if you use Excel on a regular basis. Used in conjunction with the Keyboard shortcuts can save you hours of time. Master the universal Windows keyboard shortcuts, keyboard tricks for specific programs, and a few other tips to speed up your work. That apply to Windows more broadly, these are powerful time-savers that you’ll wish you knew about sooner. Shortcuts to Help Set Up Your Spreadsheet When you’re just getting started with a new spreadsheet, there are plenty of tasks that can be sped up significantly with the right shortcuts. No matter what you’re making, a few of these should help grease the wheels.

Learn 200+ Excel shortcuts (Mac and PC) with this easily searchable list. Excel Shortcuts List for Mac and PC (Searchable) This App is not compatible with Smartphones and Tablets. Keyboard Shortcuts: Excel for Mac 2011. Keyboard Shortcut. Mac OS X system default is Cmd + Shift + Z but this is taken. Cancel edit or change.

Using CTRL + T — which corresponds to ^ + T on Mac systems — converts a selection of cells into a table, with sortable headers that can be edited at will. CTRL + A or COMMAND + A will typically select the entire spreadsheet, but it will only select cells within a table if you’ve clicked on it before using the shortcut. Games optimized for mac. If you want to create a Graphics are easier to grasp than text and numbers. Charts are a great way to visualize numbers. We show you how to create charts in Microsoft Excel and when to best use what kind. Based on a set of data, highlight everything that you want to be included and use ALT + F1 on Windows or FN +?

+ F1 on a Mac. Using F11 or FN + F11 creates this chart in its own separate sheet. Using filters can be a godsend when working with a large spreadsheet, particularly if you find yourself struggling to In a giant Excel spreadsheet, CTRL+F will only get you so far. Be clever and let formulas do the hard work. Lookup formulas save time and are easy to apply. CTRL + SHIFT + L ( COMMAND + SHIFT + F on OS X) will toggle AutoFilter on and off, allowing you to sort and filter content at a moment’s notice. Finally, there are a few shortcuts worth having on hand when you’re working with formulas.

You can toggle formulas on and off using CTRL + `, or via ^ + ` on Mac systems. F9 — FN + F9 for Apple users — will calculate your worksheets, or will calculate the current worksheet if combined with a SHIFT modifier. You can also use F9 contextually to evaluate part of a formula.

Here’s one combination that’s sure to see some use whenever you add a row of totals to your spreadsheet. Use ALT + = to Autosum the cells you have selected — Mac users can execute the same functionality be pressing COMMAND + SHIFT + T. Navigational Shortcuts When you’re working with a large Excel document, it can sometimes be a fiddly and time-consuming process just to navigate to the data you need. Learn these shortcuts by heart, and you’ll be whipping around your spreadsheet at a mile a minute. If you find yourself losing the active cell, worry not — you can navigate to it instantly by pressing CTRL + BACKSPACE on a PC or COMMAND + DEL on a Mac. On a blank document, pressing CTRL + an arrow key will simply take you to its outer limits, but on a populated spreadsheet it’s much more useful. Instead, it will take you to the edge of your data in the stipulated direction, which makes it a handy way of finding the last row or column in a particular table.

On a Mac, the command is ^ + an arrow key. Once you’ve found the cell you’re looking to work on, you can of course double-click it to start making edits. However, there’s a keyboard shortcut available too; simply press F2 with the desired cell selected to start editing immediately — on a Mac, you’ll need to hit ^ + U. Shift + F2 (or FN + Shift + F2 on a Mac) adds or edits a comment attached to your selection. A few combinations were designed to help with negotiating a document that spans more than one sheet. CTRL + HOME sends you back to cell A1 of the current sheet, while CTRL + PGUP and CTRL + PGDN switch between worksheets.

Shift + F11 adds a new worksheet altogether. On a Mac, the above commands are all a little different; FN + ^ +? Takes you back to cell A1, FN + ^ +?/? Switch between worksheets, and FN + Shift + F11 creates a new worksheet. If you’re ever in a position where you think better of something you’ve just entered into a cell, a quick tap of ESC is all you need to remove it. Input-Related Shortcuts Whether you’re delving deep into data entry, or simply Not as comfortable with Excel as you would like? Start with simple tips for adding formulas and managing data.