View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
gls858 gls858 is offline
external usenet poster
 
Posts: 209
Default Drag and Drop Rows (not just cells)

Rebecca wrote:
Hi. Is it possible to move a row or rows to other places using drag and drop?

Right now I insert a new (empty) row in the place or places I want to paste,
then I copy the row or rows I want to move, paste it or them in the empty
rows and then go back and delete the rows that have just been copied.

This is quite tedious, indeed. Is there a faster way to move rows, aside
from creating a macro, which I am unable to do? If it is possible, please
explain how to do this in simple English, step by step. Thanks.

Click on the the row/column header to highlight the entire row. Hold
down the shift key and place your cursor in the heading and you should
see a cursor with 4 arrows now just drag the row where you want it. Try
this on a test sheet it can be a bit difficult the first couple of times.

gls858