• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Identify filtered column

N

neeraj2050

Member
Greetings!!

In excel how can we identify the column into which Filter is applied. I have data into several columns and I have to manually identify that column

Regards
Neeraj Kumar Agarwal
 
neeraj2050
Did You asked 'In excel how can we identify the column into which Filter is applied. I have data into several columns and I have to manually identify that column'?
Because, I don't have You file, I did a sample file.
There is few columns which can filter too.
While You will do filtering, those 'headers' would change colors.
Green would show which column use filter.
> and without VBA ...
You can continue looking those 'filter'-mark as normally or
You could change ex filtered column's 'header'-cell's color manually as in my sample with VBA.
 
vletm said:
neeraj2050
If You would like to identify with colors test this...
Click to expand...
Very helpful. Of note, in the sample file, when you remove all filters the last column you remove the filter from remains highlighted. This is enough to get me started i should be able to figure the rest out on my own. I really appreciate the head start on this particular issue!
 
You must log in or register to reply here.
Back
Top