I was today fed up with Google Sheets not remembering the last edit location and always having to scroll down a big table to add an entry=row at the bottom of it. So I have looked for a solution to this pain.
Problem Description
Unfortunately, Google Sheets does not remember the cell at which it was last opened.
If you have a long table with many many rows and you want to add a row below it, it takes quite some time to scroll down to the bottom of the sheet.
Manual solutions
On PC you can navigate to the next unempty cell of your column using Ctrl+Down.
This doesn't work for mobile.
This won't navigate you to the bottom of the sheet if your table has some empty values in the selected column.
Ctrl+End hotkey will go to the bottom of the Sheet - not the data. You might need to crop your sheet to the data. I recommend this app for cropping your sheets.
I have used also as alternative workarounds to reduce scrolling adding a filter (e.g. by date) or hiding rows.
Script-based solution
You can add a script to your Sheet that will navigate you to the bottom when you open the sheet:
Extensions->Apps Script
function onOpen(){
let ss = SpreadsheetApp.getActiveSpreadsheet();
let sheet = ss.getSheetByName(ss.getSheets()[0].getName());
sheet.setActiveRange(sheet.getRange(sheet.getLastRow(),1));
}
When you load the Sheet the Script is then executed.
It takes quite some time to jump to the bottom :-(
On mobile you still have to locate the cell and click on it so you can add a row but here Google Sheets seems to remember the last open selection.
No comments:
Post a Comment