Microsoft Excel Tutorial for Beginners #30 - Show Formulas on a Spreadsheet

Visit MotionTraining at motiontrainingweb.com. You can buy a download of the complete 6-hour Excel Beginner video series (Excel 2003 and Excel 2010) + practice files at sellfy.com/p/QX6P/

See my interactive online courses including a 5-hour, 27-part intermediate course for Excel 2010/2013 users at curious.com/motiontraining?ref=lMwZe8vMKJw

In tutorial #30 learn how to show/hide the formulas on a spreadsheet using a keyboard shortcut or menu option. For Excel 2007 Click Formulas tab and find 'Formula Auditing'. The 'Show Formulas' button can be found here.

In Excel 2010 it's a bit more complicated! Click File tab and then click Options. In the options menu click 'Advanced' and scroll down to 'Display options for this worksheet'. You will find the 'show formulas.....' option here.

More tutorials soon.