Forum Discussion
kimwagner
Sep 18, 2020Copper Contributor
hyperlinks to sheets within workbook
Working in a spreadsheet that someone else created, so not sure how hyperlinks were originally created. There are hyperlinks under Cell Reference, which are the actual names of the tabs, but there a...
kimwagner
Sep 18, 2020Copper Contributor
Thank you for your response. Do you think it's preferable to use the Cell Reference type hyperlink as opposed to Defined Names? Also, does there need to be a value in the Type the cell reference field?
HansVogelaar
Sep 18, 2020MVP
Named ranges can be a handy way to clarify what a cell means. If you use named ranges, it makes sense to use them in hyperlinks too. Apart from that, there is no special reason to prefer one above the other.
If you create a hyperlink to another sheet and leave the Cell Reference box empty, Excel will automatically enter A1 as cell reference.