Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple Insert Copied Cells routine
Many times I find myself having to repeat the Insert Copied Cells routine,
but once you copy a set of rows, and choose the Insert Copied Cells from Right Click Menu, it cannot be repeated. The work around is to Right Click and select Copy, which is done immediately after the Insert Copied Cells selection is performed, so that the Insert Copied Cells option appears again. There are lots of redundancy in this routine, especially when copying formatted rows throughout the spreadsheet. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple Insert Copied Cells routine
While not an ideal solution, you may find this "usable". Select the
**number** of rows you will need to "Insert Copied Cells" into, right click the selection and click Insert from the popup menu that appeared. This will insert as many rows as you selected and automatically "push down" the existing rows. Now go back and select the rows you want to use for the "Insert Copied Cells" option and copy them. Next, highlight all the rows you inserted, right click the selection and pick Paste from the popup menu. The above steps will duplicate the functionality you are after. -- Rick (MVP - Excel) "Matthew" wrote in message ... Many times I find myself having to repeat the Insert Copied Cells routine, but once you copy a set of rows, and choose the Insert Copied Cells from Right Click Menu, it cannot be repeated. The work around is to Right Click and select Copy, which is done immediately after the Insert Copied Cells selection is performed, so that the Insert Copied Cells option appears again. There are lots of redundancy in this routine, especially when copying formatted rows throughout the spreadsheet. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I insert a copied the row to multiple places in Excel? | Excel Discussion (Misc queries) | |||
Insert copied cells | Excel Worksheet Functions | |||
Insert Copied Cells? | Excel Discussion (Misc queries) | |||
insert copied cells | Excel Discussion (Misc queries) | |||
How can I get "Insert copied cells..." to not be grayed-out? | Excel Worksheet Functions |