| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get Rid of Dotted Lines
After I print my worksheet, dotted lines appear on it. How can I get
rid of these, either by VBA or some ordinary Excel feature? TIA, James |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Get Rid of Dotted Lines
Tools | Options | [View] tab - uncheck the box next to "Page breaks".
"Zone" wrote: After I print my worksheet, dotted lines appear on it. How can I get rid of these, either by VBA or some ordinary Excel feature? TIA, James |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Get Rid of Dotted Lines
Hi Zone,
The dotted lines you're referring to are probably there to show which cells fit within the margins for each page. You get the same effect if you do a print preview. To get rid of these lines, simply close & reopen the file. Cheers -- macropod [MVP - Microsoft Word] "Zone" wrote in message ps.com... After I print my worksheet, dotted lines appear on it. How can I get rid of these, either by VBA or some ordinary Excel feature? TIA, James |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Get Rid of Dotted Lines
Or significanlty easier do what the existing answer suggested:
Tools | Options | [View] tab - uncheck the box next to "Page breaks". -- Regards, Tom Ogilvy "macropod" wrote in message ... Hi Zone, The dotted lines you're referring to are probably there to show which cells fit within the margins for each page. You get the same effect if you do a print preview. To get rid of these lines, simply close & reopen the file. Cheers -- macropod [MVP - Microsoft Word] "Zone" wrote in message ps.com... After I print my worksheet, dotted lines appear on it. How can I get rid of these, either by VBA or some ordinary Excel feature? TIA, James |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Get Rid of Dotted Lines
Hi Tom,
Tools | Options | View & uncheck 'Page breaks'. Of course! Forgot about that one. Cheers -- macropod [MVP - Microsoft Word] "Tom Ogilvy" wrote in message ... Or significanlty easier do what the existing answer suggested: Tools | Options | [View] tab - uncheck the box next to "Page breaks". -- Regards, Tom Ogilvy "macropod" wrote in message ... Hi Zone, The dotted lines you're referring to are probably there to show which cells fit within the margins for each page. You get the same effect if you do a print preview. To get rid of these lines, simply close & reopen the file. Cheers -- macropod [MVP - Microsoft Word] "Zone" wrote in message ps.com... After I print my worksheet, dotted lines appear on it. How can I get rid of these, either by VBA or some ordinary Excel feature? TIA, James |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Get Rid of Dotted Lines
Thank you, Tom. That did the trick. James
Tom Ogilvy wrote: Or significanlty easier do what the existing answer suggested: Tools | Options | [View] tab - uncheck the box next to "Page breaks". -- Regards, Tom Ogilvy "macropod" wrote in message ... Hi Zone, The dotted lines you're referring to are probably there to show which cells fit within the margins for each page. You get the same effect if you do a print preview. To get rid of these lines, simply close & reopen the file. Cheers -- macropod [MVP - Microsoft Word] "Zone" wrote in message ps.com... After I print my worksheet, dotted lines appear on it. How can I get rid of these, either by VBA or some ordinary Excel feature? TIA, James |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| dotted blue lines in a cell | Excel Discussion (Misc queries) | |||
| Dotted lines for projections in graph | Excel Worksheet Functions | |||
| dotted lines around print area | Excel Discussion (Misc queries) | |||
| Dotted lines in Excel | Excel Discussion (Misc queries) | |||
| Print Preview Dotted Lines | Excel Discussion (Misc queries) | |||
Hybrid Mode
