drag and drop editing

[Guest]

I am using excel 2002 with sp 3 and I can not drag and drop cells for quick
editing. I have found the tools -> options - > window that allows me to
enable drag and drop editing which is selected but the program will not allow
me drag and drop a cell. Currently I have to select a cell-> cut it-> move
cursor to desired cell-> paste.. This process is far too time consuming.

 

[Gord Dibben]

Sounds strange.

You're sure you have Tools>Options>Edit>Allow cell drag and drop enabled?

Do you see the fill handle when you hover the cursor over the bottom right
corner of a cell?

Does a black cross appear to click on?

Can you do a right-click and drag and release to get a menu with "Copy Cells" as
an option?


Gord Dibben MS Excel MVP

 

[Guest]

Double checked the tools ->options menu and drag and drop editing is
enabled. the pointer becomes a black cross when I hover in the bottom right
hand corner of a cell and it will autofill cells. Any time i try to drag a
cell Excel just expands my selection.

 

[Gord Dibben]

That added bit of information leads me to believe you are in Extended mode.

Do you see EXT on the status bar lower right?

Hit F8 to disable.


Gord