Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to paste rows in 2007 without overwriting data?
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to paste rows in 2007 without overwriting data?
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. "GAMEnt User" <GAMEnt wrote in message ... 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to paste rows in 2007 without overwriting data?
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... ----------------------------------------------------------------------- "GAMEnt User" <GAMEnt wrote in message ... 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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to paste rows in 2007 without overwriting data?
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. "Wondering" wrote: 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. "GAMEnt User" <GAMEnt wrote in message ... 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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
repeating data in column to empty cells below without overwriting | Excel Worksheet Functions | |||
Need to add data to a cell without overwriting what's there | New Users to Excel | |||
Overwriting data | Excel Discussion (Misc queries) | |||
Overwriting of linked data | Excel Discussion (Misc queries) | |||
Paste Special Skip Blanks not skipping blanks, but overwriting... | Excel Discussion (Misc queries) |