tech on the net
Home About Us Feedback Site Map

Microsoft

Access Excel Word

Database

SQL Oracle / PLSQL SQL Server MySQL MariaDB PostgreSQL

Web Development

HTML CSS Color Picker

Language

C Language

More

ASCII Table Linux UNIX Java Clipart Joke of the Moment

Other Sites

CheckYourMath BigActivities
Share this page:

MS Excel: Create a hyperlink to another cell in Excel 2010

See solution in other versions of Excel:

Question: I want to create a hyperlink in Microsoft Excel 2010. How do I specify a particular location that a hyperlink should point to?

Answer: To create a hyperlink to another cell in your spreadsheet, right click on the cell where the hyperlink should go. Select Hyperlink from the popup menu.

Microsoft Excel

When the Insert Hyperlink window appears, click on the "Place In This Document" on the left. Enter the text to display. In this example, we've entered "Hyperlink to cell A5". This is the value that will be displayed in Excel.

Next enter the cell reference that the hyperlink points to. We've chosen to link to cell A5. Click the OK button.

Microsoft Excel

Now when you return to the spreadsheet, you should see the hyperlink.

Microsoft Excel

If you click on the hyperlink, your active cell should become cell A5.

Microsoft Excel