Microsoft Office Tutorials and References
In Depth Information
Chapter 4: Getting More Out of Formulas
Paste a Formula’s Result ..................................................................................................... 94
Show Formulas Instead of Results..................................................................................... 96
Use a Watch Window to Monitor a Cell Value ................................................................ 98
Use Absolute Cell References in a Formula ................................................................... 100
Create an Array Formula................................................................................................... 102
Apply Range Names to Formulas .................................................................................... 104
Create a Link to Another Worksheet............................................................................... 106
Combine Two Ranges Arithmetically............................................................................... 108
Troubleshoot a Formula by Stepping Through Each Part............................................ 110
Skip Data Tables When Calculating Workbooks............................................................ 112
Turn On Iterative Calculations.......................................................................................... 114
Display Text Rather than Error Values............................................................................. 116
Check for Formula Errors in a Worksheet...................................................................... 118
Audit a Formula to Locate Errors..................................................................................... 120
 
Search JabSto ::




Custom Search