How to Extend the Range of an Excel Filter
By Ken Burnside
Filtering customer data for your business is properly the realm of a database program, and while Excel isn't a fully featured database, its filters allow you to replicate many of their functions. Setting up Excel filters is simple, and you can nest filter conditions with them to refine your data. Extending the filters to cover a larger range of cells is somewhat hidden in the Excel Ribbon interface, which is a huge time-saver when you've added more rows to the database and don't want to delete and recreate the filters over the existing range.
Select a cell inside the area of the spreadsheet that's already being filtered.
Click on "Advanced Filters" (this may only show up as the word "Advanced.") A dialog box will come up.
Click the radio button for "Filter the list, in place."
Enter the range of cells you want to use for the filtered area in the "List Range" field, and then click "OK."
Ken Burnside has been writing freelance since 1990, contributing to publications as diverse as "Pyramid" and "Training & Simulations Journal." A Microsoft MVP in Excel, he holds a Bachelor of Arts in English from the University of Alaska. He won the Origins Award for Attack Vector: Tactical, a board game about space combat.