Copy a column into many worksheets in a workbook.

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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
Click to expand...
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
Click to expand...
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.
 
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 said:
I want to copy 3 columns from a worksheet into 23 other worksheets in the
Click to expand...
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
Click to expand...
the worksheets you want to paste to and then right click paste and it pastes
them all in the same area of each worksheet.
 
Back
Top