Better Sheets All add-ons

Show All Formulas

Show formulas in Google Sheets™ from every tab, on one list you can search

Built by Better Sheets · Free on the Google Workspace Marketplace · No account needed

What Show All Formulas does

Show All Formulas shows every formula in your Google Sheets™ spreadsheet on one tab: the tab, the cell, the formula, the result it shows right now and the formula in R1C1 form. Search your formulas, find every VLOOKUP or broken reference, then click any cell address to jump straight to that formula.

  • ✅ One click: open Extensions, then Show All Formulas, then Show all formulas.
  • ✅ Every cell address is a link. Spot a formula you want to fix, click its cell and you land right on it, on the right tab. No hunting through tabs and rows.
  • ✅ Every tab at once. View → Show formulas in Google Sheets™ only shows the formulas of one tab, in the cells, and hides the results.
  • ✅ Search formulas: press Ctrl+F to find every VLOOKUP, QUERY, IMPORTRANGE or #REF! in the file.
  • ✅ Spot the odd one out: an R1C1 column shows each formula the same way for every row it was copied to, so a formula someone changed by hand stands out.
  • ✅ Copy the whole Formula column to document a sheet, hand it to a teammate, or paste it into an AI chat to have it explained.
  • ✅ Run it again any time to refresh the list. Your other tabs are never changed.
Show All Formulas in Google Sheets: a tab listing every formula in the spreadsheet with its tab, cell, formula and result

How Show All Formulas uses your Google data

  • Adds a menu in Google Sheets™ with one job: show every formula in the spreadsheet you are working in.
  • Reads the formulas and the values they show on each tab, and writes the list to a tab called All Formulas. It does not change any other tab.
  • Runs entirely inside Google Sheets™. It does not send your spreadsheet data anywhere else.

Google permissions it asks for

See and change the spreadsheet it is installed in https://www.googleapis.com/auth/spreadsheets.currentonly
Show its menu and sidebar inside Google Sheets™ https://www.googleapis.com/auth/script.container.ui

Full details: Show All Formulas Privacy Policy · Terms of Service

Google Sheets™ is a trademark of Google LLC.