Microsoft Office Tutorials and References
In Depth Information
Verifying Formulas Using Range Finder
To Save a Workbook Using the Same File Name
Earlier in this project, an intermediate version of the workbook was saved using the fi le name, Silver Dollars
Stock Club Portfolio Summary. The following step saves the workbook a second time using the same fi le name.
1 Click the Save button on the Quick Access Toolbar to save the workbook on the USB fl ash
drive using the fi le name, Silver Dollars Stock Club Portfolio Summary.
Why did Excel not display the Save As dialog box?
When you save a workbook a second time using the same fi le name, Excel will not display
the Save As dialog box as it does the fi rst time you save the workbook. Excel automati-
cally stores the latest version of the workbook using the same fi le name, Silver Dollars
Stock Club Portfolio Summary. You also can click Save on the Offi ce Button menu or press
SHIFT + F 12 or CTRL + S to save a workbook again.
Verifying Formulas Using Range Finder
One of the more common mistakes made with Excel is to include a wrong cell reference in a
formula. An easy way to verify that a formula references the cells you want it to reference
is to use Excel’s Range Finder. Use the Range Finder to check which cells are referenced
in the formula assigned to the active cell. Range Finder allows you to make immediate
changes to the cells referenced in a formula.
To use Range Finder to verify that a formula contains the intended cell references,
double-click the cell with the formula you want to check. Excel responds by highlighting
the cells referenced in the formula so you can check that the cell references are correct.
To Verify a Formula Using Range Finder
The following steps use Range Finder to check the formula in cell J4.
1
Double-click cell J4 to activate
Range Finder (Figure 2–29).
cells referenced in
formula in active cell
are highlighted with
corresponding colors
2
Press the ESC key to quit Range
Finder and then select
cell A18.
color of cell references
corresponds to color of
highlighted cells
Figure 2–29
 
 
Search JabSto ::




Custom Search