The Insert Hyperlink dialog window appears on the screen.
Since the subject of this article is creating a hyperlink to another worksheet in the same workbook, below you'll find out three ways to do that. If you need to add a hyperlink in Excel 2016 or 2013, you can choose one of the following hyperlink types: a link to an existing or new file, to a web page or e-mail address. Excel internal hyperlinks will help you to quickly jump to the necessary part of the workbook without hunting through multiple worksheets. One of the ways you can put spreadsheet hyperlinks to good use is to create a table of contents of your workbook. But do you know the benefits of spreadsheet hyperlinks in Excel workbooks? The time has come to discover them and start using this great Excel feature.
Clicking on hyperlinks you instantly get access to other information no matter where it is located. If you are a real Internet surfer, you know firsthand about the bright sides of hyperlinks.
#Mac excel 2016 insert hyperlink how to#
If you don't need a hyperlink any more, you'll see how to quickly remove it. You'll also learn how to change a link destination and modify its format. In this article I'll show you 3 ways how you can add hyperlinks into your Excel workbook to easily navigate between numerous worksheets.