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

= January 16 =

Google Sheets version history
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)