Creating a index/page of contents

  • Thread starter Thread starter Nikhil
  • Start date Start date
N

Nikhil

I want to create an index page or a page of contents in
worksheet 1.

When a user opens the excel file, only the index page is
displayed (all other worksheets are hidden). This index
page will list various options. When the user clicks on
any option..that particular worksheet would open up..

plz help

Nikhil
 
Nikhil,

On your index page, compile a list of the other sheets in
your worksheet. In turn, highlight each entry in the list,
go to "Insert > Hyperlink", click the "Place in this
Document" icon and create a link to the relevant sheet.

Make sure each data sheet also includes a link back to the
index on each sheet.

Finally select all the sheets other than the Index, then
select "Format > Sheet > Hide"

Cheers, Pete.
 
Finally select all the sheets other than the Index, then
select "Format > Sheet > Hide"
Click to expand...

If you do that, then the hyperlinks will cease to function.

Depending on how savvy your users are, you might consider it sufficient to
hide all sheet tabs (Tools -- Options -- View -- Window Options). If too
many of them will know CTRL+PageUp/PageDown, you'll have to resort to VBA.

Rgds,
Andy
 
Back
Top