page break preview

S

scott

When I am viewing a worksheet in page break preview, I am able to move the
solid blue line, but not the dashed blue line in Excel 2003. Can anyone
explain to me why the dashed blue line will not move? and what the difference
is between the solid and dashed blue lines are?

thanks for the help as always!
 
G

Gord Dibben

The solid blue lines are manually set pagebreaks

The dotted lines are default pagebreaks set by print settings

i.e. printrange, paper size, margins

I don't know why you cannot move solids but not dotted.

If you couldn't move either I would say Tools>Options>Edit "allow cell drag
and drop" is unchecked.


Gord Dibben MS Excel MVP
 

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

Similar Threads

PRINTING IN FILTERED AREA 4
Cover Page - Use "Next Page Break" rather then Page Break 0
Use "Next Page Break" instead of "Page Break" on the cover page. 0
Converting excel to PDF, single page converts to multiple HELP! 1
dashed line after print preview 6
Page margins on Page break preview 1
How do I remove page breaks (edge of pages)from Excel? 2
How to remove dashed page lines after using print preview 1

Top