Whenever you open a Google Sheet your focus is automatically in the A1 area. However, I've been using this sheet for a while and have to manually move to C2427 or so to see the stuff I'm actually working with.

Is there some code I can put somewhere to move the view like this? At least for the first time I open the sheet.

CodePudding user response：

Is there some code I can put somewhere to move the view like this?

Yes.

To get started, take a look at jumpToToday_.

CodePudding user response：

Another option might be simply to right click on C2427, and under 'View more cell actions' select 'Get link to this cell'. This copies a URL link to the clipboard which you can use to open the sheet with C2427 at the top-left of the screen and selected. This also works for ranges and named ranges.