can I get google Sheets to open to last edited cell?

Questions on how we spend our money and our time - consumer goods and services, home and vehicle, leisure and recreational activities
Post Reply
User avatar
Topic Author
heartwood
Posts: 2700
Joined: Sat Nov 23, 2013 12:40 pm

can I get google Sheets to open to last edited cell?

Post by heartwood »

I've googled the internet, tried the Sheets help section, tried the google users forum to no avail.

I have multi-sheet Google Sheets that I use as my register for several accounts, e.g., checking accounts. I enter transactions to track and project my balance.

When I used Excel and opened the worksheet it opened at the last cell edited. In Sheets it goes to the first cell in the worksheet. So each time I open it I have to scroll to the current section, e.g., to May 6 rather than Jan 1. Annoying but not fatal, but it's only May.

Any workaround to have it open at that last cell?
z91
Posts: 790
Joined: Fri Mar 07, 2014 12:19 pm

Re: can I get google Sheets to open to last edited cell?

Post by z91 »

Do you actually need the last edited cell, or just a specific cell you want to link?

If the latter (and don't want to use a trigger): A potential workaround for this is to create a named range for the cell. Go to another cell, type some text, create a link. The link should go to the named range you created earlier. Once you have the link, you can delete the cell and use that link to go to the specific cell.
wander
Posts: 4424
Joined: Sat Oct 04, 2008 9:10 am

Re: can I get google Sheets to open to last edited cell?

Post by wander »

You can reverse the order. Old date is at the bottom of Google sheet, and set new day at the top.
otinkyad
Posts: 486
Joined: Wed Jun 01, 2016 5:35 pm

Re: can I get google Sheets to open to last edited cell?

Post by otinkyad »

I just Ctrl-downarrow.
User avatar
Topic Author
heartwood
Posts: 2700
Joined: Sat Nov 23, 2013 12:40 pm

Re: can I get google Sheets to open to last edited cell?

Post by heartwood »

otinkyad wrote: Thu May 06, 2021 3:45 pm I just Ctrl-downarrow.
Thanks, not what I want. The sheet already has entries into next year. I don't want to go to the end, just where I left off.
User avatar
Topic Author
heartwood
Posts: 2700
Joined: Sat Nov 23, 2013 12:40 pm

Re: can I get google Sheets to open to last edited cell?

Post by heartwood »

wander wrote: Thu May 06, 2021 3:22 pm You can reverse the order. Old date is at the bottom of Google sheet, and set new day at the top.
great kluge! I'm too set in my ways to reorient my thinking and have a reverse ledger.
User avatar
Topic Author
heartwood
Posts: 2700
Joined: Sat Nov 23, 2013 12:40 pm

Re: can I get google Sheets to open to last edited cell?

Post by heartwood »

Tried this but keep getting error messages. I'm gone for a few days. I'll look again when I get back
User avatar
Topic Author
heartwood
Posts: 2700
Joined: Sat Nov 23, 2013 12:40 pm

Re: can I get google Sheets to open to last edited cell?

Post by heartwood »

z91 wrote: Thu May 06, 2021 2:38 pm Do you actually need the last edited cell, or just a specific cell you want to link?

If the latter (and don't want to use a trigger): A potential workaround for this is to create a named range for the cell. Go to another cell, type some text, create a link. The link should go to the named range you created earlier. Once you have the link, you can delete the cell and use that link to go to the specific cell.
I don't understand how to do this. I'll take a look later.

All helpful suggestions. Maybe what I need is ELI5 (explain like I'm 5) I may just continue to scroll rather than spend more time figuring it out.

Thanks to all.
Post Reply