Excel 2010 Made Simple

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