Microsoft Office Tutorials and References
In Depth Information
Excel’s Ribbon User Interface
worksheets in your workbook, you can add them simply by clicking the New
Sheet button (indicated by the plus sign in a circle) that appears to the
immediate right of the last visible tab (see callout in Figure 1-8) or by selecting
Shift+F11.
Figure 1-8:
The Sheet
Tab scroll
buttons,
sheet tabs,
Next sheet,
Previous
sheet, and
New Sheet
buttons
enable you
to activate
your
worksheets and
add to them.
On the left side of the bottom of the Worksheet area, the Sheet Tab scroll
buttons appear followed by the actual tabs for the worksheets in your workbook
and the New Sheet button. To activate a worksheet for editing, you select it
by clicking its sheet tab. Excel lets you know what sheet is active by
displaying the sheet name in boldface type and underlining it to make its tab appear
connected to the current sheet.
One reason for adding extra sheets to a workbook
You may wonder why anyone would ever need
more than a single worksheet given just how
many cells it already contains. The truth is that
it’s all about how you choose to structure a
particular spreadsheet rather than running out of
places to put the data. For example, suppose
that you need to create a workbook that
contains budgets for all the various departments in
your corporation. You may decide to devote an
individual worksheet to each department (with
the actual budget spreadsheet tables laid out
in the same manner on each sheet) rather than
placing all the tables in different sections of the
same sheet. Using this kind of one-sheet-per-
budget layout makes it much easier for you to find
each budget, print each one as a separate page
of a report, and, if ever necessary, to consolidate
the data in a separate summary worksheet.
Search JabSto ::




Custom Search