Microsoft Office Tutorials and References
In Depth Information
Working with Multiple Worksheets
Chapter 11
Managing Large Amounts of Data
Generating References to
Other Worksheets
Sometimes you need to refer to information stored
in another worksheet—for example, when you have
a workbook with sheets for each company division,
along with a worksheet that totals the individual
worksheets. You can create a reference in the Totals
worksheet that instructs Excel to reference the
data in the various monthly worksheets. When you
create a reference to different sheet, Excel will use
the name of the sheet first, then the cell location.
Use the following steps to guide you:
Select the cell into which you want to enter a
2. Perform one of the following actions:
If you want to display a value located in
another cell on the same worksheet, type
the equals sign and then the cell address.
For example, type =A2. If the value in A2
changes, the cell with the reference to
A2 also changes (see Figure 11-9).
Figure 11-8
Assigning colors to worksheet tabs.
Reference Result
Right-Click Worksheet Tab
Optionally, right-click a worksheet tab and
choose Tab Color to display a Tab Color gallery.
When a worksheet with a colored tab is the current
worksheet, Excel does not display the tab color in
full. It displays only a colored line under the tab
name. The tab becomes full color when the
worksheet is not the active one.
Figure 11-9
Creating a reference to another cell.
If you want to display a value located in
a cell on a different worksheet but in
the same workbook, type the equals
sign. Next, click the worksheet tab
containing the cell you want to reference
Search JabSto ::

Custom Search