Advanced Options

These options are for people who want to change the spreadsheet itself.

Protected ranges

Editable cells have a yellow background. Other cells are protected to reduce accidental changes to formulas and generated areas.

If you want to edit a protected range:

Go to Data > Protect sheets and ranges.
In the sidebar, select Show all protected ranges.
Select the range you want to change.
Edit or delete the protection.

Recovery path: If you break a formula, make a new copy of the original spreadsheet and copy your values into it.

Apps Script

Some spreadsheet behavior uses Google Apps Script.

To inspect the script:

Open the spreadsheet in Google Sheets.
Go to Extensions > Apps Script.
A new tab opens with the script project attached to the spreadsheet.

The script is mainly there for settings and helper actions. If you download the file into another spreadsheet app, that script-powered behavior will not be available.