Create a table of contents in an Excel sheet using hyperlinks Your email has been sent Hyperlinks have been around for a long time, but some Excel users just don’t use them. One way your users can put ...

In order to perform this operation, you will need at least two sheets open in your workbook: a working sheet and a blank sheet where you can compile your lists. The first step is to create your list.

You can use a menu command to create a hyperlink to a named range or you can use a simple drag-and-drop trick. Adding a hyperlink to an Excel sheet is a simple enough task, but like so many Office ...

Windows may get all the attention, but when you want to get real work done, you turn to the applications that run on it. And if you use spreadsheets, that generally means Excel. Excel is, of course, ...