View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
George Gee George Gee is offline
external usenet poster
 
Posts: 109
Default type in one sheet and appear on all sheets

Click on the sheet tab of the first sheet,
hold down the shift key.
This groups the sheets together,
anything typed on the first sheet will appear on all sheets.
To ungroup, right-click the tabs and select 'Ungroup Sheets'.

George Gee



"bigjim" wrote in message
...
Hi,
I have an excel spreadsheet that i use for work and it has 6 different
pages. Some of the pages have the same information as the first page. How
can
i get the info from the first page to appear on all the other pages
without
typing it into every page? I have tried to do the = on the last page and
carry it to the first page and press enter but on the last page all i get
is
#value. Could someone please tell me what i am doing wrong.
thanks Jim.