Cell - Drag feature

**Vinodsralian** · 07-24-2010, 01:52 PM

Hi,

Some unique problem which I had no faced earlier.
I am unable to drag a cell with content (say I want drag a formula or the serial no.). On click/selection of the cell, border of the cell turns to be of a thick border. I am attaching a spreadsheet to show how my cell looks on selection.

Please let me know, how do I correct this(what settings are changed).

Thanks
Vinod

**Mothman** · 07-24-2010, 02:05 PM

Got to Excel options, select advance, and one of the very first options is "enable fill handle cell drag-and drop"

Is that what you are asking?

**Vinodsralian** · 07-24-2010, 02:17 PM

Thanks Mothman, I think I had removed by mistake and didn't know how to enable. Thanks for your quick reply

**royUK** · 07-24-2010, 02:26 PM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save