Thread: Copy & Paste
View Single Post
  #2   Report Post  
SVC
 
Posts: n/a
Default

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.

"CP" wrote:

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.