copying with draging the mouse

[pumba1991]

earlier I used to drage the mouse to copy the formulae, formats, etc. But now from last week, I am unable to copy with drag ! Then I need to copy & paste
What is the solution?

 

[CWatts]

Are you referring to this?

 

[SteveInAus]

Its possible that one of your settings has been changed

Click on the Office button, (top left of Excel)
At the bottom of the Dialog box, click Excel Options
From that List select Advanced
Look for the option that reads:

"Enable Fill handle and cell drag-and-drop"

Make sure it is ticked

Also make sure "Alert before overwriting cells" is ticked

 

[pumba1991]

Got the solution, somehow the option was changed in Advacned option!

 

[pumba1991]

Thanks Steve, for the help & the warning as well !