Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
thanks.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Block an area of sheet from Printing? | Excel Discussion (Misc queries) | |||
how can i find total width of the columns in a printing area ? | Excel Discussion (Misc queries) | |||
Printing switches focus off proper sheet | Excel Worksheet Functions | |||
Printing - Have to set print area 1 column further than necessary | Excel Discussion (Misc queries) | |||
Naming & renaming a sheet tab | Excel Worksheet Functions |