Jump to Next Row

A handful of records go into one of my Google Sheets on a daily basis. It’s most convenient to add them at the bottom, but scrolling there is tedious. The hyperlink() function offers a way to avoid the tedium.

A formula in the header lets me jump to the first row where I can add new elements. This works by calculating the row number and then calling hyperlink() to jump there. After jumping there you must select the cell before editing. There’s no apparent way to select for editing with hyperlink(). Also, the chosen cell is aligned at the top of the view, so you do need to scroll if you want context. Nevertheless, this does eliminate scrolling, the worst part of finding the right row.

Here is a formula that locates the first row with an empty cell in column B, and then selects column A in that row. The header cell that contains the link reads “Next Row”.

=hyperlink("#gid=SHEET_ID_HERE&range=A" & MATCH(TRUE,ARRAYFORMULA(LEN(TRIM(B:B))=0),0),"Next Row")

That’s it!