Excel What Column is Filtered
Have you ever been using a large Excel file and wondered which cell am I actually filtering here? Especially if you pick up someone else's file. There might be more than one column filtered and there may be hundreds of columns. You tend to go blind after a brief period of looking for that column with a blue arrow on the filter. Well there is an alternative. What if every time you filtered the worksheet a colour appeared in the cell(s) you were filtering. You could see instantly which column was the source of the filter.
Read MoreFeatured Posts
Recent Posts
Split File into Parts and Save to Directory April 20, 2024
Most Popular Author December 14, 2023
Creating an Excel Dashboard - A Guide with Templates December 8, 2023
Real Estate Excel Dashboard October 11, 2023
Updating Excel Dashboards September 29, 2023
TheSmallman in Another Top Blog Rank April 24, 2023
Project Tracking Dashboard March 25, 2023
Excel Unique Formula September 17, 2022
Horizontal Range to Vertical Range in Excel June 15, 2022
Hiding Rows Quickly with VBA May 20, 2022