Can Google Sheets automatically scroll to the last row on opening?

Other Questions Google Sheets
1

Hey everyone,

I’ve got this massive job application spreadsheet in Google Sheets. It’s grown to about 400 rows now. Every time I open it, I have to manually scroll all the way down to see the latest entries. It’s getting pretty annoying.

Does anyone know if there’s a way to make the sheet automatically jump to the bottom when I open it? Like, some kind of setting or trick to make it show the last row right away?

I’ve tried looking through the options, but I can’t seem to find anything that does this. Any help would be awesome. Thanks in advance!

2

I’ve actually faced a similar issue with my project management spreadsheet. While there’s no built-in setting for this, I found a workaround using Google Apps Script. Here’s what I did:

  1. Open your spreadsheet
  2. Go to Tools > Script editor
  3. Paste this code:
function onOpen() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var lastRow = sheet.getLastRow();
  sheet.setActiveRange(sheet.getRange(lastRow, 1));
}
  1. Save and close the script editor

This script automatically runs when you open the sheet, scrolling to the last row. It’s been a huge time-saver for me. Just remember, if you’re sharing the sheet, others will need edit access for the script to work for them too.

Hope this helps solve your scrolling woes!

3

hey sophia, have u tried using a filter view? it’s not exactly what u asked for, but it can help. just set up a filter on ur sheet and sort by date descending. when u open the sheet, click the filter view and boom - newest entries at the top. might save u some scrolling hassle!

4

I’ve encountered this issue before with my inventory tracking sheet. While there’s no native feature for this in Google Sheets, I found a neat trick using frozen rows. Here’s what you can do:

  1. Go to the bottom of your sheet.
  2. Select the last few rows (say, 10-15).
  3. Right-click and choose ‘Freeze’ from the menu.

This will keep those rows visible at the bottom of your screen when you open the sheet. It’s not exactly scrolling to the bottom, but it ensures you always see the latest entries without manual scrolling. You can adjust the number of frozen rows as needed.

It’s a simple solution that doesn’t require any coding. Just remember to occasionally unfreeze and re-freeze rows as your sheet grows to keep the most recent entries visible.