Blog Post

Apple Numbers Gallery

Numbers Icon

Yesterday Apple announced and released its much anticipated spreadsheet application called Numbers.

Numbers is described as “spreadsheets the Mac way,” with the application offering significantly more functionality past just simply charting information and numbers. It’s a solid mixture of information organization, number calculation, and page layout/design.

The interface for numbers if very intuitive and is very easy to learn. Apple has quite a few Numbers tutorials on their website to help you learn even faster.

Below is a gallery of screenshots of the new Numbers interface. Enjoy!

Full layout of the new Numbers application

Numbers Full Layout

Numbers is part information organization, part page layout

Number Page Layout

Edit photo masks right in the program

Numbers Edit Mask

Create checklists that tally up sums

Numbers Checked Items

Create simple check lists

Numbers Checklist

Make table cell drop-down menus

Numbers Cell Drop Down

Create a “slider” to adjust numbers

Numbers Slider

Use pre-built functions or edit them manually

Numbers Functions

Attach notes to tables and cells

Numbers Notes

Create multiple pages in one document and keep them organized with the Sheets area

Numbers Sheets

Easily change the entire style of a table with customizable style sheets

Numbers Style Sheets

20 Responses to “Apple Numbers Gallery”

  1. Hillevi Peterson

    I went to a one on one at the Mac store and said — I own Office. I can’t stand Excel. MAKE me switch. Less than ten minutes later it was in my hands… It is visually stimulating and PHD easy. (press here, dummy) In less than 30 minutes I created a bar graph with molecular images that wrapped around each bar — drag and drop easy. Web integration with inserted QT video allows me to teach online instantly! Once again, Apple Reigns.

  2. The Stig

    If you want to do regression beyond the built-in Excel function LINEST then currently Numbers is not for you. And neither is Office for Mac, including the ’08 versions because VBA has been dropped from the Office 2008 Macintosh suite.

    Instead, get VMware (or use BootCamp), load it up with Windows XP and install Office with the Analysis Pack and enable it. Move on from there.

  3. I’m having problem with Numbers. Often when I try to make linear charts, Numbers makes me a graph with much higher scale than necessary and with redundant empty space above the line. For example; if I have numbers of my salary scaling from 1,700-2,300$ trough 12 months, then Numbers makes vertical scale up to 5,000 with a lot of blank space above the line or columns. How to solve this? I noticed that if I exclude some months, the problems sometimes dissapears, but then again, I am left without certain data.

  4. I am having the same problem with charts. I used the same worksheet in Excel and Numbers with one row of data and five columns of dates. I made a simple bar chart with zero problems in Excel in a jif. But in Numbers, I still haven’t been able to do the same. I have read the manual, online help and called AppleCare. No help. AppleCare said they’re new to Numbers and not trained to give competent advice yet. Imagine that.

  5. Gosh, I wish Numbers had radar graphs! Come on, Apple, listen up!

    Oh, and Steve, my wife and I will have dinner on the table at 8pm tonight if you want to come over and hear more about what I want you to do with your company …. :)

  6. wackymacs

    Jason – It’s not exactly hard. Excel has a name box. Just select the range, type the name, press Enter. But yes, Numbers is nicer and easier to use. And it’s “You’re”, not “Your”. :-)

  7. Your not getting it, Matt is right, about 80% right. It is easier to use sum(Total Cost). Excel CAN do named ranges. Find a normal user (read someone that uses excel and would like to do stuff at home, but isn’t fluent with it) that has a clue how to do named ranges.

    before you say “Everyone I know does”, I am a computer instructor for a international training company. Teaching Beginner to Expert MS products, specializing in Office. Every time I get to the named range class, less than 5% of people knew you could do it.

    Numbers makes it automatic. Also you can use spaces in the names instead of underscores. Like you have to do in Excel.

  8. >> SUM(E$2, $E$45)

    What are you talking about? In excel I select the box I want and hit the Autosum button. It usually gets what I want and I hit enter. If it does, I just draw a rectangle around what I want summed.

    You you wacky mac users and your archaic command-line-like typing interfaces!

  9. wackymacs

    Matt – You can do the EXACT same thing in Excel on both Windows and Mac. Naming columns/cells and using them in functions is nothing new. I think you need to take a closer look at Excel before telling MS to take notes…

  10. Jeffrey Heinze Fry

    I’ve tried out numbers for just a bit, and overall, it’s really good, with just one major complaint that apple deserves to be kicked for. Compared with the other spreadsheet apps I’ve tried (Excel and Neo Office) Numbers is a cripple when it comes to handling scatter plots. I was hoping to get some basic regression lines which is the sole function Excel has that keeps me using it instead of Neo Office, but I don’t even get a basic series editor. To add a series, you need to drag 2 columns of numbers adjacent to each other into the chart. This means if the first column you have is time and the next 2 are data for different trials… your going to have to mess around a lot to get them both plotted on the same chart and mess up your table as well.
    Other than that, this offers everything I use in Excel and does it better. It looks nicer, makes managing multiple tables and changing number formats easier, and it makes all of it’s functions relatively easy to find. If apple fixes the scatter plot problems, what we have is the ultimate spreadsheet. As is… it’s great for many things, and completely disfunctional for others.

  11. One thing I noticed that really annoyed me while trying to port a spreadsheet that I had in excel was that Numbers is not scriptable at all (doesn’t even have an applescript dictionary!!).

    The lack of Applescript support is very strange and frustrating at the same time. Keynote and pages both export dictionaries, why not Numbers?

  12. Binh:
    If you want Numbers to do all that Excel can do, then I don’t think Numbers is targeted at you. Perhaps wait for the new office for mac. The reason I say this, is that in my experience with the previous version of Pages – it doesn’t have all the features of Word. But in my mind that’s really the point. Word is a powerful feature rich application, and in my own use, I don’t even use 20% of the features, but wish their were easier ways to do the kind of docs I do, and that’s where Pages comes in.

    I would imagine it’s the same with Numbers. It’s core market is probably only 60 or 70% of Excel users, who don’t use the intense add-ons, but simply need a powerful and easy to use spreadsheet for reports or data analysis.

    Apple excel (pardon the pun) at finding trends and markets in places where others aren’t exactly looking. And they churn out top quality stuff, so that when you use it, you wonder how you ever coped without it!

    That’s my impression anyways.

    I’ve downloaded the trial and am testing it out, and so far I’m impressed, itching to send through a Numbers comparison template type document to one of my clients!

  13. I’ve had some difficulty with getting charts to work in Numbers. I consider myself fairly tech saavy, but I just couldn’t get the charts to show the data I wanted to. I was also unable to find any useful help in the help files or on Apple’s site.

  14. well i reserve my opinions until i get to use it. There is much more to excel than just sum and pretty graphs. The power of excel lies in all those add ons and statistical calculations. If numbers can do all of that like in excel, then i’m sold

  15. A spreadsheet the mac way… hmmm. To sum it up (pun, I know)… which is easier?

    SUM(E$2, $E$45)
    – or –
    SUM(Total Cost)

    Yeah, I thought so. I hope Microsoft is taking notes.

  16. Apple announced and released its much anticipated spreadsheet; not it’s, which is short for “it is”. Off topic, pedantic, but you have such a great site I thought it worth mentioning…