User Guide

Inserting Page Numbers and Other Changeable Values
You can insert values such as page numbers, page count, lename, and date and time
in a spreadsheet by using formatted text elds, which are automatically updated by
Numbers when these values change. Although values such as these are common in
headers and footers (see “Adding Headers and Footers to a Sheet” on page 41), you can
insert formatted text elds anywhere in your spreadsheet.
Here are ways to insert formatted text elds:
To add page numbers, place the insertion point where you want the page number to m
appear, and then choose Insert > Page Number.
To change the page number format, Control-click a page number and choose a new
number format.
To add the total page count, place the insertion point where you want the page count m
to appear, and then choose Insert > Page Count.
To include the total page count with each page number, such as “2 of 10,” add a page
number, type “of,” and then choose Insert > Page Count.
To change the page count format, Control-click a page count and choose a new
number format.
To add and format the date and time, place the insertion point where you want the m
value to appear, and then choose Insert > Date & Time.
To change the date and time format, Control-click the date and time value, choose
Edit Date & Time, and then choose a date and time format from the pop-up menu.
If you want the spreadsheet to always show the current date and time, select
“Automatically update on open.”
To add the spreadsheet’s lename, place the insertion point where you want the m
lename to appear, and then choose Insert > Filename.
To display the le directory path, double-click the lename and select “Show
directory path.”
To display the le extension, double-click the lename and select “Always show
lename extension.”
Automatically Substituting Text
Numbers can be set to recognize and replace text you don’t want with text you do
want. For example, when you type “teh,” Numbers can automatically change it to “the.”
To set up automatic text substitution:
1 Choose Numbers > Preferences.
2 Click Auto-Correction and specify settings as desired.
186 Chapter 8 Working with Text