How to move to the last selected row when you open Google Sheets.
When you use it as a work journal, you will usually freeze the sheet’s top part since the header will be hidden if there are many records. Like this;
However, the more records you have, the more painful it becomes to move to the last row. This is because Google Sheets, unlike Excel, does not remember where you were looking on the sheet last time. So if you open the sheet next time, you will have to scroll the sheet until the last row appears. Don’t you think it’s very bothersome?
At first, you should save the row number you selected. Since your browser might close unexpectedly, you should save the position each time. You can use PropertiesService to store the data as follows:
I created a sample spreadsheet that demonstrates the above behavior. Feel free to copy the spreadsheet and check the behavior.
Google Sheets takes a little longer to load the sheets and scripts, so it seemed to take a little longer to run the scripts. Still, it’s no problem to use.
