dashed line after print preview

H

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.
 
P

Pete_UK

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

Hope this helps.

Pete
 
D

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.
 
Y

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.
 
M

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
 
M

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top