How to paste rows in 2007 without overwriting data?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In 2003 version of Excel, one could highlight and copy rows from one
worksheet to another. When pasting the rows using the insert rows command,
the number of rows required to accommodate the data would be inserted and the
existing data would move down. This was very handy for a large number of
rows. It appears this capability has been eliminated from the "advanced" 2007
version. At least, I can't find it.
 
I use Excel 2007. When I insert copied rows (right click on the row where I
want to insert the copied rows and select Insert Copied Cells from the
menu), the existing rows move down to accommodate the copied rows. I don't
know how you're pasting with "the insert rows" command. It sounds like
you're just pasting over your rows which will replace the rows with the
copied rows.
 
In Excel 2003, when you paste cells, they overay the cells at the destination. The Context
(right-click) menu has an option to insert the copied cells, but it isn't the default
operation for paste. If you cut instead of copy, then the paste defaults to inserting the
cells at the destination.
--
Regards from Virginia Beach,

Earl Kiosterud
www.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
 
Thank you for this response. It was so easy in 2003 because one could use
the insert rows command, which I had parked on the tool bar. But so long as
there is a way to accomplish the same thing, I guess I'll live with it.

Thanks again.
 
You can do the same thing in Excel 2007. Copy the rows. Where you want to
paste, select the number of rows you want to insert. Then on the ribbon,
Home/Cells/Insert/Insert Sheet Rows. Then paste. Also, when you see Insert
Sheet Rows, you can right click on it and select Add to Quick Access
Toolbar. Then you'll have the same thing you had in Excel 2003. Excel 2007
can do everything Excel 2003 did and more. But it is faster to right click
on the row header where you want to paste and select Insert Copied Cells.
Excel inserts the proper number of rows without your having to select them.
 
Back
Top