Copy a column into many worksheets in a workbook.

[Guest]

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?

 

[Lisa]

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.

 

[JS]

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

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.