Create Pivot Table

Highlight the desired pivot table source data range (including headers), then click the key combo. A version 2007+ pivot table will be created on a new sheet. The pivot will be pre-setup with my favorite features.

Its source will be a dynamic-named-range, meaning its data source will expand or contract based on the filled rows of data.

Be black / white

In tabular form

Have subtotals turned off

Repeated values turned on (if available)

And no non-existing items remembered in filters after refresh.

Leave a Reply

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