You are currently offline, waiting for your internet to reconnect

You are not able to drag page breaks in Page Break Preview in Excel

Support for Office 2003 has ended

Microsoft ended support for Office 2003 on April 8, 2014. This change has affected your software updates and security options. Learn what this means for you and how to stay protected.

This article was previously published under Q214691
SYMPTOMS
You are not able to drag page breaks in Page Break Preview in Microsoft Excel, although you receive a dialog box indicating that you can.
CAUSE
This problem may occur when the Allow cell drag and drop check box on the Edit tab of the Options dialog box is cleared.

Note In Microsoft Office Excel 2007, this problem may occur when the Enable fill handle and cell drag-and-drop check box is cleared.To locate the Enable fill handle and cell drag-and-drop check box, click the Microsoft Office Button, click Excel Options, and then click the Advanced tab.
WORKAROUND
To work around this problem in Microsoft Excel 2000, in Microsoft Excel 2002, and in Microsoft Office Excel 2003, follow these steps:
  1. On the Tools menu, click Options.
  2. On the Edit tab, click to select the Allow cell drag and drop check box, and then click OK.
To work around this problem in Excel 2007, follow these steps:
  1. Click the Microsoft Office Button, click Excel Options, and then click the Advanced tab.
  2. Click to select the Enable fill handle and cell drag-and-drop check box, and then click OK.
STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
XL2000 XL2002 XL2003 XL2007
Properties

Article ID: 214691 - Last Review: 01/02/2007 22:11:04 - Revision: 4.0

Microsoft Office Excel 2007, Microsoft Office Excel 2003, Microsoft Excel 2002 Standard Edition, Microsoft Excel 2000 Standard Edition

  • kbexpertisebeginner kbbug kbnofix KB214691
Feedback
soft.com/c.gif?DI=4050&did=1&t=">