Here is a list of my most-used ALT access keys so far: I haven't used very many of these types of shortcuts, but if I'm doing anything really repetitive it often helps to see if there is an access key sequence that can speed things up. This allows you to use commands like align center ( ALT+ H, A, C) which may not have other keyboard shortcuts defined. Then, press the sequence of keys that show up. In the newer versions of Excel, you can do pretty much anything with the keyboard if you use ALT key shortcuts to access the menu and ribbon options. Shortcuts like CTRL+ Arrow let you quickly move through text and CTRL+ SHIFT+ Arrow lets you quickly select text.Īnother combination that I use all the time to insert new rows is to first select the row with SHIFT+ SpaceBar, then insert a row with CTRL+ SHIFT+ = (or think of it as Ctrl Plus), then copy the row above with CTRL+ D (to copy formulas down). For example, when you are editing text, use a combination of the shortcuts listed on the 3rd row of the bingo sheet. Some of these keyboard shortcuts work best in combinations. If you are using a Mac, you are welcome to use the spreadsheet to modify the list and create your own hotkey bingo sheet with shortcuts for Mac. I've marked these with a ⊞ symbol and bold text (most of them are in the first 3 rows of the bingo sheet).
#Excel keyboard shortcut for filter windows
Many of the shortcuts that you can use in Excel and Google Sheets work as general Windows hotkeys for other programs as well. Cross out or color in the shortcuts when you have mastered them. To help motivate you to learn more shortcuts, print this bingo-style list of shortcut keys and put it next to your computer. Most of these shortcuts will also work in Google Sheets. While not a random or complete list, if you master all of these shortcuts, you will be using about 95% of the shortcuts that I use on a regular basis.
#Excel keyboard shortcut for filter download
Instead, download and print a copy of my keyboard shortcut bingo sheet. Printing out a list of ALL spreadsheet shortcuts would be overwhelming. Using the keyboard efficiently can also help cut down on repetitive stress injuries that result from too much mouse use. More importantly, they make you more productive. Subscribe to get more articles like this oneĭid you find this article helpful? If you would like to receive new articles, join our email list.Keyboard shortcuts can save you a LOT of time. To open the legacy PivotTable and PivotChart Wizard (which contains other options such as Consolidate), press Alt > D > P (Alt then D then P). Open the PivotTable and PivotChart Wizard Press Alt + Shift + left arrow to ungroup selected pivot table items. Press Alt + Shift + right arrow to group selected pivot table items. Select a cell in a pivot table and press F11 to create a pivot chart on a new sheet based on the current pivot table. Select a cell in a pivot table and press Alt + F1 to create a pivot chart on the current worksheet based on the current pivot table. Select a cell in a pivot table and press Ctrl + A or press Ctrl + Shift + * (asterisk). Select an entire pivot table (not including report filters) Select a cell in a pivot table and press Alt > JT > W > T (this is a sequential shortcut so press Alt then JT then W and then T). Select an entire pivot table (including report filters) Select a cell in the pivot table and press Alt + F5. You can normally select a cell in the data set as long as there are no blank rows or columns and Excel will highlight the entire data set. In 2010, you'll need to press Alt > N > V > T. A dialog box will appear with options to create a pivot table. Select the data set and press Alt > N > V (this is a sequential shortcut so press Alt then N then V). Create a pivot table from the selected data The following are 10 useful Excel pivot table shortcuts: 1. Recommended article: 10 More Excel Pivot Table Shortcutsĭo you want to learn more about Excel? Check out our virtual classroom or live classroom Excel courses > Pivot tables are one of the most powerful tools in Microsoft Excel for summarizing data so it's helpful to learn a few shortcuts to work quickly with them. Timesaving Excel Pivot Table Keyboard Shortcutsīy Avantix Learning Team | Updated March 23, 2021Īpplies to: Microsoft ® Excel ® 2010, 2013, 2016, 2019 and 365 (Windows)