apply auto filter in in the entire cell of sheet

[Onjslnjps]

Hi,

Can any one help me out how to apply auto filter in the entire cells of sheet with or without centain contents.

Many thanks

 

[Tom Urtis]

If you have a lot of "certain contents" that you want to omit in the filter, maybe you don't need, or cannot even use, AutoFilter as you specified, but Advanced Filter that can accommodate more robust criteria.

Also, I doubt you really meant the entire grid of columns when you said "entire sheet" so if you explain what you want to do exactly, you can get a more relevant answer to your situation.

 

[Peter_SSs]

Welcome to the MrExcel board!

Apart from Tom's points, it may also be helpful if we knew what version of Excel you are using.

 

[ukmikeb]

Thread cross-posted on Excel Forum -

http://www.excelforum.com/excel-general/782564-apply-auto-filter-in-in-the-entire-cell-of-sheet.html

Note forum rules about cross-posting on other forums.

Always quote the link if you have cross-posted on other forums.

You could be wasting members time trying to provide a solution when it may have already been solved on the other forum.