Numbers for iOS (iPad): Create or open a spreadsheet

Create or open a spreadsheet

In Numbers, you can create engaging spreadsheets by placing multiple tables, charts, photos, and text on the same sheet, in whatever layout you prefer. Numbers offers a variety of templates with different types of tables from which to choose. Use the Blank template to begin with an empty table.

You can also open and edit a spreadsheet in Numbers ’09, Microsoft Excel, or comma-separated value (CSV) file formats, but first you must import it to your iPad, iPhone, or iPod touch. To learn how to import a spreadsheet, see the topics in the section: .

You can see all your available spreadsheets in Spreadsheets view.

Image of document manager displaying several spreadsheets

Create a new spreadsheet:

  1. In Spreadsheets view, tap Add presentation button in the top-left corner of the screen, and then tap Create Spreadsheet.

    If you don’t see these thumbnail images when you open Numbers, it means a spreadsheet is already open and ready for editing or viewing. Tap Spreadsheets in the top-left corner of the screen to return to Spreadsheets view.

  2. Tap the template you want to use. (Scroll to see all templates.)

    A new spreadsheet opens. If you selected the Blank template, a short, empty table appears on the otherwise blank sheet. If you selected another template, the table contains placeholder data, and the sheet may also include charts, placeholder text, and images.

    Image of new spreadsheet
  3. Double-tap in a table cell, and then enter your own data.

    To learn about adding table columns and rows, see Add, remove, resize, and rearrange table rows and columns. To learn about adding your own data, see Enter data into a table cell. To learn about moving tables and adding new ones, see Place and style tables.

  4. To see more of the table, do either of the following:

    • To scroll the table rows and columns, place your finger in the center of the table and drag up, down, left, or right.

      By default, header rows and columns stay put as you scroll through the table. Only the interior rows and columns move, so that you don’t lose your position in the table. To scroll the header rows, place your finger in the header row and then drag up or down. To scroll the header columns, place your finger in the header column and then drag left or right. You can turn off this option in the Headers inspector. To learn how, see the task about freezing header rows and columns in Place and style tables.

    • To zoom in or out of the table, pinch your fingers closed or pinch them open.

      To learn about finger gestures in Numbers, see Touchscreen basics and Manipulate objects in Numbers.

  5. Type your own text into text placeholders and replace the image placeholders with your own images.

    To learn about working with text and images, see the topics in the section: .

Open an existing spreadsheet:

You can import a spreadsheet through iTunes, email, or iCloud. To learn how to import a spreadsheet using any of these methods, see the topics in the section: .

Tap its thumbnail image in Spreadsheets view.

If the spreadsheet was created on your computer and stored in iCloud, you can choose to open a copy, preserving the original. The opened spreadsheet is converted to an iOS format, which might look different from the original.

Last Modified: Sep 26, 2012
  • Last Modified: Sep 26, 2012
  • Article: PH3364
  • Views:

  • Rating:
    • 20.0

    (1 Responses)

Additional Product Support Information