Working with spreadsheets/Spreadsheet calculations/Formulas

Formula View
Occasionally its handy to be able see all of your formulas (insead of the results) in your spreadsheet. Click on:


 * Formulas > Formula Auditing > Show Formulas

Or use the keyboard shortcut Ctrl ~

If you print from this view you will print your formulas out. Press Ctrl~ again to revert the sheet back to normal.

Formatting a spreadsheet
Before we go on to add more data and formulas to the spreadsheet, lets look at how to use some more features for formatting in Excel :

Extending the spreadsheet
We often need to change a spreadsheet to meet future needs. In the next activity we will add more data and formulas.