If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Copy a column into many worksheets in a workbook.
Click on the A B C or what ever colums your data is in (by
holding down the left mouse over all 3) Ctrl + c to copy and just Ctrl + v to paste into your other worksheets. It should keep pasting and keep the current format (master datasheet)for all pastes. -----Original Message----- I want to copy 3 columns from a worksheet into 23 other worksheets in the same workbook without having to click on each column of the separate worksheets to paste it. In Lotus 1-2-3 you can hold down cntrl and shift page down to get through the worksheets you want to paste to and then right click paste and it pastes them all in the same area of each worksheet. Does Excel have a similar command? . |
#2
|
|||
|
|||
Copy a column into many worksheets in a workbook.
Select the columns to copy, click copy and then select the first sheet to
copy to, hold shift down and select the last sheet to copy to (this will select all the sheets in between), click paste and the columns will be copied to all sheets "Merv" wrote in message ... I want to copy 3 columns from a worksheet into 23 other worksheets in the same workbook without having to click on each column of the separate worksheets to paste it. In Lotus 1-2-3 you can hold down cntrl and shift page down to get through the worksheets you want to paste to and then right click paste and it pastes them all in the same area of each worksheet. Does Excel have a similar command? |
Thread Tools | |
Display Modes | |
|
|