Apple numbers User Manual

Page of 295
146
Chapter 7
    Working with Text 
 
To automatically convert the letters in “1st,” “2nd,” “3rd,“ and so on into superscripts, 
select “Superscript numerical suffixes.”
To set Numbers to automatically detect that something you’ve typed is an email 
address or a URL, select “Automatically detect email and web addresses.” Email and 
web addresses you type automatically become hyperlinks for Mail or Safari.
To use automatic list generation, select “Automatically detect lists.” 
To replace one or more characters with one or more different characters, select “Symbol 
and text substitution.” Then use the rows in the table to define and activate specific 
substitutions. For example, when you type (c), you can have Numbers automatically 
convert it to © by putting a checkmark in the On column. To add a row to the table to 
define your own substitution, click the Add (+) button. To remove a selected item, click 
the Delete (–) button.
After you specify substitution settings, they’ll apply to any text you change or add in 
any Numbers spreadsheets.
Inserting a Nonbreaking Space
You can insert a nonbreaking space between words to make sure that the words 
always appear in the same line of text. 
To insert a nonbreaking space:
m
Press the Space bar while holding down the Option key.
Checking for Spelling Mistakes
Numbers can catch spelling errors in your spreadsheet and help you find alternative 
spellings for misspelled words.
Finding Misspelled Words
You can set the spell checker to flag spelling errors as you type, or you can check your 
entire spreadsheet or selected text at any time. 
Misspelled words appear with a red dashed line below them. 
Here are ways to find misspelled words:
m
To check spelling as you type, choose Edit > Spelling > Check Spelling as You Type.
To turn off spell checking as you type, click Edit > Spelling > Check Spelling as You Type 
to deselect it (make sure the checkmark is not visible next to the menu command).
m
To check spelling from the insertion point to the end of the spreadsheet, click to place 
the insertion point and choose Edit > Spelling > Check Spelling. To limit spell checking 
to a specific part of the spreadsheet, select the text you want to check before choosing 
the command.