Apple numbers User Manual

 Designing Your Own Numbers Spreadsheet Templates

 

  Create Initial Spreadsheet Content

You can use predefined content to model the look of a finished spreadsheet or to 
provide instructions and other productivity aids for template users.

Add tables, charts, text boxes, images, shapes, and other initial content to your 
templates to help users be more productive and to make the objects in the 
spreadsheet visually appealing. 

For example, you can:

 Add names to tables and titles to charts and their axes
 Add formulas and other predefined content to table cells
 Set up cells so their values are displayed in particular ways, for example, using a 

number format or checkboxes

 Create text boxes or comments that provide instructions and suggestions for using 

the template

 Use color to heighten the prominence of particular elements in tables and charts

When you drag your own image, movie, or audio file to a media placeholder, your 
media is automatically sized and positioned for you. You can easily replace media in the 
media placeholder by dragging a new file to it; you don’t have to delete the old file 
first.

Add an image, audio file, or movie to the spreadsheet.

See “Importing an Image” on page 171, “Adding a Sound File” on page 177, and “Adding 
a Movie File” on page 177 for instructions.

Select the imported object and move it to the location where you want it to be in the 
spreadsheet, as “Moving Objects” on page 150 describes.

Format the imported object, as “Modifying Objects” on page 154 describes.

Select the object, and then choose Format > Advanced > Define as Media Placeholder.

To delete a media placeholder, select it, and then press the Delete key.