View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Ardus Petus
 
Posts: n/a
Default changes to excel worksheet that is paged

If you mean an Excel workbook with 12 worksheets:

Click 1st month's tab.
Keep Shift depressed
Click last month's tab

Now, your worksheets are grouped.
Everything you type in one worksheet is automatically copied to the 11
others.

HTH
--
AP

"carole" a écrit dans
le message de news: ...

Is there a way that I can make changes to an excel worksheet that is
paged into 12 months by changing one month and having changes follow
through to the others?


--
carole
------------------------------------------------------------------------
carole's Profile:
http://www.excelforum.com/member.php...o&userid=34643
View this thread: http://www.excelforum.com/showthread...hreadid=544087