SS Change Tracking

This page applies specifically to the following versions. Different versions are likely to differ in functionality to a greater or lesser extent...

  • Microsoft Excel Version 2108

  • Google Sheets (as at 13-May-2022)

Version History

Google Sheets

File - Version History - See version history

Or

Ctrl+Alt+Shift+H

Microsoft Excel

File - Info - Version History

Cell Edit History

Google Sheets

Right click cell - Show edit history

Microsoft Excel

You can only do this using the legacy Track Changes functionality....

  • File - Options - Quick Access Toolbar

  • Choose commands from - All commands

  • Share Workbook (Legacy) - Add

  • Track Changes (Legacy) - Add

  • Protect Sharing (Legacy) - Add

  • Compare and Merge Workbooks - Add


The buttons will appear in the Quick Access Toolbar (i.e. above the regular File Home, Insert... menus)

Change Notifications

Google Sheets

Tools - Notification Rules

Microsoft Excel

Protecting Cells

Google Sheets

Data - Protect Sheets and Ranges

Microsoft Excel

File - Info - Protect Workbook