Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
lbbss
 
Posts: n/a
Default 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   Report Post  
Randy L
 
Posts: n/a
Default

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   Report Post  
Randy L
 
Posts: n/a
Default

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   Report Post  
Dave Peterson
 
Posts: n/a
Default

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   Report Post  
lbbss
 
Posts: n/a
Default

thanks.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Block an area of sheet from Printing? lbbss Excel Discussion (Misc queries) 4 June 8th 05 07:21 PM
how can i find total width of the columns in a printing area ? EXCELL COLUMN WIDTH Excel Discussion (Misc queries) 1 May 24th 05 11:35 PM
Printing switches focus off proper sheet Abi Excel Worksheet Functions 1 January 26th 05 07:42 PM
Printing - Have to set print area 1 column further than necessary STUART BISSET Excel Discussion (Misc queries) 0 January 24th 05 07:59 PM
Naming & renaming a sheet tab Cgbilliar Excel Worksheet Functions 1 November 7th 04 05:57 PM


All times are GMT +1. The time now is 06:38 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"