资讯

Hyperlinks enables the user to jump from one location to another. We explain how to use a Hyperlink Function in Microsoft Excel.
Microsoft Excel has several features to create a hyperlink in your worksheet. A hyperlink links one document to another, activated by selecting a highlighted text or image.
Are you still putting your data in plain, old spreadsheets? Excel 2013 makes it easy to link tables, create reports and more.
Steps to create the dashboard include setting up hyperlinks, managing references, combining references, constructing dynamic formulas, creating tables, and making final adjustments.
You can use a menu command to create a hyperlink to a named range or you can use a simple drag-and-drop trick.
Use Hyperlink Function/Formula Another way to manually add a table of contents in Excel is by using the Hyperlink Function.