Save Hidden Column Scheme?

Question

Is it possible in Excel 2007 or 2010 to save a hidden column scheme and toggle it on/off?

This would help greatly with a spreadsheet in which I need to keep the columns in a specific order, but only need to print certain ones for distribution.

Answer 1

You could use Grouping:

• Select any contiguous columns that you want to hide

• Data.Group.Group...(that will create Group buttons at the top of the sheet)

...repeat for other columns

To hide those columns

• Click the [1] in the upper left of the sheet

To UN-hide those columns

• Click: the [2]

OR...Create a Custom View

• Hide the specific columns

• View.Custom_Views.Add

...Name the view (...example: PrintView) and save it.

Now unhide all columns.

To see that view

• View.Custom_Views....Select the view (PrintView)....Click: Show

Does that help?

Answer 2

Would recording two macros be an acceptable solution?

Record one while hiding the columns, and another while unhiding them later.  Then you just run the appropriate macro when you want to switch from 'scenario' to 'scenario".