Microsoft Office Tutorials and References
In Depth Information
Clicking Through the Worksheets
For example, you may want to compose a collection of complex formulas on one
worksheet and present the results on another. That’s what Excel dashboards do; these
are workbooks in which complex number crunching is performed on one sheet, and an
assortment of charts built on those numbers is laid out on another worksheet—the one
that viewers will see (and as you’ll see, worksheets can be completely hidden from view,
too, even as the data on them remains usable).
Another reason you might want to deploy more than one worksheet is to place the same
kind of data in the same addresses across worksheets. That means something like this:
If you’re running a small business, you could assign each employee his or her own
worksheet and enter the same information for each in the same cell on the respective
worksheets—say, every employee name in that sheet’s cell A1, the social security
number in cell A2, salary in A3, and so on. This approach gives your data entry a
uniformity that enables you to easily find equivalent information in the same location
across sheets.
Still another reason to use multiple worksheets is a practical one. You may need to enter
a large variety of information—say, several different tables—and rather than commit all
of these to one worksheet (which would require considerable scrolling up and down the
sheet in order to see it all), you could place some tables on another sheet, which you
could access more efficiently by just clicking a sheet tab and viewing that data straight
away.
But let’s now turn to a workbook and introduce a few features of worksheets—in the
plural.
Clicking Through the Worksheets
As indicated, Excel starts you off with three worksheets, called Sheet1, Sheet2, and
Sheet3 by default, though you can rename any sheet, as you’ll see. You’ll find tabs
representing the sheets in the lower left of your screen, as shown in Figure 9–1.
Figure 9–1. Keeping tabs on your sheets : The three default sheets
TIP: You can change the three-sheet default allotment for all new workbooks by clicking File
Options and entering a different value in the Include this many sheets field.
Click any tab and you’ll be taken to that worksheet, which should look just like any other
one. As already indicated, all the addresses on the sheets are identical, meaning that
their cell references are the same (which raises a question I’ll answer in a little while:
How exactly does one differentiate between cell S12 on Sheet1 and cell S12 on
Sheet2?).
 
Search JabSto ::




Custom Search