Microsoft Office Tutorials and References
In Depth Information
The Workings of Workbooks
Notice the existence of an object hierarchy : The Excel object contains workbook objects, which
contain worksheet objects, which contain range objects. This hierarchy is called Excel’s object
model. Other Microsoft Office products have their own object model. The object model concept
proves to be vitally important when developing VBA macros. Even if you don’t create macros,
you may find it helpful to think in terms of objects.
The Workings of Workbooks
The core document of Excel is a workbook. Everything that you do in Excel takes place in a workbook.
Beginning with Excel 2007, workbook “files” are actually compressed folders. You may be
familiar with compressed folders if you’ve ever used a file with a .zip extension. Inside the
compressed folders are a number of files that hold all the information about your workbook, including
charts, macros, formatting, and the data in its cells.
An Excel workbook can hold any number of sheets (limited only by memory). The four types of
h Chart sheets
h MS Excel 4.0 macro sheets (obsolete, but still supported)
h MS Excel 5.0 dialog sheets (obsolete, but still supported)
You can open or create as many workbooks as you want (each in its own window), but only one
workbook is the active workbook at any given time. Similarly, only one sheet in a workbook is the
active sheet. To activate a different sheet, click its corresponding tab at the bottom of the
window, or press Ctrl+PgUp (for the previous sheet) or Ctrl+PgDn (for the next sheet). To change a
sheet’s name, double-click its Sheet tab and type the new text for the name. Right-clicking a tab
brings up a shortcut menu with some additional sheet-manipulation options.
You can also hide the window that contains a workbook by using the View
command. A hidden workbook window remains open but not visible. Use the View
command to make the window visible again. A single workbook can display in multiple windows
New Window). Each window can display a different sheet or a different
area of the same sheet.
The most common type of sheet is a worksheet — which you normally think of when you think of
a spreadsheet. Excel 2010 worksheets have 16,384 columns and 1,048,576 rows.
Versions prior to Excel 2007 support only 256 columns and 65,536 rows. If you open
such a file, Excel 2010 enters compatibility mode to work with the smaller worksheet
grid. In order to work with the larger grid, you must save the file in one of the Excel
2010 formats. Then close the workbook and reopen it.