Index page in Excel

Consider this workbook which contains 100 worksheets.

To go to a desired worksheet, one has to scroll the sheets tab at the bottom, which is time consuming.

One method for making this task easier is to build an index sheet that contains hyperlinks to every worksheet.

Index sheet is generally present as the first sheet of the workbook.

This sheet contains hyperlinks that when clicked will take the user to the corresponding sheet.

This chapter demonstrates how to create a hyperlink to worksheets in the index page.

1.Select a cell which has to be made a hyperlink to some other sheet.

Goto Index

2.Right click and Select Hyperlink as shown below.

excel index page

3."Insert Hyperlink" window appears as shown below:

excel index page

4.select "Place in This Document" from the left pane.

It shows a list of sheets in the workbook.

excel index page

From here, Select the Sheet to be linked.In our case, we have linked "Index" sheet.

The reference cell specifies the cell at the destination sheet, that is to be made active.

 

You can find similar Excel Questions and Answer hereunder

1) How can I add a Footer to my printout with automatic page numbering?

2) How to convert a type of data into another type of date, how to convert a string to an integer or a integer nto a string

3) Find and count instances of a character in a string in Excel

4) What are the main sheet objects and what can the objects do in the sheet in VBA

5) I am not able to use VLOOKUP as the lookup value column is to the right of the column that has the information I need. Is there an alternative option?

6) How to center excel sheet horizontally and verticaly on page in Excel

7) Is there a way to easily shade alternate rows in a data range for improving readability?

8) How to use the scenario manager in Excel

9) how to combine the content of two or more cells in Excel

10) I want to force a page break at a certain row - how can I do that?

 

Here the previous and next chapter