View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default enter data once... copy to multiple cells on other worksheets

Hold down Ctrl and select all tabs you wish to replicate........then type in
one sheet and the same values will be inserted in all the selected
sheets........

Vaya con Dios,
Chuck, CABGx3




"Larry G" wrote:

I am working with a mutliple worksheets in an Excel workbook and I can't
change design. I want to enter data once in worksheet #1 without having to
enter identical data into cells on 12 other worksheets in the same workbook.
It's crunch time... I can't remember how to do this. HELP!!