+ Reply to Thread
Results 1 to 8 of 8

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

  1. #1
    btaft
    Guest

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

    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?

  2. #2
    Debra Dalgleish
    Guest

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

    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


  3. #3
    Forum Contributor
    Join Date
    03-23-2006
    Location
    Vancouver
    Posts
    114

    Scaling enabled?

    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.

  4. #4
    robertestonge
    Guest

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



    "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?


  5. #5
    Gord Dibben
    Guest

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

    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?



  6. #6
    Ragdyer
    Guest

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

    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?

    >



  7. #7
    Registered User
    Join Date
    07-09-2013
    Location
    Chicago, il
    MS-Off Ver
    Excel 2010
    Posts
    1

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

    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.

  8. #8
    Forum Contributor
    Join Date
    01-18-2010
    Location
    Bentley, NM
    MS-Off Ver
    Excel 2010
    Posts
    229

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

    Quote Originally Posted by Gord Dibben View Post
    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?
    This was my issue. Thanks for all the replies here.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1