I have created some buttons so that user may click on them and go to a particular report on the same Tab in my Google Sheet file. A sample of my Google script code is as under;

function Offer_Sent_Report() {
  var spreadsheet = SpreadsheetApp.getActive();
  spreadsheet.getCurrentCell().offset(498, 0).activate();

This Offer_Sent Report starts at Row 480 and I want the cursor to go in Cell 'E480' after the user has pressed the related button, where he must enter a Date for extracting the report. Right now the cursor remains in Cell 'A498' and the user has to first go to Cell 'E480' to enter the required date. I want that Row 480 should be at the top of the screen when the report is opened. Please guide.

  • 2
    Possible duplicate of How do I go to/highlight a specific cell ID in Google Sheets? – Rubén May 13 '18 at 15:52
  • Thanks a lot Ruben. But i want the cursor to automatically go to E480 and also that Row 480 should remain at the top of the screen because my report starts from Row 480. I do not want to take any input from the user to get the cell address. Thanks Buddy. – GS Puri May 13 '18 at 18:15
  • Have you read my answer carefully? There are several things on it that could help you to achieve the result you are looking for. – Rubén May 13 '18 at 18:45

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.