Printing hidden rows or columns

R

ramona

Is it possible to print hidden columns? My users have a column they do not
want to see on the screen but want it to print out for hand writing in the
column as there are not computers, laptops, or PDAs available at this time.

Thanks for your time.
 
O

Otto Moehrbach

The only way I know to do this is to have a macro run when you want to
print. The macro would unhide the column, print the range, hide the column
again. All this can be done in the background so the user would never see
that column. Post back if you want to pursue this. HTH Otto
 
G

Gord Dibben

Check out View>Custom Views.

One custom view can be the printout view.


Gord Dibben MS Excel MVP
 
Top