How to paste rows in 2007 without overwriting data?
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.
"GAMEnt User" wrote in message
...
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.
|