Tuesday, July 23, 2019

NEW in Google SHEETS! View the History of a Cell, Edit Chart Borders

View the edit history of a cell in Sheets

Show edit history is a new feature in Sheets that will help you easily see the edit history of a cell, including who made the last edit, when that edit was made, and the cell’s previous value.

Tracking edits made by collaborators is important for keeping information accurate and understanding why specific changes were made and by whom. This is especially critical when there are several collaborators working in a sheet. With Show edit history, you can quickly surface the edit history of a cell: who edited, when, and the previous value.

To start using Show edit history:
  • Right click on any cell and select “Show edit history” from the dropdown menu.
  • A dialogue box will appear that will show you:
    • The user who last made a direct edit in the cell
    • A timestamp of the edit
    • The previous value and current value of the cell
    • Arrow keys in the top right corner which toggle back and forth between edits



The following changes are considered previous edits to a cell:
  • Adding, editing, or removing content — like changing the value of a cell from “3” to “5”
  • Changing a formula — like changing “=A1+B1” to “=A1+C5”
  • Adding, editing, or removing a link from a cell 
Note: Some changes may not show up in the edit history. Some examples are:
  • Added or deleted rows and columns
  • Changes to the cell’s format
  • Changes made by formulas

Remove or select a custom color for chart borders in Google Sheets

You now have more options for customizing chart borders in Google Sheets. Currently, the default border for a chart is dark gray.  Now, you can change the border to a custom color or remove the border:

Double click on any chart to open the Chart editor and select the Customize tab.
Under Chart style, select a border color or select “None” to remove the border. 
The default border is shown on the left, customization options shown on the right.