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

Simplify Excel navigation with a custom sidebar! Learn 3 easy methods to create a streamlined, professional interface for your workbooks.

Two updates stand out as more advanced features that push the Online version closer to paid Excel: in-document hyperlinks, and better PivotTable summaries.