CODEWITHSUNDEEP
google-apps-scriptgoogle-sheets
Кирилл Харабардин
Кирилл Харабардин

Reputation: 13

Set focus on part of sheet

I have a big sheet with lot of info, and it raise every day, and i only input new info, so i wanna ask - is a way to set focus on first blank row at opening sheet? (sorry for my bad english, it's not my native lang)

Upvotes: 1

Views: 3929

Answers (2)

CMB
CMB

Reputation: 5163

Script-based Solution:

Since you are open to using Google Apps Script anyway, you can use this simple trigger to set the active cell to the first blank row upon opening the sheet:

function onOpen(e) {
  var sheet = SpreadsheetApp.getActiveSheet();
  var values = sheet.getRange('A:A').getValues(); // get all data in one call
  var c = 0;
  while ( values[c] && values[c][0] != "" ) { c++; }
  sheet.setActiveRange(sheet.getRange(c+1,1));
}

Sample:

enter image description here

Reference:

Simple Triggers

Upvotes: 2

Krzysztof Dołęgowski
Krzysztof Dołęgowski

Reputation: 2660

You can add links on top of your sheet. These links will move you to where you want.

For example - if you want to get to the last row, you should:

=hyperlink("https://docs.google.com/spreadsheets/d/1rVi631pl-VeskPv7jkk5XRixaQ2UkFSAJwteI-JdoGk/edit#gid=0&range=A"&MATCH(MAX(A1:A),A1:A,1),"go down")

In other words:

=hyperlink("[link to your actual sheet]&range=A"&MATCH(MAX(A1:A),A1:A,1),"go down")

Match formula finds last row and adds this number to your link.

enter image description here

You can try it here: https://docs.google.com/spreadsheets/d/1rVi631pl-VeskPv7jkk5XRixaQ2UkFSAJwteI-JdoGk/edit#gid=0

Does it help?

Upvotes: 0

Related Questions