View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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.