Hi,

Can you please show me how to display all formulas in a spreadsheet? I already calculated the data using formulas in a spreadsheet, now I just want display the formulas. Are there any keyword shortcuts.

Many thanks.

In Excel 2003: Tools, Options click on the check box that says "Formulas"

In excel press "Ctrl" and ~ do it again to hide formulas

What is the formular to find the average?

Like the formual like this?

https://encrypted-tbn1.gstatic.com/images?q=tbn:ANd9GcSZo3EYo4DXSnHRGPGkYdf38c4WEeucM 1_2rSYxyYo8NdtcSRXq