Teach Yourself Excel Lesson 27 - Create Hyperlinks

Create Hyperlinks
So, we have added data, pivot tables, and charts. We're now going to create an index page.
Steps:
- Select the "Index" worksheet
- Type "Index" in B2
- Select the "Data" worksheet
- Select cell A1
- Press CTRL + C to copy
- Select cell B3 on the "Index" worksheet
- Select the "Home" menu on your ribbon
- Click on "Paste"
- Choose "Paste As Hyperlink"
- Type the name of the worksheet in the cell with the hyperlink.. in this case: "Data"
- Repeat steps 3 to 10 for each worksheet
- Format the Index page
You should now have an index page.
Your sheet should now look like this
Congratulations!
You have now completed the course. Give yourself a pat on the back.
Go back to the beginning: Teach Yourself Excel Lesson 2 - Course Outline
Training Video on how to Create Hyperlinks in Excel:
Attachment | Size |
---|---|
create-hyperlinks.xls | 41.5 KB |
»
- Nick's blog
- Login or register to post comments
- 12745 reads
Recent comments
5 years 51 weeks ago
6 years 37 weeks ago
6 years 49 weeks ago
6 years 51 weeks ago
7 years 5 days ago
7 years 6 weeks ago
7 years 14 weeks ago
7 years 14 weeks ago
7 years 15 weeks ago
7 years 15 weeks ago