How to print only selected columns from a worksheet

[Mike C]

Is there a best way to set up a Worksheet so that it will only print
selected columns?

For example, I am using a spreadsheet to allow multiple users to enter
data. However, they only need to print six of the 52 columns in which
they are entering data. The columns are NOT adjacent to one another.

Any suggestions would be appreciated.

 

[MartinW]

Hi Mike,

One way is to hide the other columns before you print.

You could also record a macro to do this for you and maybe
a second macro to unhide after you print.

HTH
Martin