top of page

A Pivot table tip for you

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 on this post isn't available anymore. Contact the site owner for more info.
  • X
  • Youtube
bottom of page