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?
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?
Is drag and drop enabled? To check, choose Tools>Options
On the Edit tab, add a check mark to Allow cell drag and drop.
btaft wrote:
> 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?
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html
If the scaling option in File Page Setup is set to
Fit to . . . instead of Adjust to . . .
you won't be able to override the page breaks.
Last edited by CaptainQuattro; 03-28-2006 at 10:14 PM.
"btaft" wrote:
> 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?
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
On Tue, 20 Jun 2006 14:39:02 -0700, robertestonge
<[email protected]> wrote:
>
>
>"btaft" wrote:
>
>> 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?
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" <gorddibbATshawDOTca> wrote in message
news:[email protected]...
> 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
>
> On Tue, 20 Jun 2006 14:39:02 -0700, robertestonge
> <[email protected]> wrote:
>
>>
>>
>>"btaft" wrote:
>>
>>> 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?
>
I had this issue today, only the vertical page break was affected on one page, all other vertical page breaks worked. I discovered it was because I had some fields hidden. Once I un-hid those fields and adjusted the size of some of the fields I was able to get the page breaks to move. This fixed my problem.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks