Results 1 to 3 of 3

Thread: Page Break lines are blocked under Page Break Preview in Microsoft Excel

  1. #1
    Join Date
    Jan 2012
    Posts
    71

    Page Break lines are blocked under Page Break Preview in Microsoft Excel

    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
    Join Date
    Jul 2011
    Posts
    440

    Re: Page Break lines are blocked under Page Break Preview in Microsoft Excel

    Is drag and drop enabled. To check, choose Tools>Options On the Edit tab, add a check mark to Allow cell drag and drop.

  3. #3
    Join Date
    Jul 2011
    Posts
    434

    Re: Page Break lines are blocked under Page Break Preview in Microsoft Excel

    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.

Similar Threads

  1. How to remove manual page break in OpenOffice
    By Baasima in forum Windows Software
    Replies: 1
    Last Post: 17-02-2012, 04:22 PM
  2. Replies: 2
    Last Post: 27-01-2012, 07:59 PM
  3. How to remove Vertical Page Break in Microsoft Excel
    By Lanka Boy in forum MS Office Support
    Replies: 1
    Last Post: 14-01-2012, 05:42 PM
  4. Page Break Preview Problem
    By Jayden in forum Windows Software
    Replies: 2
    Last Post: 31-08-2009, 11:52 PM
  5. Page break between table rows in html
    By Zool in forum Software Development
    Replies: 2
    Last Post: 11-08-2009, 02:38 PM

Tags for this Thread

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
  •  
Page generated in 1,711,635,228.42556 seconds with 17 queries