Search within Lanny's blog:


Leave me comments so I know people are actually reading my blogs! Thanks!

Thursday, January 16, 2025

Daily Battles: Why Google Sheet won't open with the tab I was on last time

Other Daily Battles Posts

When I try to open my Google Sheet, the quickest way is to type the name of the file in the address bar of the browser (like Chrome), scroll down to select it from the popup list, and then hit enter.


However, it starts to get really annoying that after the Google Sheet opens, it always lands on an old tab, different from the tab I worked on last time. I tried it several more times, and it happened every single time.

What's the deal here?

After a bit of investigation, here's what I found: after I selected what's cached in the browser address bar and take a closer look, the ULR had this at the end:

The gid=1827318333 part actually told Google Sheet what tab and cell to select when you open it, which is an old cache from the old days pointing to likely an old tab. 

So here are your few options:

  1. You can simply get rid of the gid parts from the end of the URL. That will make sure tab 1 and cell 1 are selected when the Google Sheet is opened. Does seem to actually add more work.
  2. Open it the old way, and then click on the tab you want to work on. Just always remember that if lots of your tabs look similar, so you don't work on the wrong tab.
  3. Click the X at the end of the cached URL so your new Google Sheet URL (with the right starting location) gets cached in Chrome.

Happy fighting your daily battles!


Other Daily Battles Posts


Picture of the Day:

P.S. Remember, the easiest way to keep up with my journey is by visiting blog.lannyland.com 


0 comments:

Post a Comment