Templates and Backgrounds
 

I created a template for an hourly time card we use at work. I want to set
all the information I've put in there (grid lines, guide words, etc.) as a
background that will not print. I only want to print the subsequent input and
formulated results. The paper I am printing on is a pre-printed form.

How do I put all this information (as formatted) in the background so I see
it on my screen, but not the printed page?

Templates and Backgrounds
 

You could save a picture of the range(SHIFT + EditCopy as Picture) before
entering formulas and data.

Save as a *.jpg in Paint...................you will have to play with sizing

Use that as a FormatSheetBackground. Uncheck show gridlines.

But I wouldn't bother with that scenario.

I would use linking formulas on a second sheet that linked to the cells to
print.

Clear gridlines from that sheet and use it for printing to your pre-printed
form.


Gord Dibben MS Excel MVP

On Fri, 12 Dec 2008 06:36:06 -0800, Johng
wrote:

I created a template for an hourly time card we use at work. I want to set
all the information I've put in there (grid lines, guide words, etc.) as a
background that will not print. I only want to print the subsequent input and
formulated results. The paper I am printing on is a pre-printed form.

How do I put all this information (as formatted) in the background so I see
it on my screen, but not the printed page?