I can't move my page breaks in Page Break Preview

G

Guest

I suddenly can't adjust my page breaks in any Excel spreadsheet while in Page
Break Preview. Is there some option to turn it on and off?
 
C

CaptainQuattro

If the scaling opting in File Page Setup is set to

Fit to . . . instead of Adjust to . . .
you won't be able to override the page breaks.
 
G

Gord Dibben

Do you have more than one sheet selected?

If so, you should see [Group] in the title bar.

Right-click on a sheet tab and "ungroup sheets"


Gord Dibben MS Excel MVP
 
R

Ragdyer

Another possible fix:

<Tools> <Options> <Edit> tab,
And *CHECK*
"Allow Cell Drag & Drop".
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
Gord Dibben said:
Do you have more than one sheet selected?

If so, you should see [Group] in the title bar.

Right-click on a sheet tab and "ungroup sheets"


Gord Dibben MS Excel MVP
Click to expand...
 

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

Remove Page Breaks 3
How to remove dashed page lines after using print preview 1
trouble formatting page breaks 1
Removing Page Break Preview from all spreadsheets 1
Remove page breaks 2
page break in Excel 97 2
Excel 2003 SP2 - Insert | Page Break doesn't work 3
Can Excel enter page breaks to always follow a merge cell? 1

Top