Microsoft Office Tutorials and References

In Depth Information

EX 106

Excel Chapter 2
Formulas, Functions, Formatting, and Web Queries

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

automatically 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.

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

C6161_EXC_02.4c.indd 106

C6161_EXC_02.4c.indd 106

3/6/07 3:28:41 PM

3/6/07 3:28:41 PM