Create an automation that goes directly to a cell you pick every time you open the spreadsheet file.
Members-only tutorial
Watch the video and get the practice sheet with membership.
About this Tutorial
Sheet Resources
Video Transcript
<div>0:00 So when a spreadsheet Learn about spreadsheets and their functionalities. Opens in new tab is open, it'll start at the top of the spreadsheet Learn about spreadsheets and their functionalities. Opens in new tab and you'll open it, but sometimes, for some reason, you may want to open a sheet and go to a very specific cell when it is open and every time it is open.<br>0:12 So let's say we want to actually go on sheet 1 here to row 289 and column E. So we want to start here for some reason, right?<br>0:22 And that reason may be ah where Understand how to filter data using the WHERE clause. Opens in new tab we last did our work, where Understand how to filter data using the WHERE clause. Opens in new tab we want to start our work, whatever it is.<br>0:29 Go to extension. Open Apps Script Discover how to automate tasks with Google Apps Script. Opens in new tab .
This is only going to take a little bit of Apps Script Discover how to automate tasks with Google Apps Script. Opens in new tab and we're going to do it very quickly as well once this opens.<br>0:37 We're going to write function Get to know functions and how they work in spreadsheets. Opens in new tab onOpen and then you're going to write spreadsheetApp Explore the SpreadsheetApp class in Google Apps Script. Opens in new tab .getActiveSheet and you're going to get range Learn about ranges and how to manipulate them in spreadsheets. Opens in new tab here. You will type in the number Understand how numbers are used and formatted in spreadsheets. Opens in new tab of the row you want.<br>0:47 So our number Understand how numbers are used and formatted in spreadsheets. Opens in new tab was 289, 289. And you will type in the number Understand how numbers are used and formatted in spreadsheets. Opens in new tab of the column. So E is the fifth column or column five, so that's comma five.<br>1:01 And we're going to use function Get to know functions and how they work in spreadsheets. Opens in new tab onOpen. This is a simple trigger it's called and it is already built in.
We literally just have to type in function Get to know functions and how they work in spreadsheets. Opens in new tab onOpen and then put into our script the script.<br>1:14 What happens? We are just activating this. We're doing spreadsheetApp Explore the SpreadsheetApp class in Google Apps Script. Opens in new tab .getActiveSheet, whatever sheet we're on. We're getting the range Learn about ranges and how to manipulate them in spreadsheets. Opens in new tab and we're activating it.<br>1:22 Save. We're just going to save it. Make sure this orange button goes away. Close it and now when we refresh, let's just go to the very top.<br>1:32 We refresh. It's going to take a moment but it will go to that uh range Learn about ranges and how to manipulate them in spreadsheets. Opens in new tab that we activated. There it is right there at the bottom.<br>1:38 Start.
So it active, it automatically went to exactly where Understand how to filter data using the WHERE clause. Opens in new tab we uh want it to go.</div>