Working with formulas in Excel can be frustrating. We’ve all had this happen—you look at a spreadsheet formula and notice that the math is not working. There are so many things that could be wrong. It could be you’ve indicated the wrong cells; maybe it is adding when it should be subtracting. The list is endless. To fix it you have to take a look at all the formulas to see what’s wrong.
You could click on each cell individually to look at the formula associated with that cell. That can take a long time, and still won’t give you the big picture. The easiest way is to look at all the formulas at once!
Here’s how:
- Open the document. Press ~ (the tilde).
- All the formulas will be displayed.
- When you want to go back to the document, press ~ again.
Contact Reba Nance at reban@cobar.org if you have questions.
Comments on this entry are closed.