MS Excel Show me the..... FORMULAS!

Ever get someone else's spreadsheet and wonder how they arrived at their totals? Well, there are various ways to audit a spreadsheet for this information but a fun way is to do the following:

Open an existing spreadsheet (with pre-existing calculations of course) in Excel, enter your Tools menu and choose Options.  Under the View tab there should be a section for "window options", click to fill the check box for "formulas" and click OK.  Now your spreadsheet will display formulas in the cells instead of the calculated answers!  You can even print out your worksheet this way if you need to!  Follow these same steps to de-select this viewing option when you've seen enough and want your answers to once again display.  

O’Shea Toran
CURRICULUM VITAE
O’Shea Toran is a certified and published professional facilitator of technology and business skills learning. He has achieved internal training certifications from such companies as ExecuTrain, Productivity Point International and Gateway Computers and has won numerous awards for excellence in training delivery. For the last 19 years, O’Shea has enjoyed training everything from computer courses to business skills seminars to tennis lessons since he is also a teaching pro certified by the USNTA.

Software Training Courses
Software training courses; MS Office, QuickBooks and other business software and word processing programs. - [series list]