A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Copy a column into many worksheets in a workbook.



 
 
Thread Tools Display Modes
  #1  
Old December 9th, 2003, 08:58 PM
Lisa
external usenet poster
 
Posts: n/a
Default 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  
Old December 9th, 2003, 09:13 PM
JS
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:11 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.