Possiexx
Jul 19, 2019Copper Contributor
Table Style after Clearing Advanced Filter
Is using the Clear button under Sort & Filter the correct way to display the full Table again after the running of Advanced Filter? I find that the rows are no longer showing in alternate colors. I...
- Jul 19, 2019
Hi
I get your point.
The result of the Advanced filter will never carry the original formatting. If you copy that result to another sheet, you can reapply the same table style if you like.
However, after releasing your filter, the banded color of the rows are messed up.
To fix it:
- Select the whole range
- Go to the Editing Group of the Home Tab >> Clear >> Clear Formats (alternatively hit the shortcut ALT, E, A,F)
NB: You can create a Macro that combines All these steps together.
Hope that helps
Nabil Mourad