Add a Picture to a Comment Excel 2007

Have you ever considered adding a picture to a comment in Microsoft Word or Excel? The thought crossed my mind while I was busy preparing exercises for one of my courses. With a little effort yes, you can.   The process of inserting a picture into a comment is not so obvious. I have written the process for Excel 2007 with screen shots to help you. Its not essential but adds an element of fun.

Microsoft Excel: Error Checking

Microsoft Excel has some quirky settings, one of them being the error checking.  Have you noticed that when you create formulas in Microsoft Excel you sometimes get a small green triangle displayed in the the top left corner of a cell?  The little green triangle tells you that excel is checking for common errors and provides you with the option of correcting them.

Types of errors

Errors that cannot return a result (such as dividing a number by zero) require attention anddisplay an error value in the cell (in this case, #DIV/0!). Other errors can be less serious, such as a formula that appears to be inconsistent with adjacent formulas. The formula returns a correct result, but the error advises you that you should examine the formula.

By clicking on the green triangle you will get an exclamation mark, click on this, a pop up list of available options.  You can resolve an error by using the options that are displayed, or you can ignore the error by clicking Ignore Error. If you ignore an error in a particular cell, the error in that cell does not appear in further error checks. However, you can reset all previously ignored errors so that they are visable again.

Read More