Type its name in the 'Text to Display' text box and click 'OK.' At this point, your Table of Contents worksheet contains two clickable entries that represent two of your workbook's worksheets.
Click 'Hyperlink,' click 'Place in This Document' and click the next worksheet that sits on the worksheet bar. This hyperlink's name matches the name you typed in the 'Text to Display' text box.Ĭlick cell 'A2' and click 'Insert' again. Click 'OK' and Excel adds a new hyperlink to cell A1 in the Table of Contents worksheet. Click 'Place in This Document' and note that the dialog box displays a list of the workbook's worksheet names.Ĭlick the worksheet that sits to the right of your new Table of Contents worksheet and type that worksheet's name in the 'Text to Display' text box. Click 'Hyperlink' to open the Insert Hyperlink dialog box. This tab becomes your Table of Contents worksheet.Ĭlick the Table of Contents worksheet's 'A1' cell to select it and then click 'Insert' from the ribbon. Right-click the new worksheet tab, select 'Rename' and type 'Table of Contents.' Click the tab and drag it to the left so that it appears in front of the other tabs.
