How Lock works
- Finished AI answers in your selection become plain values. They do not recalculate or use credits.
- The original formula is kept in the cell note after đź”’, so Unlock can bring it back.
- Cells that are still loading or show an error are skipped.
How do I lock AI results?
- Wait until the answers look correct.
- Open Extensions → AI for Sheets → 🚀 Use AI Formulas.
- Select the cells, rows, or columns you want to keep.
- In the This sheet card at the top of the sidebar, click Lock.
- A message shows how many cells were locked and how many were skipped.
How do I unlock cells?
Select the locked cells and click Unlock in the sidebar's This sheet card. The formulas come back from the đź”’ notes and can recalculate again.
How do I rerun cells that show errors?
Click Rerun errors in the sidebar's This sheet card. Only AI cells on the current sheet that show Error: or
#ERROR! run again. Other answers stay as they are.
Which formulas does Lock support?
=GEN=TRANSLATE=SENTIMENT=TAGS=WRITE=ANALYZE=SUMMARIZE=VISION=PDF=TRANSCRIBE=REPHRASE=SPAM=AISEARCH=IMAGEN=EDIT
Need help finding the right formula? See Formula reference.
Frequently Asked Questions
Can I undo a lock?
Yes. Select the locked cells and click Unlock in the sidebar. Pressing Undo right away also works.
Does locking make extra AI calls?
No. It keeps the answers already in your cells.
What if I delete the cell note?
Unlock reads the formula from the line that starts with đź”’. If you delete that line, the cell stays a plain value.