Microsoft Office Tutorials and References
In Depth Information
Chapter 7: How to work a workbook
How to work a workbook
Managing multiple workbooks ....................173
Opening multiple windows for the same
Hiding and protecting workbooks .................182
IN EARLY VERSIONS of Microsoft Excel, worksheets, charts, and macro sheets were stored as
separate documents. Since Excel 5, however, all these types of data—and more—peace-
fully coexist in workbooks. You can keep as many worksheets containing as many
different types of data as you want in a workbook, you can have more than one workbook open
at the same time, and you can have more than one window open for the same workbook.
The only limitations to these capabilities are those imposed by your computer’s memory
and system resources.
Managing multiple workbooks
This chapter describes how to protect workbooks, how to use more than one workbook at a
time, and how and why to split your view of a workbook into multiple windows. Generally,
when you start Microsoft Excel 2013, a blank workbook appears with the provisional title
Book1 . The only exceptions occur when you start Excel by opening an existing workbook
or when you have one or more Excel files stored in the XLStart folder so that they open
If you start Excel and then open an existing Excel file, Book1 disappears unless you edited
it. You can open as many workbooks as you like until your computer runs out of memory.
For more about working with multiple windows, see “Opening multiple windows for the
same workbook” later in this chapter. For more information about the XLStart folder, see
“Opening files when you start Excel” in Chapter 2, “Exploring Excel fundamentals.”
Navigating between open workbooks
If you have more than one workbook open, you can activate a particular workbook in any
of the following ways:
Click its window, if you can see it.
● Press Alt+Tab, which activates the next open window (including any non-Excel
windows you have open).