How to find errors in Excel for Mac 2011 in a large sheet? For Excel for Windows, there's an option to search a sheet for errors and go straight to them, under the "Find and select" icon in the ribbon. 

Excel for Mac 2011 doesn't have a "Find and select" ribbon icon.

On a sheet without thousands of cells, how can you scan it for errors?
Depending on what your workbook's displaying,  

Edit > Find [#] (i.e. enter the hash sign # as your target text)
Within: [Workbook]
Search: [By Rows]
Look in: [Values]

 

may be less of a pain. 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 #. 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. 

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. For example, enter =2+C4, then delete column C. 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. This can stop recalculation from propagating a cascade of #REF! errors that takes a long while to unravel.

Hope this helps.