Autofilter on specific columns

  • I have a worksheet with several columns and I'm protecting it from edits, but I want to allow users the ability to filter on only two of the columns, how can I do this? (Auto Filter adds the filter option to all my columns)

  • Re: Autofilter on specific columns


    Please forgive this post, I was able to answer my own question. But for anyone that needs to know how, simply select the two column headers and select Autofilter.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!