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
How do I remove page breaks (edge of pages)from Excel? 2
dashed line after print preview 4
How to remove dashed page lines after using print preview 1
Page margins on Page break preview 1
How to remove page break lines in normal view? 5
Page Break Preview 1
How can I remove a verticle page break that is a dashed line. 2

Top