Skip to main content

Working with changes

You can see who changed the contents of a cell (text, numbers, dates, formulas, etc.) and when using the Track changes feature. This feature lets you view information about the most recent change made to a cell:

  • who made the changes,
  • when,
  • what was changed (old and new values).

The field displaying the name of the person who made the changes in the cell is for informational purposes only and cannot be used to verify legally binding actions or in the investigation of information security incidents.

Enable or disable change tracking​

  1. In the upper-right corner of the window, hover over the Track changes toggle.
  2. Click the left mouse button. The toggle will change its appearance.

You can also click:

  • The Changes > Track changes button on the Review tab.
  • The keyboard shortcut Ctrl+Alt+Shift+E or Cmd+Option+Shift+E.

Turn highlighting of changed cells on or off​

  1. On the Review tab, click the Changes button.
  2. Enable or disable the Highlight changed cells option.

Cells with changes are highlighted with a border and a triangle in the upper-left corner. The highlighting is not displayed when printing or exporting to PDF.

Turn on or off the display of information when a cell is selected​

  1. On the Review tab, click the Changes button.
  2. Enable or disable the Display changes when selecting a cell option.

If the option is enabled, the information is displayed along with notes and comments.

If the option is disabled, the information can only be viewed via the context menu (see below).

View the latest change in a cell​

  1. Make sure the option Changes > Display changes when selecting a cell is enabled.
  2. Click on the desired cell. A pop-up window with information about the change will appear.

If the cell contains a comment or note, the revision information is displayed above it.

View the latest change via the context menu​

  1. Right-click the cell.
  2. In the context menu, select Latest change.

If there are changes, a window with information will open.

If there are no changes, a corresponding message will appear.