Display columns or rows based on values



I am familiar with the custom views feature in Excel 2007. Is there a way to
cause rows or columns to automatically be hidden or displayed based on values
in row 1 or column A? For example, is there a way to select a custom view and
show only those columns where row 1 = "show this column" as opposed to
selecting each column and hiding it and then saving as a custom view. I have
a spreadsheet with many columns and likely, many custom views and I am
looking for a way to automate this.

Thanks in advance,

Bob Umlas, Excel MVP

It would be a lot easier if I knew that the columns to NOT show were blank.
If that's the case, you can either have a macro do this or manually (pretty
Manually (and you can record this in your personal.xlsm to playback) select
row 1, use Goto/Special, select Blanks, then press ctrl-0.
After a little cleanup, the 1-line macro is:

Rows(1).SpecialCells(xlCellTypeBlanks).EntireColumn.Hidden = True

Bob Umlas
Excel MVP

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