Highlight Changes Made to a Sheet

To quickly identify and review the changes that have been made to a sheet, useHighlight Changes.

Turn Highlight Changes on or off

1. Open the sheet and clickHighlight Changeson the toolbar.
   
   TheHighlight Changeswindow appears.
   
   

2. Click the slider to turn Highlight Changes toON.

3. UnderHighlight changes in the last,select the desired time interval.
   
   Note that when you enable theI last viewed the sheetoption, you'll see highlighted changes since you last viewed the sheet—anyone else who views the sheet will see changes sincethey最后看表。

4. ClickBackground Colorto set the highlight color.
   
   The cell background will change to the color that you have set once changes have been detected.

5. Click theXin the upper-right corner of the window to close it and save your settings.

Who sees the highlighting

If you turnHighlight Changeson or off and save the sheet, you turn it on or off for everyone shared to the sheet.

If someone has added a comment, or added or edited attachments in the specified time period, the icon in that row will be highlighted. (Note that changes to the comments themselves will NOT be highlighted.)

To review details about the change, including the时间的变化and theemail addressof the person who made it, right-click on the cell and selectView Cell History.

You can also set up Notifications to receive email alerts when changes are made to a sheet. For more information, see theNotificationsarticle.

Highlight changes settings

Highlight Changes has eight settings. The settings refresh down to the minute when accessing a sheet. The below table outlines what changes will be highlighted when viewed on 12/12/20 at 6:00 PM.