Copy and paste in Excel

Topic

New Reply

Is the only way to copy and paste a row in excel to create a new row, cut the old row, paste the old row into the space just created for the new row, adn then go back to the now blank old row, select it, and delete it? Is there a way to cut a row and make it disappear and make everything shift upward and then paste a row and make everything shift downward without having to create a new row and then delete the old row after cutting it?

Reply | Quote

Replies

Put your cursor anywhere in the row, press & hold Shift down. Then drag the row (up or down) so it ends in the new location. HTH

Reply | Quote

If you don’t want to use the keyboard, you can also right-click the row, then select “Cut”, then right-click the destination row (this row and the ones below will move down) and select “Insert cut cells”.

Reply | Quote

Malcolm: that doesn’t work for me in Excel 2003. It just highlights all of the rows up to the row that I want as a destination row.

Stephane: that causes the row that I cut to be cut, leaving a row of empty cells, and then replaces the contents of the row above which I want to paste, causing that row to lose its data, rather than shifting everythign down one row.

Regards,

JMT

Reply | Quote

Stephane: that causes the row that I cut to be cut, leaving a row of empty cells, and then replaces the contents of the row above which I want to paste, causing that row to lose its data, rather than shifting everythign down one row.

It seems that you have used the plain “Paste” menu option instead of “Insert cut cells”.

Reply | Quote

In order to use Malcolm’s method, you need to click on the border of the selected cells in order to drag them to the new location.

Reply | Quote

Mbarron: it worked!

Reply | Quote