Home | Contact | Rants | Software Tips | GTMO | Web Design | Jokes | Windows Tips | Quotes | About Me
 
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...
Microsoft excel tips format tables query spreadsheet excel help reports macros formula excel cells autosum sort data
[Software Tips] [Microsoft Excel]
 
Show all Formulas in Excel

Microsoft excel tips format tables query spreadsheet excel help reports macros formula excel cells autosum sort dataWhen 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.
 
 
 
 
 
 
  Back to Top  
 
Lunatic Fringe Enterprises
Guantanamo Bay, Cuba
Revised: Saturday, May 3, 2008 11:12 PM
Microsoft excel tips format tables query spreadsheet excel help reports macros formula excel cells autosum sort data
 

Home | Contact | Rants | Software Tips | GTMO | Web Design | Jokes | Windows Tips | Quotes | About Me
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