AI Assistant
Help Center AI Assistant is now available
Got questions about Lark? Use our AI chat to find the answers.
00:00
Click and hold to drag
Got It
Try Now
Check cell edit history in Sheets

Check cell edit history in Sheets

1 min read
I. Intro
You can view the edit history of specific cells, which includes details on the editor, edit time, and the edits made, enabling you to trace back the updates made over time. If you want to view the edit history for the entire spreadsheet, see Use edit history in Sheets.
II. Steps
  1. View edit history of a cell
Enter the spreadsheet, right-click the cell, and select Edit History.
Note: Only actions that change the value of the cell, such as entering, editing, deleting, and pasting content into the cell, are tracked. Actions that do not change the value of a cell, such as changing the font size, font color, number format, data validation, and conditional formatting are not tracked.
250px|700px|reset
  1. Copy content from edit history
Hover over the record you want to copy, then click the Copy icon to the right. Plain text, images, attachments, and hyperlinks can be copied.
250px|700px|reset
III. FAQs
What is the difference between the edit history of a cell and "Edit History" that can be found in the ··· menu in the upper-right corner of the spreadsheet?
The edit history of a cell only shows the edit history for the selected cell while Edit History in the ··· menu contains the edit history for the entire spreadsheet. When a version is restored from edit history for the spreadsheet, edits made after that version are not kept, so when you check the edit history of a cell, it will only show who restored the edit history.
I made changes to a pivot table. Will they show up in the cell edit history?
Only the cell in the upper-left corner of the pivot table will show who inserted the pivot table, but there won't be any edit history for other cells.
Can I still retrieve the cell edit history after deleting a row/column or sheet?
No. Even if the deleted content is retrieved by recalling or restoring a version, only the activity log for the current session will be available.
What is the earliest edit history available?
Edit history goes as far back as February 14, 2023.
Written by: Lark Help Center
Updated on 2024-11-26
How satisfied are you with this content?
Thank you for your feedback!
Need more help? Please contact Support.
0
rangeDom
rangeDom
rangeDom
rangeDom
rangeDom