drag and drop editing
 

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.

drag and drop editing
 

Sounds strange.

You're sure you have ToolsOptionsEditAllow 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


On Wed, 31 Oct 2007 13:26:01 -0700, mozoha
wrote:

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.

drag and drop editing
 

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" wrote:

Sounds strange.

You're sure you have ToolsOptionsEditAllow 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


On Wed, 31 Oct 2007 13:26:01 -0700, mozoha
wrote:

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.

drag and drop editing
 

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

On Thu, 1 Nov 2007 10:47:00 -0700, mozoha
wrote:


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" wrote:

Sounds strange.

You're sure you have ToolsOptionsEditAllow 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


On Wed, 31 Oct 2007 13:26:01 -0700, mozoha
wrote:

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.