Ranges within Pivot Tables

Resolved · High Priority · Version 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.8 % recommend us
	More live stats...

Training information:

Excel tip:

Use shortcut keys to select rows or columns

Most users use the mouse to select rows or columns. It may be more convenient to use keyboard shortcuts to do that.

The shortcut key combination to select an entire row is Shift+Spacebar.

The shortcut key combination to select an entire column is Ctrl+Spacebar.

These are pretty easy to remember as the spacebar looks like a long row (or column if you're looking at it sideways). Remember that Ctrl, beginning with C, selects columns and Shift, by a process of elimination, the rows.

View all Excel hints and tips