Sanjeev Sabhlok's notes on technology, hardware, gardening

Using pivot tables in Excel 2010 and beyond

As usual it has become impossible to use post-2003 version of MS office (in this case Excel).

Pivot tables are a nightmare.

Way out:

Insert ribbon > pivot table

Once you get pivot table tools, pick options

From options go to display

In disply highlight classic


View more posts from this author

Leave a Reply

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