PIVOT TABLE SHORTCUT KEYS

  • To group Pivot table items – Alt + Shift + Right Arrow
  • To Ungroup Pivot table items – Alt + Shift + Left Arrow
  • To hide Pivot table items – Ctrl + –
  • To create a Pivot chart on the same sheet – Alt + F1
  • To create a Pivot chart on the new worksheet – F11

Leave a comment

Your email address will not be published. Required fields are marked *