how set cells don't print?

  • Thread starter Thread starter Ian Elliott
  • Start date Start date
I

Ian Elliott

Thanks in advance!
I have some cells where the user inputs filenames and some
data that I don't want printed when the user prints the
worksheet. Is there a way to set certain cells not to
print even thought the whole worksheet is printed?
Thanks
 
Ian,

The whole worksheet is rather large, 16.8 million cells and printing the
entire sheet would take up many many pages (40,000-50,000), and would take a
few days for the job to be completed on a standard laser printer running at
10-15 pages per minute.

Usually people only use a portion of that space for their active work area.
Possibly you could set a print range that does not include the range where
this data is input.

PC
 
You could hide rows or columns so that they won't print. Does the user have to
see that other data at all?

Maybe just File|Print Area|Set Print Area (after you've selected the stuff you
want them to print.)

The user could override it, but they might not even care.
 
Back
Top