If I highlight the entire first row and filter it, I shouldn't need to repeat the process every time I add a new column. Is there a way around that? I could run a macro, but that's still an extra step every time I add a new column.
For example, if I have a column named "Types of apples" and I highlight the entire first row and click on Data > Filter, then when I create another column for "Types of oranges," that column should be filtered automatically because I already told Excel I wanted the entire first row filtered.
Version: Excel 365 ProPlus, Version 1750