dashed line after print preview

[hawaiiham2000]

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.

 

[Pete_UK]

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

Hope this helps.

Pete

 

[grizzly6969]

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

 

[Dave Peterson]

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

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

 

[YESHWANT]

hi hawaiiham2000,

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

 

[Mallikarjuna Kaveti]

In 2007, Click the office Button (on the left top corner)
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

 

[Mallikarjuna Kaveti]

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