Chapter 7. How to work a workbook

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—peacefully 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 ...

Get Microsoft Excel 2013 Inside Out now with O’Reilly online learning.

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