Category: Excel Filter

advanced filter top 5 2

Top 5 Items in Advanced Filter List

When you try to use the Top 10 filter, on a list that already has some filters applied, the results probably won’t be what you want. The Top 10 feature ignores the filters on...

custom view names 3

Show Excel Custom View Name

To save time when printing reports, you can save filter and print setting in Custom Views. Unless, of course, your workbook contains a Named Excel table – you can’t use Custom Views in those...