Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
GeorgeF
 
Posts: n/a
Default Can't Clear Print Area

Any suggestions as to why I can't clear the print area of my worksheets? I
get into the sheet, select "Clear Print Area", and then I do a print preview
and it shows a bunch of stuff to be printed. I'm not printing the Workbook,
just the sheet. None of the sheets in the book will clear. (If I select one
cell, and make that the print area, it shows just the one blank cell in print
preview, but then if I choose "Clear Print Area", I'm back to printing a
bunch of stuff.) Thanks
  #2   Report Post  
Anne Troy
 
Posts: n/a
Default

Clearing the print are removes a previously defined print area, it does not
define "no printing". What is it that you want to accomplish?
*******************
~Anne Troy

www.OfficeArticles.com


"GeorgeF" wrote in message
...
Any suggestions as to why I can't clear the print area of my worksheets? I
get into the sheet, select "Clear Print Area", and then I do a print

preview
and it shows a bunch of stuff to be printed. I'm not printing the

Workbook,
just the sheet. None of the sheets in the book will clear. (If I select

one
cell, and make that the print area, it shows just the one blank cell in

print
preview, but then if I choose "Clear Print Area", I'm back to printing a
bunch of stuff.) Thanks



  #3   Report Post  
GeorgeF
 
Posts: n/a
Default

Anne -
Sorry, I was off on the wrong track with this. What I was trying to do is
eliminate printing all of the 40 Worksheets I have in a workbook. What I
needed was to simply select the appropriate sheets, then print active sheets
(with each sheets print area having been set).
Sorry to have wasted your time. Thank you.
George

"Anne Troy" wrote:

Clearing the print are removes a previously defined print area, it does not
define "no printing". What is it that you want to accomplish?
*******************
~Anne Troy

www.OfficeArticles.com


"GeorgeF" wrote in message
...
Any suggestions as to why I can't clear the print area of my worksheets? I
get into the sheet, select "Clear Print Area", and then I do a print

preview
and it shows a bunch of stuff to be printed. I'm not printing the

Workbook,
just the sheet. None of the sheets in the book will clear. (If I select

one
cell, and make that the print area, it shows just the one blank cell in

print
preview, but then if I choose "Clear Print Area", I'm back to printing a
bunch of stuff.) 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
Print Area HT New Users to Excel 2 July 21st 05 06:15 PM
Volatile print area stevepain Excel Discussion (Misc queries) 6 July 20th 05 05:46 PM
set the print area print multiple tabs veng Excel Discussion (Misc queries) 5 February 12th 05 07:01 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
Changing print area Aaron Excel Discussion (Misc queries) 2 January 9th 05 05:58 PM


All times are GMT +1. The time now is 02:55 AM.

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

About Us

"It's about Microsoft Excel"