No problem Bruce! To jump to a specific cell without having to first click the start cell, right-click on the cell you want to link, select “Insert link,” and enter the cell reference in the format #gid=0&range=A1 where “0” is the sheet index and “A1” is the cell reference. Once the hyperlink is created, clicking on it will take you directly to the linked cell without the need for an intermediate step.

To quickly jump to a cell in Google Sheets based on today’s day-of-the-month, use the formula:
=HYPERLINK("#gid=0&range=" & ADDRESS(TODAY(), 1), "Go to Today's Cell")

This formula creates a clickable link that, when selected, will take you to the cell in the first column corresponding to today’s date. Customize the link text within the quotes as needed. If you’re not on the first sheet, replace 0 with the actual sheet index.

If you applied a filter in Google Sheets based on a condition in column A and want to jump to the 75th row meeting that condition, use a helper column (e.g., B) with a formula like =IF(YourCondition, ROW(), “”). Drag it down, then use =INDEX(FILTER(A:A, B:B <> “”), 75) to get the value in the 75th row. This dynamically adapts to changes in your filtered data while considering your specified condition. Replace YourCondition with the actual condition, and adjust column references as needed.

If you hold down the control button, then click an arrow, it will take you to the last cell before an empty cell. I hope this helps!

Thank you for the detailed explanation.

I wanted to go to a specific count in a particular column. Let’s say my col. A has 150 rows with data, and when I apply a filter with a particular condition – the total rows now are 120. Is there a way if I can go to the 75th row count from the top (when the filter is applied)?

Thanks in advance.

BR,
Arun

Hi, we have a full guide on building a table of contents here https://spreadsheetpoint.com/table-of-contents-google-sheets/

Thank you for the tips.
I use Google Sheets to make dynamic documents and export them as PDF.
I want to make a “Table of Contents” and make the Articles clickable links to jump to the clicked page/article.
How can I do that?
For now, if I make a hyperlink it jumps there but if I export the sheet as a document, from the exported PDF the links are referring to the sheet itself, not the PDF at the choosed topic. It is quite obvious it does this, since I got the link of the cell that contains the topic.

Thank you in advance!