anything in Excel...

It's Excel-o-lozy...

Solution to Drag option for Page Beak Preview and Auto fill down” if not working.

www.Excelolozy.com - Drag option with mouse doesn't work sometimes in Excel for the following cases:

  • Page Break Preview margin settings
  • Cell Auto Fill by dragging with a “+” (plus) sign at the right bottom corner of a cell


This is called “Fill handle” and “Cell drag and drop”.

This doesn’t work as under “Excel Options” this feature is disabled.

To enable it do as follows:
  • Office Button (Excel 2007) > Excel Options > Advanced
  • > Check third option that reads “Enable fill handle and cell drag-and–drop” and sub-option next to it “Alert before overwriting cells”.

Now enjoy dragging n dropping.

Anything in Excel, be an Excelolozian...
for best MS Excel Tips visit http://www.Excelolozy.com
gotta query??? drop a mail at mail@excelolozy.com