Click and drag

How do I make a cell so it can repeatedly be clicked on and dragged over and
over? FOr example I want a row of cells on the right that have 10 different
"values or answers" and I want the user to be able to click on one of those
and drag it into a cell in an adjacent spreadsheet. They may need to drag
one answer several different times so I need those answers able to be dragged
and still be there to be draged again. Hope this makes sense.

Dave
Fri Jul 25 10:19:14 CDT 2008

How about using ctrl-click and drag so that they're copying, not moving.

KenCanuck wrote:
>
> How do I make a cell so it can repeatedly be clicked on and dragged over and
> over? FOr example I want a row of cells on the right that have 10 different
> "values or answers" and I want the user to be able to click on one of those
> and drag it into a cell in an adjacent spreadsheet. They may need to drag
> one answer several different times so I need those answers able to be dragged
> and still be there to be draged again. Hope this makes sense.

--

Dave Peterson

Rick
Fri Jul 25 10:26:32 CDT 2008

If I understand your question correctly, I think using Copy/Paste would be
much easier. Select a cell in your answer section and press Ctrl+C, now go
to any other cell (on that worksheet or any other) and press Ctrl+V... now
go to another cell (again, on that or any other worksheet) and press Ctrl+V
again... you can repeat that as many times as you want (the originally
selected cell that you used Ctrl+C on will remain active for Ctrl+V
keypresses until you press Esc to clear it).

Rick


"KenCanuck" <KenCanuck@discussions.microsoft.com> wrote in message
news:34E89F15-0426-44D4-8E81-37303E8DEABD@microsoft.com...
> How do I make a cell so it can repeatedly be clicked on and dragged over
> and
> over? FOr example I want a row of cells on the right that have 10
> different
> "values or answers" and I want the user to be able to click on one of
> those
> and drag it into a cell in an adjacent spreadsheet. They may need to drag
> one answer several different times so I need those answers able to be
> dragged
> and still be there to be draged again. Hope this makes sense.