LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.newusers
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.



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 12:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"