Question: how to add a hyperlink in excel to another tab?
Answer: Select the hyperlink destination cell in Sheet 2. Point to one of the cell borders and right-click. Hold the button and go down to the sheet tabs. Press the Alt key and mouse over the Sheet 1 tab. ...  Keep dragging to the place where you want to insert a hyperlink.