Microsoft® Excel® 2010 Inside Out

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 2010, 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 automatically.

If you start Excel and then open an existing Excel file, Book1 disappears unless you have edited it. You can open as many workbooks as you like until your computer runs out of memory.

Note

For more about working with multiple windows, see Opening Multiple Windows for the Same ...