#REF!

#REF!

Welcome to the empty lot at the edge of SheetCity.

Every other block in this city is zoned, numbered, and full of something useful — a formula, a fix, a guide. This one’s just a vacant cell reference, pointing at an address that got demolished, renamed, or never built. Somewhere a link broke, a page moved, or you typo’d a URL the way most of us fat-finger a cell reference at 4:58 PM on a Friday.

No amount of IFERROR() is going to fix it from here. Good news: unlike a real broken formula, this one’s easy to trace back to downtown.


Get back on the map

  • City Hall (homepage) — back to A1, where every sheet begins
  • The Library (blog) — guides, fixes, and formula deep-dives, all properly shelved
  • The Workshop (Select Special Cells) — the tool that finds things so you don’t have to
  • The Marketplace district — install it, find blanks, formulas, and duplicates in one click

If you were looking for something specific

Try searching again, or head to the Library and browse by topic. If a road sign in this city pointed you here by mistake, that’s on us, not you — even the best-planned cities have a pothole or two.


Fun fact: in Google Sheets, a #REF! error means a formula is pointing at a cell that no longer exists — a building that’s not on the block anymore. That’s exactly what happened here. We can’t Ctrl+Z a demolished address, but we can walk you back to a part of town that’s still standing.

Take me back to City Hall →

Primary Sidebar

Recent Posts

  • How to Find Formula Cells in Google Sheets (Step-by-Step)
  • How to Select Blank Cells in Google Sheets
  • Disable Gemini in Google Sheets Easily
  • How to Select Duplicate Cells in Google Sheets™

Categories

  • Data Cleaning
  • Formulas and Functions
  • UI/UX