Excel: Sounds Good (Page 1) 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41

Display the Formulas There are times when you may need to display and print the formulas in your spreadsheet.   Try This: Display the Formulas Open Formulas and Functions.xlsx. Go to the Conditional Formulas sheet. Go to  Formulas ->Formula Auditing. Select: Show Formulas.     What Do You See? Now the cells show all of the formulas in this spreadsheet, instead of the values.   No brag...just fact! You've got to admit that looking at a spreadsheet in this view is like showing off.

Formulas ->Formula Auditing ->Show Formulas