Excel University Blog

Read on for in-depth articles, tutorials, and videos. Search or browse for specific topics. Be sure to subscribe if you'd like to be notified when we write something new.


Insert a Hyperlink

By Jeff Lenning | April 30, 2024 |

One of the highly effective ways to boost navigation in your workbooks is by inserting hyperlinks. You can create links in your Excel workbooks that link to files of any type, including PDF files, Excel workbooks, Word documents, images, and even specific cells in a workbook. When you click on a link to a non-Excel…

Read More

Create Hyperlinks to Files in a Folder

By Jeff Lenning | March 26, 2024 |

Today, we’re diving into an exciting way to enhance your data organization skills using Excel. I was recently asked the following question: Is there a way to create a list of files so that the files in the list could be hyperlinked back to the source in the folder? I’m going to answer that question…

Read More
Piggy bank with a clock on top to represent time saved by learning Excel tips and tricks

Top 8 Excel Tips and Tricks to Save You Time

By Excel University | April 5, 2022 |

These top 8 Excel tips and tricks will free up tons of time and allow you to get more work done even faster.

Read More

Extract URL from Hyperlink with an Excel Formula

By Jeff Lenning | February 22, 2022 |

Let’s say you have a hyperlink in a cell in Excel. The hyperlink may have friendly text, such as Click Here, but when you click the link it takes you to a URL such as https://www.excel-university.com. Now, let’s say you want to extract that URL from the hyperlink using an Excel formula. Well … to…

Read More

List of Workbook Tables and References

By Jeff Lenning | December 8, 2020 |

John asked if there was a way to create a list of all table names in the workbook, along with the underlying table reference. In this post, I’ll demonstrate how this can be accomplished with Power Query and an Excel formula. Objective Before we get into the mechanics, let’s confirm our goal here. We have…

Read More

Link to Sheets using Defined Names

By Jeff Lenning | June 23, 2020 |

Hyperlinks are a useful way to expedite navigation. If you have ever created a hyperlink to a worksheet, you may have noticed that your hyperlink can break if you change the worksheet name. This post demonstrates how to use defined names to avoid this type of error. Objective Let’s say we want to make it…

Read More

Hyperlinks Article

By Jeff Lenning | May 5, 2016 |

Back in the old days, when I used workpapers that were made with, you know, paper, I used a red pencil to create cross-references that made it easy to navigate to related documents. Today, I use Excel hyperlinks instead. Check out this CalCPA Technology and Business Resource Guide article where I describe how to use Excel hyperlinks to cross-reference digital…

Read More

Create an Index Worksheet using Excel Hyperlinks

By Jeff Lenning | February 21, 2013 |

Have you ever worked in a workbook with only a few worksheets…say three or four sheets? Navigating to the correct sheet is fast and easy, and you spend very little time getting to the spot you need to be to do your work. Have you ever worked in a workbook with more sheets? Say, 10,…

Read More