View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tyro[_2_] Tyro[_2_] is offline
external usenet poster
 
Posts: 1,091
Default Type once and the info goes into other cells

Select all 5 worksheets. Press shift, click the leftmost sheet and then
click the rightmost sheet. Or press Ctrl and click on the individual sheets.
Enter the date in a cell on one of them, press enter. The date will be on
all 5 sheets. Then select the sheet you want to work on.

"Pieflyer" wrote in message
...
I'm making a 5 page doc that will be used 2 times a week. I need to put
the
date on each page and would like to type it once on the first page and
then
have it go onto each page in the same place. Thanks,