Wednesday, April 11, 2018

Not able to drag page breaks in Page Break Preview in Excel


Not able to drag page breaks in Page Break Preview in Excel


This problem may occur when the Allow cell drag and drop check box on the Edit tab of the Options dialog box is cleared. 

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.
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.


No comments:

Post a Comment

How to Tell if You Are an Administrator

  How to Tell if You Are an Administrator You will need to have administrative privileges in order to install software or perform certain ot...