The Workspace 15
While tabs and buttons in the Ribbon interface provide an immediate access to differ-
ent commands, the buttons cannot be moved from one tab to another. You also cannot
add or delete buttons from the Ribbon itself. However, Excel has a built-in capability
to change button sizes and labels to suit the display or monitor characteristics. This is
demonstrated in Figure 2.3 where the Ribbon with active Home tab is shown. Compar-
ing the buttons on the Ribbon in Figure 2.3 with those in Figure 2.1, you will note
that not all buttons are being displayed although they remain available upon clicking
the corresponding panel. For example, when you click the Styles panel, the associated
buttons will appear in the form of a drop down list.
The Workspace
We work with Excel to create or modify a workbook. A workbook is analogous to
a document in Microsoft Word. An Excel workbook is made up of worksheets and
chart sheets. The chart sheets are special sheets for storing charts. The worksheets are
also called spreadsheets. The number of worksheets and chart sheets that a workbook
might hold is limited only by the computer’s memory; Excel has no upper limit on the
number of sheets. When you open a new Excel file, it is given a default name of Book1.
The subsequent new files are given the default names of Book2, Book3, etc. The name
of the workbook is shown in the title bar of the Excel window. Once you save the file
with a name of your liking, the default name is replaced by the assigned name.
You can have many workbooks open simultaneously but only one workbook is desig-
nated as the active workbook at a time. Similarly, only one worksheet can be the
active worksheet at a time. A worksheet must be active before we can work with it.
Each worksheet has a unique name. When a new workbook is opened, it opens with
three sheets with default names of Sheet1, Sheet2, and Sheet3. The sheet names appear
as sheet tabs located near the bottom left of the Excel window. The active worksheet
is always highlighted and you can switch between different sheets by clicking on sheet
tabs or by scrolling through sheet tab scroll buttons, which are located to the left of the
sheet tabs. You can add more sheets, if needed, by using the Insert Worksheet button
located next to Sheet3 tab.
Figure 2.3
A resized Ribbon showing fewer buttons.

Get Computing with Excel and VBA now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.