You can use a menu command to create a hyperlink to a named range or you can use a simple drag-and-drop trick.

Here's a quick tip for creating a Microsoft Excel drop down list from another tab.

Microsoft Excel has several features to create a hyperlink in your worksheet. A hyperlink links one document to another, activated by selecting a highlighted text or image.

Because she works with a budget file that contains 63 tabs, our ideas lacked the muscle to meet her needs. Instead, she sets up a single contents page composed of easy-to-create hyperlinks on the ...