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.

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!)

Jay wrote:

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.

--

Dave Peterson