How to Make a Spreadsheet on a Mac

By Bennett Gavrish

Numbers is part of the iWork software package.
i Justin Sullivan/Getty Images News/Getty Images

The Apple iWork software suite includes a spreadsheet application called Numbers. If your business operates on Mac computers, you can use Numbers to create spreadsheet files and track information like sales, inventory or client information. The Numbers program is capable of opening Microsoft Excel spreadsheet files or exporting data to the Excel or comma-separated value formats. Numbers also includes a set of templates to help you start building a new spreadsheet.

Click on the "Numbers" icon in the Dock at the bottom of your Mac's screen.

Browse the categories on the left side of the Template Chooser window to find a spreadsheet template that you want to use. The Numbers program includes many templates that are useful to businesses, such as ones for employee schedules, invoices and expense reports.

Click on the template you want to use or click on the "Blank" option, then press the "Choose" button.

Place your text cursor in the row labeled "1" and enter labels for your column headers.

Move down to the row labeled "2" and begin your data entry. To quickly move between spreadsheet cells, press "Tab."

Add a calculation by highlighting a cell, opening the Insert menu, navigating to the Function submenu and then clicking on "Formula Editor." Fill in the black box with the calculation you want to use and then press the green check mark button.

Save a copy of your spreadsheet by opening the File menu and clicking on "Save." Then navigate to the area where you want to store the file and click "Save."

Convert the spreadsheet to a different format by opening the File menu and clicking on "Export," then click on "Excel" or "CSV" and click "Next." Choose where you want to save the converted file and click "Save."

Items you will need

  • Mac running OS X 10.5 or later

  • IWork '09