Hi

How do I hide a column from being printed. I don't want the column
hidden normally just went it is being printed?

Example
A B C
1 1 1
2 2 2

The print shows only columns A and C

A C
1 1
2 2

Maybe you could use a macro.

Record one when you hide column B, print your worksheet and then unhide column
B.

Click on column B and "Hide"

Print then "Unhide"

Record a macro whilst doing this and then run the macro.

Or look at ViewCustom Views method. Print settings are saved with each Custom
View.


Gord Dibben MS Excel MVP


On 9 Feb 2007 10:05:45 -0800, "Dave" wrote:

Hi

How do I hide a column from being printed. I don't want the column
hidden normally just went it is being printed?

Example
A B C
1 1 1
2 2 2

The print shows only columns A and C

A C
1 1
2 2