Basic Excel Formulas

Microsoft excel tips format tables query spreadsheet excel help reports macros formula excel cells autosum sort data

Microsoft Office 2003: Excel
Basic Excel Formulas and Savage Amusement...

Show all Formulas in Excel

When you're dealing with a large worksheet, you may have trouble finding all the formulas. All you see in the worksheet are the results. You can show the formulas in a worksheet by holding down [Ctrl] key and pressing the Tilde key (~.) This is the key to the left of the 1 key.

When you press [Ctrl]+[Tilde], Excel will display all the formulas in the worksheet. To get back to normal view, press [Ctrl]+[Tilde] again.

Microsoft excel tips format tables query excel tricks spreadsheet excel reports macros tips formula cells autosum sort data Microsoft excel tips format tables query excel tricks spreadsheet excel reports macros tips formula cells autosum sort data Microsoft excel tips format tables query excel tricks spreadsheet excel reports macros tips formula cells autosum sort data Microsoft excel tips format tables query excel tricks spreadsheet excel reports macros tips formula cells autosum sort data