Importing a document, Opening an existing spreadsheet – Apple Numbers '08 User Manual
Page 33
Chapter 2
Working with a Numbers Spreadsheet
33
Importing a Document
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.
Here are ways to import a document:
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.
Opening an Existing Spreadsheet
There are several ways to open a spreadsheet that was created using Numbers.
Here are ways to open a spreadsheet:
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.