The real power of Microsoft Excel lies in its formulae. However, as a Microsoft Excel user would know well, making mistakes with formulae are common since they are complicated. You can fix this by ...

When you see the #VALUE error, it means that there is something wrong with the way the formula is typed, or there is something wrong with the cells you are referencing.

If the check box is selected, it uses Excel's Form Controls and you may move or delete it. If it didn't select, the check box uses ActiveX controls and you must use Design Mode to remove it.

REMOVE ARROWS As you can see in the screenshot for Trace Precedents, Excel places arrows on the spreadsheet to illustrate. Remove Arrows is a tool that allows you to remove the arrows that are created ...