Apple numbers User Manual

 Working with a Numbers Spreadsheet

 

You can create a new Numbers spreadsheet by importing a document created in 
Microsoft Excel or AppleWorks 6. Numbers can also import files in comma-separated 
value (CSV) format, tab-delimited format, and Open Financial Exchange (OFX) format.

From AppleWorks, you can only import spreadsheets.

m

Drag the document to the Numbers application icon. A new Numbers spreadsheet 
opens, and the contents of the imported document are displayed.

m

Choose File > Open, select the document, and then click Open.

m

You can import Address Book data to quickly create tables that contain names, phone 
numbers, addresses, and other information for your contacts. See “Using Address Book 
Fields” on page 179 for instructions.

If you can’t import a document, try opening the document in another application and 
saving it in a format Numbers can read, or copy and paste the contents into an existing 
Numbers spreadsheet.

You can also export Numbers spreadsheets to Microsoft Excel, PDF, and CSV files. See 
“Exporting to Other Document Formats” on page 186 for details.

There are several ways to open a spreadsheet that was created using Numbers.

m

To open a spreadsheet when you’re working in Numbers, choose File > Open, select 
the spreadsheet, and then click Open.

m

To open a spreadsheet you’ve worked with recently, choose File > Open Recent and 
choose the spreadsheet from the submenu.

m

To open a Numbers spreadsheet from the Finder, double-click the spreadsheet icon or 
drag it to the Numbers application icon.

If you see a message that a font or file is missing, you can still use the spreadsheet. 
Numbers lets you choose fonts to substitute for missing fonts. Or you can add missing 
fonts by quitting Numbers and adding the fonts to your Fonts folder (for more 
information, see Mac Help). To make missing movies or sound files reappear, add them 
to the spreadsheet again.