Block an area of sheet from Printing?
 

I often accidentally print entire sheet instead of just the first page. I
only the first page to ever be printed. Is there a way to block the rest
of the excel sheet from printing? thanks

You can highlight the cells by clicking the upper left cell and drag to the
lower-right cell. Go to FileSet Print Area. The highlighted section will
be the area that prints.

"lbbss" wrote:

I often accidentally print entire sheet instead of just the first page. I
only the first page to ever be printed. Is there a way to block the rest
of the excel sheet from printing? thanks

What I posted above is how to select only what you want to print, not what
you don't want to print. This will still do what you want, but by activating
only the cells you DO want to print, as opposed to the sells you DON'T want
to print.

HTH

"lbbss" wrote:

I often accidentally print entire sheet instead of just the first page. I
only the first page to ever be printed. Is there a way to block the rest
of the excel sheet from printing? thanks

Maybe you could record a macro that prints just the first page of the active
worksheet.

Then use that whenever you want to print just a single page.

lbbss wrote:

I often accidentally print entire sheet instead of just the first page. I
only the first page to ever be printed. Is there a way to block the rest
of the excel sheet from printing? thanks

--

Dave Peterson

thanks.