To track changes and comments in Google Sheets worksheets, you can follow these steps:
- Open your Google Sheets worksheet and make sure you are logged in to your Google account.
- Click on the "View" menu option at the top of the page.
- Select "Show revision history" from the drop-down menu. A panel will appear on the right side of the screen.
- The revision history panel will show a list of all the changes made to the worksheet. You can scroll through the list to see different versions of the sheet.
- You can also filter the revision history by specific users or time periods by clicking on the options at the top of the panel.
- To view the changes made at a specific revision, click on the timestamp in the revision history. The worksheet will update to reflect that version.
- If you want to leave comments on specific cells or ranges, select the desired cell(s) and right-click. From the context menu, choose "Insert comment" or use the shortcut Ctrl+Alt+M (Command+Option+M on Mac).
- A comments box will appear on the right side of the screen. Enter your comment and click "Comment" to save it.
- The comment will be visible in the cell and can be viewed by clicking on the cell. You can reply to comments, resolve them, or delete them if needed.
- To track changes, edits, and comments made by other collaborators in real-time, make sure you are working in a shared Google Sheets document.
By following these steps, you can easily track changes and comments made in Google Sheets worksheets.