Forum home » Delegate support and help forum » Microsoft Excel Training and help » Ranges within Pivot Tables

Ranges within Pivot Tables

ResolvedVersion 2016

Tue 24 Sep 2019, 16:48 Delegate Mike said...

Mike has attended:
Excel Advanced course

Ranges within Pivot Tables

I will be wanting to set up a pivot table for properties that we own looking at construction costs on each, and it will be useful to filter the data by properties which have a minimum floor area. Can you advise the best way I could achieve this?

Thanks,

Mike

Tue 24 Sep 2019, 19:22 Trainer Dennis said...

RE: Ranges within Pivot Tables

Hi Mike

Great question and sorry I couldn't answer it during the session, I had a brain freeze!

Create the Pivot Table

Select the column header arrow Filter drop-down arrow for the column you want to filter. (located next to the column name on the Pivot Table).

There is an option called Value Filters, from here you can select the criteria range you wish to filter by e.g. LESS THAN 300m SQ

Regards

Dennis

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

How to apply the same formatting and data to multiple sheets at the same time in Excel 2010

When you want to format more than one sheet in a worksheet exactly the same way, Ctrl-click the tabs of the sheets you want to group together and they will all turn white. While they are grouped, anything you enter in one sheet gets entered into the others.

After you have done this, remember to click on the tabs to take them out of the group so that you do not accidentally insert data in multiple sheets when you just want to insert data in one.

View all Excel hints and tips

Ranges within Pivot Tables

Ranges within Pivot Tables

RE: Ranges within Pivot Tables

Excel articles

Excel tip:

How to apply the same formatting and data to multiple sheets at the same time in Excel 2010