iWork® For Dummies,® 2nd Edition

Chapter 14

Creating and Editing Numbers Documents

In This Chapter

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

As with all the iWork apps, the Mac version of Numbers has more options for customization than the iOS versions. Because many people (perhaps even most!) don’t customize their spreadsheets in Numbers or any other spreadsheet program, this drawback isn’t significant for them. If you do want or need the customization, you can always do it in Numbers for Mac and then work with the spreadsheets in Numbers for iOS.

Creating Sheets and Tables

Unless you’re using a template without structural ...