Moveing rows

[Dennis Hughes]

I have to move a block of rows in order to have the spreadsheet in the order
I want.

I did a move and paste to move the rows and the existing rows ware
overwritten.

How do I move rows and not have them overwrite existing rows?

Thanks,

Dennis

 

[Peo Sjoblom]

If you do ctrl + x and then select where you want it, then right click and
select insert cut cells
or copy and do it, then after you are sure you got it right delete the
original

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey

 

[Norman Jones]

Hi Dennis,

Try instead:

Select rows to move
Right-click | Cut
Select the destination
Right-click | Insert Cut Cells

 

[KellTainer]

Hi, you should select the entire rows which you want to copy, make sure
the row selection boundary is visible, and then use your mouse to click
the boundary to drag and move it around. if you need to move it to a
different sheet, you could press alt and then drag it over to another
sheet.

 

[Dennis Hughes]

Thanks,

Worked like a champ. The previous cut & paste cost me almost 2 hrs
recreating the file. I didn't notice it until too late.

Dennis

 

[David McRitchie]

Hi Dennis,
This solution would work better, Select the rows to be moved
as a group then hold the SHIFT key and grab the border of
the grouped rows pointer must change to an arrow, and drag to
between the rows you want them moved between.

More information on that and similar things in
http://www.mvps.org/dmcritchie/excel/fillhand.htm

 

[Dennis Hughes]

That is a great way to move rows.

I learned a lot from my question. Thanks to all,

Dennis

Hi Dennis,
This solution would work better, Select the rows to be moved
as a group then hold the SHIFT key and grab the border of
the grouped rows pointer must change to an arrow, and drag to
between the rows you want them moved between.

More information on that and similar things in
http://www.mvps.org/dmcritchie/excel/fillhand.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

I have to move a block of rows in order to have the spreadsheet in the
order
I want.

I did a move and paste to move the rows and the existing rows ware
overwritten.

How do I move rows and not have them overwrite existing rows?

Thanks,

Dennis