Microsoft Office Tutorials and References
In Depth Information
Working with Multiple Worksheets
Corresponding Data
Reference to Elsewhere
in the Workbook
Cell Reference
Figure 6-13
Reference a cell in the same worksheet
with a simple address.
Cell Reference
Figure 6-12
Don’t retype data—simply redisplay it when needed.
3. Perform one of the following actions:
If the cell whose contents you want to
display is located in the current
worksheet, scroll if necessary so you can see
the cell, and then click it. You can also
simply type the cell’s address, such as
=D4. (See Figure 6-13.)
Figure 6-14
Reference a cell in another worksheet by
including a reference to that sheet.
If the cell whose contents you want to
display is located on another worksheet,
click that worksheet’s tab. Then scroll if
necessary so you can see the cell, and
click it. If you want to type the cell’s
address yourself, you need to follow the
rules: type the name of the worksheet in
single quotations (as in ‘Unit Prices’),
followed by an exclamation point (!),
followed by the cell address—for example,
type =‘Unit Prices’!B8. (See Figure 6-14.)
Referencing a Cell in a Formula
You can reference a cell and use its contents
in a formula. For example, you might want
to reference the price of an item stored on
another worksheet, and multiply it by the
number of items sold this month—without
actually displaying the price on the sales
worksheet. For example, you might type
=‘Unit Prices’!B8*C20.
4. Press Enter. The contents of the referenced
cell appear in the result cell you selected in
Step 1.
 
Search JabSto ::




Custom Search