Chapter 9

Managing Your Workbook

Some worksheet tasks require you to step back from those molecule-sized cells that occupy the better part of your attention and take a larger look instead at the entire worksheet—or sometimes, the entire work book. You may, for example, decide you need to supplement those default three worksheets with a fourth, or write a formula that reaches over into a second sheet and references a data cell from there. Or you may want to subject several sheets to the same formats for the sake of uniformity, or protect a sheet so that no one will be able to overwrite all the intricate work you've committed to its cells. Well, we're going to address that grab bag of worksheet- and workbook-wide topics right here.

Adding Worksheets ...

Get Excel 2010 Made Simple 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.