Jump to content

Wikipedia:Reference desk/Archives/Computing/2021 January 16

From Wikipedia, the free encyclopedia
Computing desk
< January 15 << Dec | January | Feb >> January 17 >
Welcome to the Wikipedia Computing Reference Desk Archives
The page you are currently viewing is a transcluded archive page. While you can leave answers for any questions shown below, please ask new questions on one of the current reference desk pages.


January 16[edit]

Google Sheets version history[edit]

Several of us are intermittently editing a shared google spreadsheet. If you go to "File | version history" you get a list of dates&times with who edited the document at that (approximate) time. Our document is a multi sheet one (around 20 sheets). How do I determine which sheets have been edited at a particular edit? Once I know the particular sheet(s), I can scroll down and find the appropriately shaded cells and look at the edit history within the cell. But at present I can do no better than trying each sheet in turn and scrolling to the bottom looking for shaded cells. This can take me over 10 minutes. Is there some option that returns something like "Joe Hill edited sheets 'This', 'That' and 'The other'."? -- SGBailey (talk) 13:32, 16 January 2021 (UTC)[reply]