Forum Discussion

Tony-Morris85's avatar
Tony-Morris85
Copper Contributor
Apr 27, 2021
Solved

Excel Hyperlinks

Hi..... I'd like to use a Hyperlink to a different sheet but move down the cells automatically So, in the first cell in sheet1 I'd like to Hyperlink to Sheet2 cell A1 But then in the second cell i...
excel
  • HansVogelaar's avatar
    HansVogelaar
    Apr 27, 2021

    Tony-Morris85 

    For example, enter the following formula in Sheet1 cell A1:

     

    =HYPERLINK("#Sheet2!A"&ROW())

     

    Fill down.

HansVogelaar's avatar
HansVogelaar
MVP
Apr 27, 2021

Tony-Morris85 

For example, enter the following formula in Sheet1 cell A1:

 

=HYPERLINK("#Sheet2!A"&ROW())

 

Fill down.

  • DAHAWOR1953's avatar
    DAHAWOR1953
    Copper Contributor
    Nov 03, 2022
    A similar scenario but I want to hyperlink to a cell in the same worksheet. ie From cell R3 to Q75 and fill down the formula to 34 rows. (R4 to Q76 etc.) Tried =HYPERLINK( "#Q75!Q"&ROW()) Returns Reference isn't valid.
    • HansVogelaar's avatar
      HansVogelaar
      MVP
      Nov 03, 2022

      DAHAWOR1953 

      Let's say the sheet is named Sheet 1. In R3:

       

      =HYPERLINK("#'Sheet 1'!Q"&ROW()+72)

       

      Fill down.

      • DAHAWOR1953's avatar
        DAHAWOR1953
        Copper Contributor
        Nov 03, 2022
        Of course - thank you for the speedy reply

Resources