We use cookies to provide you with a better experience. If you continue to use this site, we'll assume you're happy with this. Alternatively, click here to find out how to manage these cookies

hide cookie message
Office software Reviews
15,669 Reviews

Apple Numbers '08 spreadsheet software

£55 inc VAT for iWork

Manufacturer: Apple

Our Rating: We rate this 4 out of 5

Slowly, but surely, Apple's iWork is turning into a full-fledged office suite, as iWork '08 gains Numbers '08, Apple's latest foray into the world of spreadsheet programs.

Slowly, but surely, Apple's iWork is turning into a full-fledged office suite, as iWork '08 gains Numbers '08, Apple's latest foray into the world of spreadsheet programs.

So what is Numbers '08? Is it at long last Apple's replacement for the spreadsheet component of AppleWorks? Is it a direct competitor to Excel 07? Will it enable Mac users looking for alternatives to finally move from either AppleWorks or Microsoft Office to iWork?

The answer to these questions is any of yes, no and maybe, depending on your specific spreadsheet needs. Those with basic needs will be impressed with Numbers' ability to make short work of their projects. People with more complex requirements, and those hoping to migrate from Excel or AppleWorks, will find the transition more difficult. And some people - scientific users, students, and advanced Excel users in particular - may find that certain details in Numbers make it impossible to use the product in its current form.

All in the family

When you import an Excel worksheet, Numbers lets you know about trouble spots. You get both a summary sheet and in-cell flags that detail specific messages about issues with each cell.

Unlike Excel, the Numbers' work area allows for great flexibility in layout, and you can position tables exactly where you want them.

Numbers '08 is part of the £55 iWork '08, which means you have access to a lot of common features - the Inspector pane; the new Format Bar for making quick changes to common formatting settings; the Media Browser for placing artwork; powerful image-editing features such as transparency and shadows; the ability to easily place shapes; colourful and well-designed charts; and a customisable toolbar.

A new approach to spreadsheets

Traditionally, spreadsheet programs have presented users with a full-screen grid of rows and columns. Numbers '08, however, is more like a page layout program - you start with a blank canvas, into which you can drag as many tables as you need onto the work area.

Each Numbers '08 table is a miniature spreadsheet of its own, complete with its own grid of rows and columns, cell-formatting options, and row and column heights and widths. There are even handy styles, shown in the left-hand of the document window, that can be applied to any of your inserted tables. These tables are treated like separate objects, and they can be positioned anywhere on the page.

This free-form layout feature overcomes one of the big problems with traditional spreadsheet programs: it's difficult to make all of the rows and columns look attractive when printed (wide cells in one column will throw off rows above and below, for example). Since each table in Numbers '08 is an independent object, setting differing heights and widths for rows and columns has no impact on other tables, and you can easily align tables wherever you want them on the page.

If you're an experienced spreadsheet user, you may find that Numbers '08's new approach takes some getting used to - it's visually very different from an Excel or AppleWorks spreadsheet module. It's worth the effort, though, because it provides real flexibility and aesthetic value.

Time-saving templates ease workload

Templates for spreadsheet programs aren't new; Excel has had them for years. What is new with Numbers '08 is the quality of the provided templates, thanks in part to the flexibility of the spreadsheet anywhere design of the program, and in part to the skill of Apple's designers.

When starting a Numbers '08 project, you can choose from 18 templates spread across four categories, covering typical projects from Budget to Travel Planner to Science Lab. Within each template, you'll find well-designed worksheets, with comments that help explain how they work. Plug in your numbers, customise the graphics, and you're ready to print without any further work. You can even save your own customised templates (with the Save As Template command), and from then on they'll be available in the Template Chooser.

Useful new data features

In addition to rethinking the basics of spreadsheet layout, Numbers '08 provides some new ways of working with the numbers on the spreadsheet itself. Drag-and-drop formulae, for instance, make it simple to place a sum, average, minimum, maximum or count formula on your worksheet. Highlight a column of numbers, and you'll see the current value for each of those formulas in the lefthand sidebar. Just drag-and-drop the one you'd like to use into an empty cell on your worksheet, and you're done.

There are also four special formats you can apply to cells via the Inspector: Pop-up Menu, Checkbox, Stepper and Slider. The first two are self-explanatory; Stepper and Slider are methods of quickly changing a value within a cell.

When you apply a Stepper or a Slider to a cell, you specify a minimum value, maximum value and step size. When you click on a cell with a Stepper format, an up/down arrow pair appears next to the cell; click and hold the arrows to increase or decrease the value in the cell. Click on a Slider-formatted cell, and you can then pull a sliding dot on a bar to the left and right to change the cell's values. Both are great ways to see what effect a range of values will have on your model's results.

Drop-down menus on row and column headers make it easy to sort, add, delete and hide rows and columns. You can also add rows and columns by simply dragging and resizing the corners of the table.

Printing has also been given special attention in Numbers '08. Instead of setting a print range, a special Print View lets you see and control exactly how your printout will appear. This mode is fully interactive, so you can rearrange your document as you wish, and a scaling slider at the bottom of the screen resizes your output in real time as you change the scaling factor. The downside of this method is that you can't easily print just one section of your document, unless you can scale it so that it takes up a full page. Instead, you'll have to design your document such that the one section you wish to print is on a page of its own.

Numbers Expert Verdict »

Apple Mac with an Intel, PowerPC G5 or PowerPC G4 (500MHz or faster) processor
512MB of RAM (1G recommended)
32MB of video memory
Mac OS X version 10.4.10 or later
QuickTime 7.2 or later
iLife 08 recommended
1GB of available disk space
CD drive required for installation
  • Ease of Use: We give this item 8 of 10 for ease of use
  • Features: We give this item 7 of 10 for features
  • Value for Money: We give this item 8 of 10 for value for money
  • Overall: We give this item 8 of 10 overall

Numbers '08 is a strong entry for Apple in the spreadsheet arena, especially for those who find Excel's feature set overwhelming. With its free-form layout, easy-to-use templates, and elegant interface, Numbers is a powerful, yet approachable, tool. If you work with large data models, rely on Excel's macros, or some of its more advanced functions and features, you probably won't be migrating all your work to Numbers just yet - at least not with this first version. You may still find Numbers useful for smaller projects, though, as its ability to quickly create stunning reports could help you win some clients or promotions.

  • Apple iWork '08

    Apple iWork '08

    With iWork '08, the latest generation of its office suite, Apple has given Mac users a powerful alternative to Microsoft's Office for Mac.

  • Microsoft Excel 2011 review

    Microsoft Excel 2011

    Microsoft Excel 2011 for Mac represents the largest step forward for serious Mac spreadsheet jockeys in many years.

  • GS-Calc 10 review

    GS-Calc 10

    GS-Calc 10 is an inexpensive spreadsheet program that isn't an Excel clone. Here's our GS-Calc 10 review.

  • Microsoft Excel 2007

    The ribbon is the most obvious innovation in Office 2007, but Excel has some major changes under the hood as well.

  • Google Spreadsheets free online spreadsheet application

    Google Spreadsheets free online spreadsheet application

    If you carry around a laptop so you can show clients your latest marketing forecasts, you can save yourself the bother by using Google Spreadsheets.

IDG UK Sites

Android M Developer Preview announced at Google I/O: Android M UK release date and new features. Wh?......

IDG UK Sites

Why I think the Apple Watch sucks and you'd be mad to buy it

IDG UK Sites

Ben & Holly's Game of Thrones titles spoof is delightfully silly

IDG UK Sites

Mac OS X 10.11 release date rumours: all the new features expected in Yosemite successor