Excel cell drag plus sign not coming

The explains How to fix the problem when excel cell drag function don’t work or plus sign don’t come when you want to drag the cells in Excel 2010 , 2007 or 2003

All we have to do is to enable one checkbox

  • In Excel 2007: Office Button > Excel Options > Advanced > Editing options: Enable fill handle and cell drag-and-drop
  • In Excel 2003 and earlier: Tools > Options > Edit > Allow cell drag and drop
  • In Excel 2010 Go to File > Options > Advanced > Enable file handle and cell drag-and-drop

Want to see more detailed animation ? Visit the link below