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 ﬁ le name, Silver Dollars
Stock Club Portfolio Summary. The following step saves the workbook a second time using the same ﬁ le name.
1 Click the Save button on the Quick Access Toolbar to save the workbook on the USB ﬂ ash
drive using the ﬁ 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 ﬁ le name, Excel will not display
the Save As dialog box as it does the ﬁ rst time you save the workbook. Excel automati-
cally stores the latest version of the workbook using the same ﬁ le name, Silver Dollars
Stock Club Portfolio Summary. You also can click Save on the Ofﬁ ce Button menu or press
SHIFT + F 12 or CTRL + S to save a workbook again.
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.
The following steps use Range Finder to check the formula in cell J4.
• Double-click cell J4 to activate
Range Finder (Figure 2–29).
cells referenced in
formula in active cell
are highlighted with
• Press the ESC key to quit Range
Finder and then select
color of cell references
corresponds to color of