View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
CINDY CINDY is offline
external usenet poster
 
Posts: 130
Default SAME INFO ON ALL PAGES AT ONCE

what if is a template and they want to put info in but not want to have the
hassle of doing this


"Kevin B" wrote:

Click the tab of sheet 1 and then while holding down a shift key, click on
sheet 3.

Your text, formatting and formulas will now populate across all 3 worksheets.

Right click on a selected worksheet tab and select UNGROUP when done, or
just click on any unselected workhsheet tab to remove grouping.
--
Kevin Backmann


"Cindy" wrote:

I need the info from page one of the workbook to automatically go to pages 2
& 3 how would i do this