Jump to Specific Cell Automatically

0:00 So when a spreadsheet is open, it'll start at the top of the spreadsheet 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. 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? And that reason may be where we last did our work, where we want to start our work, whatever it is, go to extensions app script . This is only going to take a little bit of app script and we're going to do it very quickly as well. Once this opens, we're going to write function on open and then you're going to write spreadsheet app dot get active sheet and you're going to get range here. You will type in the number of the row you want. So our number was 289, 289, and you will type in the number of the column. So E is the fifth column or column five, so that's comma five. Go to Specific Cell When Spreadsheet is Opened Getting Started Coding in Apps Script Go to Specific Cell When Spreadsheet is Opened Log Every Time a Google Sheet is Opened

0:48 And we're going to use function on open. This is an simple trigger it's called, and it is already built in. We literally just have to type in function on open and then put into our script the script what happens. We are just activating this. We're doing spreadsheet . App dot get active sheet , whatever sheet we're on. We're getting the range and we're activating it. 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. We refresh. It's going to take a moment, but it will go to that range that we activated. There it is, right there at the bottom, start. So it active, it automatically went to exactly where we want it to go. Go to Specific Cell When Spreadsheet is Opened Getting Started Coding in Apps Script Activate A Certain Sheet When Opening a Spreadsheet Random Number Between 1 and 100