In 2007, Click the office Button (on the left top corner)
Excel Options Advanced (Scroll down to) Display Options for this Worksheet (uncheck) Show Page breaks

Note: untill you check the "Show Page breaks" you will not be able to see the dashed lines for that specific sheet.

Thanks for your post
Malli

On Thursday, March 04, 2010 7:41 PM hawaiiham2000 wrote:

Does anyone know how to clear the dashed line that appears where the page
breaks after you click Print Preview and then close Print Preview and go back
to Normal View?

Thanks.


On Thursday, March 04, 2010 8:16 PM Pete_UK wrote:

Save the file, close it, then open it again if it is really distracting
for you.

Hope this helps.

Pete

back


On Thursday, March 04, 2010 8:39 PM grizzly6969 wrote:

go to Tools --- Options --- Page Break and remove check mark
--
grizz


"hawaiiham2000" wrote:


On Thursday, March 04, 2010 8:42 PM Dave Peterson wrote:

In xl2003 menus:
tools|options|View tab|uncheck "page breaks"

I am sure that xl2007 has it somewhere in the "excel options" area.

hawaiiham2000 wrote:

--

Dave Peterson


On Friday, March 05, 2010 7:08 AM YESHWANT wrote:

hi hawaiiham2000,

it is not dashed line but it is margin line. while in print preview, click
on margins, and the line will disappear.


--
learn - n - enjoy
-----------------------------------
click yes below, if it works for you


"hawaiiham2000" wrote:

In 2007, Click the office Button (on the left top corner)
.... Excel Options ... Advanced ... (Scroll down to) Display Options for this Worksheet ... (uncheck) Show Page breaks

Note: untill you check the "Show Page breaks" you will not be able to see the dashed lines for that specific sheet.

Thanks for your post
Malli