Today while working with Excel.. I was trying to drag and auto fill serial number. but it didn't work..
That plus sign wasn't coming when I select 2-3 cells so after searching on net I found following solution.
1. Click the Microsoft Office Button Button image, and then click Excel Options.
2. In the Advanced category, under Editing options, select or clear the Enable fill handle and cell drag-and-drop check box to turn drag-and-drop editing on or off.
Note To help prevent replacing existing data when you drag the fill handle, make sure that the Alert before overwriting cells check box is selected. If you do not want Excel to display a message about overwriting non-blank cells, you can clear this check box.
Hope it helps.
No comments:
Post a Comment