#1   Report Post  
Rodney
 
Posts: n/a
Default Print Area.


I set "Print Area" and print,
whereupon I choose "Clear Print Area"
and I suddenly am the recipient of sundry lines
of dashes throughout the sheet.
How may I be rid of these litttle irritations?

I'd guess it somewhere in "Page Setup" but it's a new
vehicle, and I'm learning to change the gears.

Thanks






  #2   Report Post  
David McRitchie
 
Posts: n/a
Default

Hi Rodney,

Tools, Options, View, remove checkmark beside Page breaks

They indicate where the page breaks are, best not to
see them unless that is what you are checking, because it
will slow things down within macros if you are inserting/deleting
rows/columns or changing content that might change page breaks.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Rodney" wrote in message ...

I set "Print Area" and print,
whereupon I choose "Clear Print Area"
and I suddenly am the recipient of sundry lines
of dashes throughout the sheet.
How may I be rid of these litttle irritations?

I'd guess it somewhere in "Page Setup" but it's a new
vehicle, and I'm learning to change the gears.

Thanks








  #3   Report Post  
Rodney
 
Posts: n/a
Default

Ah! wonderful, David.
Thank you very much.


| Hi Rodney,
| Tools, Options, View, remove checkmark beside Page breaks
| They indicate where the page breaks are, best not to
| see them unless that is what you are checking, because it
| will slow things down within macros if you are inserting/deleting
| rows/columns or changing content that might change page breaks.
| ---
| HTH,
| David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
| My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
| Search Page: http://www.mvps.org/dmcritchie/excel/search.htm



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
Emailing print area TexMas Excel Discussion (Misc queries) 1 April 1st 05 04:03 PM
set the print area print multiple tabs veng Excel Discussion (Misc queries) 5 February 12th 05 07:01 PM
How to Dynamically Set Print Area Jerry B Excel Discussion (Misc queries) 2 February 1st 05 11:21 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 05:49 PM.

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"