If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#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.
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How can I force a new sheet when duplex printing? | Dave Batten | General Discussion | 0 | May 17th, 2005 08:00 AM |
copy a sheet in same workbook temporary block excel | mircea | Worksheet Functions | 0 | January 22nd, 2005 12:23 PM |
Printing a same label multiple x's on same sheet | babs | Setting Up & Running Reports | 5 | January 18th, 2005 04:41 PM |
How to block word document for printing? | Adam | General Discussions | 2 | July 19th, 2004 06:54 PM |
Printing a solid block | mcp6453 | General Discussion | 3 | May 15th, 2004 08:01 PM |