How to Group Data in Pivot Tables in Excel 2016

In this HowTech written tutorial, we’re going to show you how to group data in Excel 2016 pivot tables.

Join us on Facebook
Our App

To start, you will first need a pivot table. Go under the Insert Tab and click PivotTable.

Select the area if your cursor wasn’t already in the area and click OK.

Drag and drop the fields to their appropriate positions.

To group data, select the data, right-click it and click Group.

You can also change Group settings on dates for example. Right-click the date and click Group.

You will see more options, choose the ones you want and click OK.

This is a HowTech tutorial, visit our website and watch our videos for more.