The best way to organize your workbook using hyperlinks

Excel 365 2013 2010
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.
Hyperlinks in Excel 2016

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:

Hyperlink popup in Excel 2016

   2.   In the Insert Hyperlink dialog box:

  1. Click on the Place in this Document button on the left.
  2. In the field Text to display, enter the text that will be displayed in the hyperlink.
  3. Enter the cell reference that the hyperlink points to (by default use the cell A1).
  4. Choose the sheet reference that the hyperlink points to.
  5. Click the OK button.
Insert Hyperlink in Excel 2016

See also this tip in French: La meilleure façon d’organiser votre classeur à l’aide d’hyperliens.

If you have any questions or suggestions, please feel free to ask OfficeToolTips team.

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners who may combine it with other information you’ve provided to them or they’ve collected from your use of their services.

Learn more