panarisk.blogg.se

Display a context menu for the selected cell With a field heading selected, press Ctrl + Shift + = (equal sign). With a data or value field selected, press Ctrl + Shift + = (equal sign). Keep pressing F6 until the PivotTable Field List is active. Press the Spacebar to check or uncheck a checkbox.Once you have selected commands in a drop-down menu using arrow keys, you can use Enter and the Spacebar to select and apply options: Press Home to select the first item or End to select the last item in a drop-down menu, the PivotTable Field List or in a list of items. Press the up or down arrow to select the previous or next item in a drop-down menu, the PivotTable Field List or in a list of items. Select the previous or next item in a list

Press Alt + down arrow to display the options for any cell in a pivot table with a drop-down menu (indicated by an arrow and used mainly for filtering). Open the field list for the active cell with a drop-down menu Here are 10 more Excel pivot table shortcuts. Recommended article: 10 Great Excel Navigation Shortcutsĭo you want to learn more about Excel? Check out our virtual classroom or live classroom Excel courses > Since pivot tables are one of the most powerful tools in Microsoft Excel for summarizing data, we've compiled a list of 10 more keyboard shortcuts for pivot table users. Be sure to check out that article if you haven't read it. Save Time with These Excel Pivot Table Keyboard Shortcutsīy Avantix Learning Team | Updated April 8, 2021Īpplies to: Microsoft ® Excel ® 2013, 2016, 2019 and 365 (Windows)Ī while ago, we published 10 Great Excel Pivot Table Shortcuts.