Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy once paste multiple places
excel 2007
how can you copy a row then paste this row into multiple places? TIA |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy once paste multiple places
Right-click on the row number of the row you want to copy and select Copy.
Click on the row number of the first row where you want to paste it Ctrl+click on the row number of the next row where you want to paste it Continue to Ctrl+click on the row numbers of the rows where you want to paste it until all the rows where you want to paste it are highlighted. Release Ctrl. Right-click on the row number of one of the highlighted rows and select Paste James "raulavi" wrote in message ... excel 2007 how can you copy a row then paste this row into multiple places? TIA |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy once paste multiple places
that works good. thanks
How about inserting the copied row to those places. any idea? "Zone" wrote: Right-click on the row number of the row you want to copy and select Copy. Click on the row number of the first row where you want to paste it Ctrl+click on the row number of the next row where you want to paste it Continue to Ctrl+click on the row numbers of the rows where you want to paste it until all the rows where you want to paste it are highlighted. Release Ctrl. Right-click on the row number of one of the highlighted rows and select Paste James "raulavi" wrote in message ... excel 2007 how can you copy a row then paste this row into multiple places? TIA |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy once paste multiple places
As far as I know, when you do copy then Insert, you have to do one row at a
time. "raulavi" wrote in message ... that works good. thanks How about inserting the copied row to those places. any idea? "Zone" wrote: Right-click on the row number of the row you want to copy and select Copy. Click on the row number of the first row where you want to paste it Ctrl+click on the row number of the next row where you want to paste it Continue to Ctrl+click on the row numbers of the rows where you want to paste it until all the rows where you want to paste it are highlighted. Release Ctrl. Right-click on the row number of one of the highlighted rows and select Paste James "raulavi" wrote in message ... excel 2007 how can you copy a row then paste this row into multiple places? TIA |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy once paste multiple places
Hi - I have the same need - is there a macro to copy and insert a row into
multiple locations, say every 9th row, insert the copied one? "Zone" wrote: As far as I know, when you do copy then Insert, you have to do one row at a time. "raulavi" wrote in message ... that works good. thanks How about inserting the copied row to those places. any idea? "Zone" wrote: Right-click on the row number of the row you want to copy and select Copy. Click on the row number of the first row where you want to paste it Ctrl+click on the row number of the next row where you want to paste it Continue to Ctrl+click on the row numbers of the rows where you want to paste it until all the rows where you want to paste it are highlighted. Release Ctrl. Right-click on the row number of one of the highlighted rows and select Paste James "raulavi" wrote in message ... excel 2007 how can you copy a row then paste this row into multiple places? TIA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Fit info into a no. of places (insert row, copy & paste) easily | Excel Worksheet Functions | |||
I need to copy & paste multiple lines to another workbook? | Excel Worksheet Functions | |||
copy and paste with multiple selections in Microsoft Excel | Excel Discussion (Misc queries) | |||
How to copy and paste same formula in multiple cells? | Excel Worksheet Functions | |||
Copy & paste in multiple areas using VBA | Excel Discussion (Misc queries) |