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

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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.
 
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
 
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
Page Break Preview 4
Page Break Preview 1
Removing Page Break Preview from all spreadsheets 1
Not all pages printing in Excel 2007 1
How to remove dashed page lines after using print preview 1
Page break dosen't break 4
Page Break Preview 7

Back
Top