ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Multiple worksheets within a workbook (https://www.excelbanter.com/excel-worksheet-functions/84345-multiple-worksheets-within-workbook.html)

mamaw

Multiple worksheets within a workbook
 
I want to set up a workbook with multiple sheets. I would like the document
to open on an index page listing the worksheets the workbook contains. I
also would like to name the worksheets something besides sheet one, sheet
two, etc. I am a new user and am not very experienced but would like to
learn. Can someone help me please? I am using Microsoft Office xp
professional

Tim Whitley

Multiple worksheets within a workbook
 
Opening on the index page would be as simple as saving the file with the
index sheet open. You can right click on the worksheet name to change them.

"mamaw" wrote:

I want to set up a workbook with multiple sheets. I would like the document
to open on an index page listing the worksheets the workbook contains. I
also would like to name the worksheets something besides sheet one, sheet
two, etc. I am a new user and am not very experienced but would like to
learn. Can someone help me please? I am using Microsoft Office xp
professional


Pete_UK

Multiple worksheets within a workbook
 
You could also add hyperlink formulae to your Index page which would
enable you to jump directly to another sheet - particularly useful if
you have a lot of sheets.

Hope this helps.

Pete



All times are GMT +1. The time now is 05:29 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com