top of page

A Pivot table tip for you

Writer: Magic Rabbit HatMagic Rabbit Hat

If you aren’t too happy with the layout of your Pivot Table. Here’s an option:

  • Make sure that you’re clicked into the Pivot Table

  • From the Design ribbon, select the Pivot Table Layout from the Layout group ( on the left side).

  • You can choose from Compact view (you’re probably already in it), Outline view (My favorite) or even Tabular view if you want a more layout that may be closer to the look of your original data.


 
 
 

Recent Posts

See All

Get it together.

Here is a quick way to join the contents of 2 cell and display the results in third cell. · Find an empty cell and type the “=” sign. ·...

Comments


Commenting has been turned off.
  • YouTube
  • Twitter
  • Facebook
bottom of page