software

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 Toolsgt;Options
On the Edit tab, add a check mark to Allow cell drag and drop.

btaft wrote:
gt; I suddenly can't adjust my page breaks in any Excel spreadsheet while in Page
gt; Break Preview. Is there some option to turn it on and off?--
Debra Dalgleish
Excel FAQ, Tips amp; Book List
www.contextures.com/tiptech.html
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.--
CaptainQuattro
------------------------------------------------------------------------
CaptainQuattro's Profile: www.excelforum.com/member.php...oamp;userid=32763
View this thread: www.excelforum.com/showthread...hreadid=526593

quot;btaftquot; wrote:

gt; I suddenly can't adjust my page breaks in any Excel spreadsheet while in Page
gt; 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 quot;ungroup sheetsquot;Gord Dibben MS Excel MVP

On Tue, 20 Jun 2006 14:39:02 -0700, robertestonge
gt; wrote:

gt;
gt;
gt;quot;btaftquot; wrote:
gt;
gt;gt; I suddenly can't adjust my page breaks in any Excel spreadsheet while in Page
gt;gt; Break Preview. Is there some option to turn it on and off?Another possible fix:

lt;Toolsgt; lt;Optionsgt; lt;Editgt; tab,
And *CHECK*
quot;Allow Cell Drag amp; Dropquot;.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
quot;Gord Dibbenquot; lt;gorddibbATshawDOTcagt; wrote in message
...
gt; Do you have more than one sheet selected?
gt;
gt; If so, you should see [Group] in the title bar.
gt;
gt; Right-click on a sheet tab and quot;ungroup sheetsquot;
gt;
gt;
gt; Gord Dibben MS Excel MVP
gt;
gt; On Tue, 20 Jun 2006 14:39:02 -0700, robertestonge
gt; gt; wrote:
gt;
gt;gt;
gt;gt;
gt;gt;quot;btaftquot; wrote:
gt;gt;
gt;gt;gt; I suddenly can't adjust my page breaks in any Excel spreadsheet while in
gt;gt;gt; Page
gt;gt;gt; Break Preview. Is there some option to turn it on and off?
gt;