How to deal with a link with range named in Google Sheets? - Stack Overflow

admin管理员组

文章数量:1123367

I'm currently working in Google Sheets. When I want to set a link from one "Worksheet" to another "Worksheet", I usually do the following:

https://url_to_your_shee_and_sheets_ID&range=K1

As soon as I click on my previous link, I will be directed to the cell of the other work area as normal. So far everything is fine.

And now I want to name the area and work with the named areas. That means I give the cell a name. And if I do the same as above, except that I insert the name of the cell instead of "K1", then I won't be directed to the cell.

Suppose I now name K1 to "TestCell" and include that name in my link:

https://url_to_your_sheet&range=TestCell

I am not redirected to the corresponding cell until I insert K1 again. So what do I have to do?

I'm currently working in Google Sheets. When I want to set a link from one "Worksheet" to another "Worksheet", I usually do the following:

https://url_to_your_shee_and_sheets_ID&range=K1

As soon as I click on my previous link, I will be directed to the cell of the other work area as normal. So far everything is fine.

And now I want to name the area and work with the named areas. That means I give the cell a name. And if I do the same as above, except that I insert the name of the cell instead of "K1", then I won't be directed to the cell.

Suppose I now name K1 to "TestCell" and include that name in my link:

https://url_to_your_sheet&range=TestCell

I am not redirected to the corresponding cell until I insert K1 again. So what do I have to do?

• google-sheets

Share Improve this question Follow edited 14 hours ago Sophus asked 14 hours ago SophusSophus 48777 silver badges2121 bronze badges

Add a comment  | 

1 Answer 1

Sorted by: Reset to default 0

Ok, I found the solution in this page: https://webapps.stackexchange.com/questions/44473/link-to-a-cell-in-a-google-sheets-via-url please scroll don't till "Link to: A named range"

"Link to: A named range Linking to a named range is trickier than getting the link to a range of cells by address. GS doesn't have a feature to link directly to the named range. Using the name of a named range in the range= argument doesn't work. Follow these steps to get a working link URL for a named range:

Be sure the spreadsheet has a named range in it. If it doesn't, create one. (E.g., in the example spreadsheet, the range named "judgenames" was defined as "C1:C", which GS saves as "C1:C605".) Click on an empty cell of the spreadsheet. Use the "Insert link" feature (i.e., from the Insert > Link... menu item, from the "Insert link" contextual menu item, the keyboard shortcut command-K or ctrl-K, etc.). In the link editor box that appears, click "Named ranges in this spreadsheet", then click the name of a range shown below it (e.g., "judgenames") Click the "Apply" button. Move the pointer over the new link. A popup showing part of the URL will appear (e.g., #rangeid=1332253898). Copy that new link from the popup by either:

Copying the link text and using it in place of the fragment identifier in the URL of the current spreadsheet. Copy the link address. (The wording used by Google Chrome.) These methods will vary from browser to browser.

The URL will be similar to:

https://docs.google.com/spreadsheets/d/1yk6W3iyZM7JKffsRTjPhm9I_PWerrJbltoHZ37Tqdh0#rangeid=1332253898"

本文标签： How to deal with a link with range named in Google SheetsStack Overflow