Is there a way to set up dropdown filters for only certain columns? Say for example I only want user to be able to filter on columns B, D, and F. (using excel 2000). Thanks
Is there a way to set up dropdown filters for only certain columns? Say for example I only want user to be able to filter on columns B, D, and F. (using excel 2000). Thanks
Hi,
Not that I know of.
You could hide columns C & E which would give you the same visual effect, or move columns C & E to the right of your data and include a blank column between the last column and the (new) C&E columns.
HTH
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks