MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Use Autofilter With A Pivot Table


April 12, 2021 - by Bill Jelen

Use Autofilter With A Pivot Table

Challenge: You’ve created a pivot table to summarize sales by customer. You now want to filter those results to show only the customers with sales between $20,000 and $30,000. The AutoFilter command is grayed out for pivot tables.

Solution: You can fool Excel into turning on the AutoFilter dropdowns by starting your selection one cell to the right of the pivot table headings. In Figure 67, select cell E4. Hold down the Shift key and press the left arrow key four times to select E4:A4.

continue reading »

More Reading


Auto-number Records And Columns In An Excel Database

Auto-number Records And Columns In An Excel Database »

April 9, 2021 - by Bill Jelen


You want to build formulas to automatically serially number records and column headers in a database to which AutoFilter is applied and in which selected columns are hidden.

Get An Array Of Unique Values From A List

Get An Array Of Unique Values From A List »

April 7, 2021 - by Bill Jelen


You want to extract all unique values from a column of text data that may contain several instances of a particular value. A procedure like this is useful when you need to populate a list box or combo box with unique values for user selection.

read more articles »

Featured Products


Excel and the World Wide Web Straight to the Point

February 2021

If you have an Excel workbook that needs to regularly harvest data from a web page, this book is for you. The book covers various methods for getting data from the web, from VBA to Selenium to Power Query.


Excel Insights – A Microsoft MVP Guide to the Best Parts of Excel

January 2020

There are fewer than 100 Excel MVPs worldwide. 24 of them have contributed to this book. Written, edited, reviewed and printed by Excel MVPs, this is practical Excel passion undiluted, with each MVP highlighting some of their favorite topics.


The Absolute Guide to Dashboarding & Reporting with Power BI

March 2019

Learn Power BI Dashboarding Techniques by Watching A Pro!


Continuing Financial Modelling

November 2020

You wait for one decent Financial Modelling book to come out and then two come along at once. This edition is aimed at those who wish to advance their knowledge and expertise in financial modelling by addressing common problems that occur day to day in the world of business / decision analyses, forecasting, and valuations.


see more products »