Weekly tech discussion and tech support thread

https://lemmy.world/post/2009908

Weekly tech discussion and tech support thread - Lemmy.world

Hey everybody, feel free to post any tech support or general tech discussion questions you have right here. As always, be excellent to each other.

Here’s an annoyance I have: in Google Sheets, I have a sheet which I use daily via desktop browser. At some point I loaded my sheet from the same account on a second device (either my phone or iPad in the official app) and I guess I selected a column and then left. The highlighted column syncs between devices, so I can see the highlight on desktop. But that session is long since closed, and the highlight is stuck on desktop, so one of my columns is now just permanently highlighted in green. I’ve tried loading and then exiting the sheet from various apps, various devices, even in the mobile browser, to try to close the session with the column selected. Each time I see a new “viewer” in the sheet which correctly leaves when I disconnect the session, but still the selection remains.

Is there a way I can forcibly close the session which is causing the highlighted column? I’m seriously considering copying the entire sheet’s content into a completely new document. The problem there is I don’t think I can easily copy the comments.

Just FYI, you can duplicate an entire google docs/sheets/slides document by going File > Make a Copy, and in your case preserve comments by checking the relevant box!
Thanks! I didn’t know this so I tried it, but annoyingly the highlighted column is still there on the new sheet haha. Worth a try, thanks!