This can stop recalculation from propagating a cascade of #REF! errors that takes a long while to unravel. If recalculation is set to manual, the cell will continue to show an unchanged value, but the formula will become =2+#REF! You can find cells in this state by changing the search parameter to Within: Formulas.
For example, enter =2+C4, then delete column C.
If you want to search for errors without recalculating, you may have cells which display a calculated value that's destined to turn into an error. Even if you have dozens of hash signs in non-error cells, this will be a lot faster than having to wade through the Edit > Go To… dialog on every sheet. This Excel tutorial explains how to change column headings from numbers (1, 2, 3, 4) back to letters (A, B, C, D) in Excel 2011 for Mac (with screenshots. In most of my workbooks, the only cells displaying the hash sign are error messages, and as far as I know, all Excel error values (#DIV/0, #NAME?, #REF! etc.) display text starting with #. enter the hash sign # as your target text) Depending on what your workbook's displaying,Įdit > Find (i.e.
