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 ...

My favorite use of the hyperlink function is to create a table of contents or navigation buttons in Excel sheets. It helps ...

The Hyperlink function creates shortcuts that leap to another location. The Hyperlink function can create links to workbooks, documents stored on a network server, intranet, or the internet when we ...

Implementing a drop-down list in Excel is a quick and efficient way to choose predefined data. In the process, you’re able to save time compared to manually entering such data into a given spreadsheet ...

Q. I have an Excel workbook with dozens of custom-named worksheets. Is it possible to create a list of those worksheet names in Excel without having to retype them? A. Yes, you can create a list of ...

In the January column (page 82) a reader asked how to display 36 workbook tabs in Excel. We described several solutions, but reader Mary Jo Gruber, a CPA with a St. Louis public school district, ...