How to Make a Spreadsheet on a Mac
By Bennett Gavrish
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
Bennett Gavrish is an I.T. professional who has been writing about computers, electronics and the Web since 2004. His work has appeared in the "Nashua Telegraph" and the "Daily Free Press" and on numerous websites. Gavrish received a bachelor's degree in journalism from Boston University.