A spreadsheet application developed by Apple as part of its iWork suite. The iWork equivalent of Microsoft Office Excel.

learn more… | top users | synonyms

12
votes
4answers
817 views

How to Change File Type Associations?

How do I stop Numbers from being the default program when a financial file is downloaded or imported?
5
votes
1answer
9k views

How do I do a pivot table in Numbers?

I can't find any equivalent of the Excel Pivot Table or Open Office Data Table features. I'd like to sum up my data grouped by values in various columns. For example, if I have A B C red ...
0
votes
1answer
69 views

How do you formulate Microsoft Excel “if” statement equivalent in Numbers?

The syntax of a simple Excel if statement is: =IF(a1="a",b2,"") This places the contents of cell b2 in the current cell if cell a1 contains the character "a". Otherwise the current cell is cleared. ...
6
votes
2answers
3k views

Is there a keyboard short cut to edit a cell in Numbers?

Back when I used Excel you could easily do all the navigation and editing on a spreadsheet with the keyboard. I could navigate around with the arrow keys and hit F2 to edit a cell and start typing. ...
3
votes
2answers
11k views

Swap X and Y axes in Numbers?

I'm taking an economics course, and for whatever reason economists create graphs with the independent variable (price) on the Y axis and not the X axis. If I only have 1 dependent variable to graph, ...
2
votes
2answers
2k views

How to export Contacts version 9.0 data or .abbu file to .csv or other usable spreadsheet format

In the newest Apple Contacts version 9.0, how do you export all contacts or an .abbu file to a .csv file or other usable spreadsheet format? Dragging and dropping to Numbers does not work. Exporting ...
1
vote
1answer
36 views

Can Numbers create stacked column charts with two columns for each category?

I'm trying to create a column chart in Numbers where each column is also stacked. For example, consider the following data. Here we have numbers for the total sample and numbers for how that total ...
1
vote
1answer
134 views

Numbers for Mac: Force line chart to show axis at point (0, 0)

Look at this line chart. I wonder if its possible to force Numbers to show Y=0, for example, without needing to add a data entry point to make it happen. - Is it possible?
1
vote
1answer
4k views

How to plot a histogram to show occurrence of a certain number using Numbers

Sorry for this newbie question: I want to do something like in a column there are numbers 0.2, 0.3, 0.2, 0.4, 0.2 occur 2 times, whereas 0.3 and 0.4 occur once, I want to make make histogram that ...
0
votes
1answer
1k views

How can I add custom error bars to a graph in Numbers

I am using numbers 2014 - above is a screenshot that should explain it.
0
votes
1answer
2k views

Numbers auto date on template only

Is it possible to use the =today() function (or something else) to insert the current date but then not update each time the file is opened? I want to create a numbers template for my invoices. I'd ...