drag and drop editing

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
 
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.
 
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
 
Back
Top