Click and drag

  • Thread starter Thread starter KenCanuck
  • Start date Start date
K

KenCanuck

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

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

Similar Threads

Copy Command; Drag and Drop 1
Excel Drag autofill only part of formula 3
click and drag a cell 1
Drag and drop data only?? 2
click & drag not working 2
Excel Excel help with drag and reference cell option 1
Drag formula - ignore blank cells 1
COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2

Back
Top