From the course: Excel: PivotTables in Depth

Unlock the full course today

Join today to access over 24,600 courses taught by industry experts.

Change PivotTables using keyboard shortcuts

Change PivotTables using keyboard shortcuts

From the course: Excel: PivotTables in Depth

Start my 1-month free trial Buy for my team

Change PivotTables using keyboard shortcuts

“

- [Instructor] One very useful capability in Microsoft Excel is controlling the program, especially the ribbon using the keyboard rather than the mouse. And in this movie, I will show you how to do that as related to pivot tables, my sample file is 08_04_Keyboard, and you can find it in the Chapter 8 folder of the exercise files collection. On sheet 1 of this workbook, I have a pivot table, and at present, cell B7 is the active cell. So I see the Pivot Table, Analyze and Design Contextual Tabs on the ribbon, and also the Pivot Table Fields task pane on the right. If I were to use the arrow keys to move off of the pivot table, then anything specific to a pivot table disappears. And then if I use the left arrow key to move back, then we get them back on the interface. To activate the ribbon using keyboard commands, press and release the alt key. A series of key caps appears and that allows you to access each of the ribbon items and also the quick access toolbar that are displayed using…

Contents