Hide column based on data value

J

Jay

I use auto-filter to switch a spreadsheet between a terse view and verbose
view. Column B is auto-filtered, and it's either blank or non-blank. Call
it a "tag column." Some column B cells have constants; others, formulas. It
works fine.

Can the same effect be achieved somehow to hide columns rather than rows?
I'd like one row to be a "tag row." Then, I'd like to switch between terse
view and verbose view by hiding columns based on what's in the tag row for
each column. Can you suggest an easy way to do this without VBA?

The "custom views" feature doesn't quite help because groups of columns get
added and removed from time to time and it's inconvenient to update the
custom views each time that happens.

(I have Excel 97.)

Thanks.
 
D

Dave Peterson

If you outlaw both custom view and VBA, I'm gonna bet you don't get a good
answer. (But I've been wrong before.)

(Your post looked lonely and needed a response!)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Display columns or rows based on values 1
Hide columns based on row values 2
Hide and Show Rows based on Cell Value 2
Data Validation on multiple columns 3
Hide Column If Usedrange of Column ISBLANK Follow-up 1
Hide column based on data validation 0
Auto filter for multiple columns 2
Worksheet - various appearances 1

Top