XL: Cannot Drag Page Breaks in Page Break Preview (214691)


The information in this article applies to:

  • Microsoft Excel 2002
  • Microsoft Excel 2000
This article was previously published under Q214691

SYMPTOMS

You are not able to drag page breaks in Page Break Preview, 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.

WORKAROUND

To work around this problem, select the Allow cell drag and drop check box:
  1. On the Tools menu, click Options.
  2. On the Edit tab, click to select the Allow cell drag and drop check box, and click OK.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

REFERENCES

For more information about page breaks, click Microsoft Excel Help on the Help menu, type View page breaks in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
Modification Type:MajorLast Reviewed:5/13/2003
Keywords:kbbug kbnofix KB214691
©2002 Microsoft Corporation. All rights reserved.