Automatically expand rows in an Excel filter

[blairmc125]

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?

[#2]

@blairmc125 

This works best if you convert your data range to a table. (Insert tab of the ribbon > Table).