Opening multisheet workbook in one page

Hello, i have a simple question, i have a workbook with many many worksheets but i would also like it either all data to be updated in a "master" worksheet or even easier to just open it all in 1 page but how?! with gmail i can select open as html document and opens it all at once but i would like a more efficient solution thanks in advance

Hi there,

Without being facetious... if you want all the information on one page, put it all on one page. If it helps, you can set print boundaries very precisely wrt cell borders so that you get the right output from your printer.
If you are trying to edit the same information on many pages, you can link cells simply by =<other cell on other page>.
Alternatively, if you shift+click or ctrl+click the sheet tabs you can select multiple sheets, any changes you then make are reflected in the same references on each selected sheet.

Without knowing more about what you're trying to do I can't really be more helpful.

HTH

Nono listen what i want to do, imagine an events calendar that is being worked on shared folders of a lan, i have hyperlinked (to its corresponding sheet) in the first worksheet all the weeks (aka */*/*-*/*/*) of the year. so one of the workers wants to also be able to see all the worksheets at once. When i was making this excel i sent it over to my gmail, and accidentaly i pressed the "Open as HTML document" when i was dling, then a page comes where all the sheets are being contained in 1 large page. So thats what i want to do but with a way not so stupid as senting it over my gmail account and open it as html document^^

How about creating several new windows and saving the workspace?

That would be inneficient:P

It seems this cant be done maybe if there is a master sheet that everything written on all other sheets is being portraited on the master sheet?

Cant believe what i thought so simple is so hard:S Anyone?