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. 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |