Home » Our Blog » Pivot Tables

Tag: Pivot Tables

Excel – How do I change a Pivot Table back to the classic (version 2003 and earlier) display?

sharyn bainesLearn how to change a Pivot Table back to the classic display of version 2003 and earlier.

If you were familiar with Pivot tables in Excel versions prior to Excel 2007 you will be very used to the classic display of working with the blue lines of the Pivot Table and the ability to drag and drop data right on to the Pivot Table.

In Excel 2007, 2010, 2013 and 2016 Pivot Tables are now quite different. The blue lines are gone, along with the wonderful drag-and-drop feature. Read more

Excel – Group dates by month in a Pivot Table

sharyn-bainesTo group dates by month in a Pivot Table is easy when you know how. Unfortunately, displaying date values in a Pivot Table can produce unexpected results.

For example, in the Pivot Table below I have added a Date field to the Column area of my Pivot Table.  Every date in the underlying data table is different, therefore resulting in a column for every day and a very large Pivot Table. Read more