O'Reilly logo

Excel 2010 Made Simple by Abbott Katz

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required