Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Emailing print area | Excel Discussion (Misc queries) | |||
set the print area print multiple tabs | Excel Discussion (Misc queries) | |||
How to Dynamically Set Print Area | Excel Discussion (Misc queries) | |||
Printing - Have to set print area 1 column further than necessary | Excel Discussion (Misc queries) | |||
Changing print area | Excel Discussion (Misc queries) |