Chapter 7. Working With Multiple Sheets

A worksheet is a spacious place-16 billion or so cells at your disposal, each one accessible in a flash at the tap of a keyboard. The Name Box is your Excel—based satnav; type any address therein and the Box doesn't tell you how to get there—it takes you there, in a hot second.

But in spite all of that digital terra firma and ease of navigation, Excel gives you more, three worksheets by default, so you won't have to feel deprived—not with those 48 billion cells at the ready. But if even you don't need 48 billion cells, you might need three—or more—worksheets. Because while it's true that virtually all of the work you need to do in a workbook could be accommodated by one worksheet, sometimes it's the way data ...

Get Beginning Microsoft Excel 2010 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.