This dynamic Hyperlink cell with 1 complete formula will let you Go to first available cell in a column. To allow you to enter next row data.
It can help you especially when you have long ones.
Above formula will create a hyperlink to go to next available row using column B, assuming column B has only numbers.
The COUNT() function is used to calculate how many numbers in column B, then adds 1 to it, then select it.
If you want to change the column, modify the B in three places, to use any other column.
If you have that column (column B in our formula) with text instead of numbers, use COUNTA() instead of COUNT().
The +6 in our formula is because my sheet starts from row 5, and I wanted to shift the selection by 6 rows.