Forum Discussion
Automatically expand rows in an Excel filter
I have an Excel spreadsheet with 20 filtered lines of data. Works great. As I add more data I soon bump into my last row within my filtered range. How can I automatically expand my filtered range of rows without having to redo the filter range manually?
1 Reply
This works best if you convert your data range to a table. (Insert tab of the ribbon > Table).
