Copy & Paste

C

CP

Hi: I have created some cells on a page. I need to have them repeated on
continous pages. Instead of highlighting them and copy & paste on the next
page, is there a way to do this with one command? I need to to repeated on
20 pages. Thanks.
 
S

SVC

If the cells are the same on all the sheets (e.g. A1, B1, C2) and all need
the same data, right click the active sheet tab and Select all. Now enter
the numbers in the appropriate cells on the active worksheet, right click the
sheet tab again and Upgroup sheets. The numbers should now appear on all the
sheets.

If the cells are in various locations on the different sheets, cut and paste
is probably the only solution.
 
S

swatsp0p

Select the range on your original sheet you want to copy and pres
CTRL+C

Click on the first sheet tab in the range you want to copy to. Selec
the first cell of the range you want to paste in. If the sheets t
paste to are in order, while holding down the SHIFT key, click on th
last sheet tab in the range you want to paste to. If they are not i
order, hold down the ALT key and click on each tab desired. (note tha
all of the selected sheet's tabs will change to white)

Press CTRL+V to paste your data. It will now be on all selected sheet
in the range selected on the first sheet.

Good Luck

Bruc
 
C

CP

Hi Bruce:

I should have made it a bit clearer. I'm actually within the same
worksheet. So in instead copy and pasting, then scrolling down to the next
page 20 times and doing a copy & paste I was wondering if there was a faster
way. So if I am to print it the same cells would appear on each of the 20
pages...
 
C

CP

HI:


I should have made it a bit clearer. I'm actually within the same
worksheet. So in instead copy and pasting, then scrolling down to the next
page 20 times and doing a copy & paste I was wondering if there was a faster
way. So if I am to print it the same cells would appear on each of the 20
pages...
 
Top