One of the benefits of Microsoft Excel is that you can set up formulas ahead of time which will automatically update as you enter new data. Some formulas, unfortunately, are mathematically impossible without the requisite data, resulting in errors in your table such as #DIV/0!, #VALUE!, #REF!, and #NAME?. Here’s how to hide those errors with some help from the IF and ISERROR functions.
How to Hide Cells in Excel for Mac OS X
Apple’s Numbers spreadsheet app, part of the company’s iWork productivity suite, makes it easy for users to create beautiful tables, but lacks the power and compatibility of Microsoft Excel. For those stuck with Excel on Mac OS X, however, manual formatting can still be used to improve the look of your tables. One of the most useful steps is to hide unused cells, mimicking the look of Numbers. To hide cells in Excel for Mac, first create your table, making…