The best way to organize your workbook using hyperlinks
Excel
2016
For some workbooks with a large number of sheets or to highlighting some important data, it is necessary to
create hyperlinks to another cell in the same spreadsheet.
To do that, follow the next steps:
1. Right-click on the cell where you would like to insert a hyperlink and then select Hyperlink... from the popup menu:
2. In the Insert Hyperlink dialog box:
- Click on the Place in this Document button on the left.
- In the field Text to display, enter the text that will be displayed in the hyperlink.
- Enter the cell reference that the hyperlink points to (by default use the cell A1).
- Choose the sheet reference that the hyperlink points to.
- Click the OK button.
See also this tip in French: La meilleure façon d’organiser votre classeur à l’aide d’hyperliens.
Please, disable AdBlock and reload the page to continue
Today, 30% of our visitors use Ad-Block to block ads.We understand your pain with ads, but without ads, we won't be able to provide you with free content soon. If you need our content for work or study, please support our efforts and disable AdBlock for our site. As you will see, we have a lot of helpful information to share.
