drag and drop editing


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.
 
Ad

Advertisements

G

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
 
G

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.
 
Ad

Advertisements

G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top