In-Workbook Links
Key points
- Choose SHEET
- Enter Sheet!Cell
- Copy it
In HYPERLINK Builder you can link to another sheet or cell in the same file.
Steps
- Choose SHEET
- Enter Sheet!Cell
- Copy it
In Google Sheets, also enter the sheet gid.
Use "Build a HYPERLINK Formula" (free)
Tools that go well with this
- Build an IMPORTRANGE Formula: Build an IMPORTRANGE formula.
- Build a TEXTJOIN Formula: Build a TEXTJOIN formula.
- Build an IF Formula: Build an IF formula.