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?
Break Preview. Is there some option to turn it on and off?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Debra Dalgleish
Is drag and drop enabled? To check, choose Tools>Options
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.
Fit to . . . instead of Adjust to . . .
you won't be able to override the page breaks.
G
Guest
btaft said: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?
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
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 !
---------------------------------------------------------------------------
<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