iWork® '09 For Dummies®

Chapter 13. Creating and Editing Numbers Documents

In This Chapter

• Creating and formatting tables

• Using and formatting headers

• Taking advantage of cell formatting

Sometimes you can use an iWork template without any changes: Just type your text into a newsletter layout in Pages, use Keynote slides with no changes except for your text, or use a Numbers template just by typing your data. Other times, you want to customize the template in various ways, such as providing custom formatting for cells and creating your own headers for rows and columns. This chapter gets into the structure of Numbers documents, focusing on sheets and tables as well as basic formulas and common procedures such as sorting and filtering data.

Creating Sheets and Tables

Unless you're using a template without structural changes, such as adding new sheets, charts, or tables, you'll find yourself creating these objects. Chapter 15 is your resource for charts; this section shows you how to create new sheets and tables.

Creating sheets

You use sheets to organize your tables, charts, and other iWork elements such as shapes, text boxes, and media. Sheets are often designed to be printed, so iWork provides a print view so you can see what the sheet will look like when printed.

You can put all your charts and tables into a single sheet, or you can put one chart or table into each sheet. Most of the time, you decide which tables go into which sheets by taking into account what is most logical and how you need to print your data ...