Excel Shortcuts key Part4

1. To group pivot table items

Alt + Shift + Right arrow

The image below depicts that we have grouped the sales of bookcases and chairs subcategories into Group 1.

2. To ungroup pivot table items

Alt + Shift + Left arrow

3. To hide pivot table items

Ctrl + -

You can see below we have hidden the Chairs, Art, and Label subcategories.

4. To create a pivot chart on the same sheet

Alt + F1

5. To create a pivot chart on a new worksheet

F11