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

learn more… | top users | synonyms

3
votes
0answers
2k views

How do I create a Pivot Table in Numbers 3.2?

I'm new to Numbers and currently using Numbers 3.2. I already have an idea of how to use SUMIFS to create Pivot Tables in Numbers, but I'm still looking for a better way to generate the column & ...
2
votes
0answers
27 views

Looking for a grandma-safe way to create two-fold greeting cards

My Mom (+ 70) longs for the day when her Windows Paint Shop program would walk her through creating a 2-fold 8 1/2 x 11 card. She could assemble the card one page at a time and not think about what ...
2
votes
0answers
204 views

batch convert iWork 08 files to new version on Yosemite

TL;DR Short version: I have a bunch of files that were created with iWork 08. Is there a way, maybe using AppleScript or Automator, to convert them to the new format (Pages 5.5, Numbers 3.5) without ...
2
votes
0answers
204 views

Changing the open with settings in 10.10.1

I am looking for a way to edit the open with settings in 10.10.1, i have looked through older questions and have attempted to rename the launch services plist and have gotten no where. I have looked ...
2
votes
0answers
548 views

How to use an array as a condition in a COUNTIFS or SUMIFS formula

This question could be tricky to follow so I'll split it out with examples Given I have this table of overpriced fruits; Item Price Apple £0.80 Peach £1 Pear £1 ...
2
votes
0answers
43 views

Numbers 2: Create a new header cell, listing once the contents of a column

Not sure how to search for this question, and moreover I rather think that what I want might not be possible, but just in case I am asking it here. I am looking for a way to create a new table where ...
2
votes
0answers
115 views

How do I sort a Numbers' table using data from another table?

So, I've got this data set coming from questionnaires. I created one table per question, questionnaires in rows, answers in columns, and everything is fine and dandy, but now I have this situation ...
2
votes
0answers
44 views

How to calculate max with condition in Numbers?

How can I calculate max with condition in Numbers? In other words, I want something like maxifs, which operates max operation instead of sum operation for sumifs.
2
votes
0answers
187 views

What is the Numbers keyboard shortcut to get in the formula bar of a cell?

I am looking for a keyboard shortcut in Numbers to edit the current cell via the formula bar (if that is the right word). Screen shot: Please note, I am not looking for this answer. That is how to ...
1
vote
0answers
84 views

How can I link data from Numbers to a Pages document?

I'd like to have all my client invoices in a Numbers document, including invoice number, service period, daily rates,... and generate a invoice from that with a template I have created in Pages. How ...
1
vote
0answers
95 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
0answers
44 views

How to get long decimals from functions in Numbers?

I am using Numbers on OS X to help me with a GIS project; I have created a .CSV file that describes a polygon in terms of the distance and bearing between any two consecutive vertices. Using the ...
1
vote
0answers
394 views

App Store Purchase Update gives “An error has occurred” messages for Keynote and Numbers

I am trying to install Keynote, Pages, and Numbers from my App Store account using my Apple ID and password. Pages has installed properly and works. Numbers and Keynote both failed and do not open. ...
1
vote
0answers
210 views

Numbers app: how to change x axis position + change chart's line width

I have a regular linear graph and have y values running from negative to positive, enabling x axis shows the line at the bottom of the graph. How is it possible to set it to show at zero, i.e. running ...
1
vote
0answers
162 views

How can I restore an older version of a Numbers document (before the sync)

I'm using Numbers on my iPad and my Macbook. Yesterday I opened my Macbook and for some reason it opened the Numbers app but didn't sync. I didn't really need to work on the file so I just left it ...
1
vote
0answers
69 views

Can't use any of the iWork apps

I'm unable to use any of the apps included in the iWork package. If I try to open any one of them, the app opens but I can't perform any action. I click on the bar menu items to see that even 'About ...
1
vote
0answers
36 views

Sum of Formula results?

Is there any way in Apple Numbers to apply a formula to a selected set of rows, and sum up the results? This is how i'd like to have/use the formula SUM(TableA::$A$1:$A$20;"=$1*"&TableB::A1) ...
1
vote
0answers
118 views

How to display labels on bubble chart, Numbers (v3.2)

I want to display the label of each bubble on a bubble chart in numbers. How do you do this? I want either a truncated "description" or the 3-digit NAICS to be the label of the bubble. Here's an ...
1
vote
0answers
56 views

How to write a function in Numbers to get the DATES for different tasks

I am trying to figure out how to write a function to get Dates going on and back from a different moments in my to-do spreadsheet. I know that i can use function DATEVALUE() to count from one specific ...
1
vote
0answers
90 views

Numbers '08: How to create a histogram?

I have data (ranging from 0 to 1, e.g. 0.61 0.23 0.99 1.0 0.89 0.0 0.42 0.42 0.86 and I would like to create a histogram with bins 0 0.2 0.2 0.4 0.4 0.6 0.6 0.8 0.8 1.0 with the upper ...
1
vote
0answers
91 views

How do you get different color bars in Numbers 3.1?

In previous versions including 3.0 when you made a 3D Bar chart each data point (ie. months) would be in a different color - now I can't seem to find any way to make them different. Is this a bug in ...
1
vote
0answers
34 views

Latest Numbers changes, how to graph things?

Ok this is insane, I have a table Selecting both columns, and What i get back makes no sense. Plotting columns as series i get Plotting rows as series i get Things worked perfectly fine ...
1
vote
0answers
109 views

Is there a way to create a polar plot in Numbers?

I am trying to do a polar plot, or radar chart as excel calls them, for a report. I don't have excel, only Numbers, is there a way to do that type of plot with Numbers? I can't seem to find a way. The ...
1
vote
0answers
132 views

Exporting CSV with Numbers with different languages

I am exporting a file from Numbers to CSV and it contains language other than English, like Japanese or Russian. After I export the CSV, all these funny characters shows up in the CSV. Is there a ...
1
vote
0answers
91 views

Is there a way to have a formula in numbers 09 return an empty value (ie isempty() returns true?)

I've got a list of times and ages, and want to extract ages for a particular range of time values. So I've used an 'if' formula to copy the age for an entry if its time is between two values. The ...
0
votes
0answers
9 views

Numbers spreadsheet - list of worksheets on right side

How can I get a menu of the worksheets on the right side of a Numbers workbook? In an older Numbers version, the default was to have a list on the right so you could scroll down to find the worksheet ...
0
votes
0answers
12 views

When does Numbers sync spreadsheets?

In Numbers, connected to wifi (good bandwidth), after modifying a spreadsheet I go back to "Spreadsheets". Then I wait for the Arrow ↑ to appear, as it indicates that Numbers is syncing with iCloud. ...
0
votes
0answers
17 views

Cross-reference data from different tables in Apple Numbers

I have a table with exchange rates, and a table with business costs made in various currencies (Yen and USD). I have a column that lists the exchange rate on that day to make the calculation back to ...
0
votes
0answers
55 views

Why can't I edit a Numbers spreadsheet I created?

Numbers 3.5.2 Macbook Air I have a small spreadsheet I created in Numbers. But when I click in the spreadsheet, there is no cursor and I can't edit anything. Could anyone tell me why this might be? ...
0
votes
0answers
11 views

create a pie in numbers with data and value

So, I have this data, I'd like to show 200 instead of 81% I can't believe I haven't yet found a way to do so. any help is appreciated ciao
0
votes
0answers
32 views

How to use Numbers to generate pdf on a web server and then email it out?

I have an issue. My client loved the report I generated using Numbers on Mavericks OS X. The bad news is that the data is being processed on a ubuntu machine running python and django. I want to ...
0
votes
0answers
21 views

Export specefic iTunes music information to spreadsheet?

Ok so I really need help with this one. I'm doing a school project and I need to be able to chart the Date Added, Date Last Played, and # of plays. Does anyone know of a way to export/copy/retrieve ...
0
votes
0answers
46 views

Numbers.app - How to add up items from multiple sheets and popup lists

Based on the "Personal Budget" template: I want to use the Personal Budget template and modify it to my needs — I want a total sheet that will add up information from 12 data sheets (for each month). ...
0
votes
0answers
20 views

How to mark some columns as ignored for calculations Numbers?

I'm creating a template on Numbers and I would like to know if there is a way for the formula to ignore, or skip over some cells or even entire columns. I need these columns for some calculations, but ...
0
votes
0answers
42 views

Template for solving systems of equations in Numbers?

Can anyone direct me to a template, method, or example for solving systems of equations with Numbers? Excel supports this with its SOLVE facility, but I see nothing obviously like that in Numbers. ...
0
votes
0answers
16 views

Data dependent multiplication of sheets

I have one number document with three sheets. They look like this: DataSheet: Name,Sex,Year,Val1,Val2,Val3... FactorSheets: Name,Val1,Val2,Val3... I want to create a fourth sheet (ResultS) that ...
0
votes
0answers
49 views

copy / paste and remove spaces in Numbers

When I copy non-sequential items in a column (using the Numbers spreadsheet on an iMac), then paste them into another column, is there a way to automatically take out the spaces (or vacant cells) as ...
0
votes
0answers
127 views

How to highlight or filter for duplicate values in a column in a Numbers spreadsheet?

I have a Numbers spreadsheet with a few thousand rows containing a column with phone numbers. As part of a cleanup of the sheet, I need to identify rows where the phone number has been duplicated so ...
0
votes
0answers
27 views

Apple numbers '08: extending a formula

how can i get a formula to apply to every cell in a column (i.e., i want to subtract a number I just entered in one cell from a total I have in a previous cell and I want to do it each subsequent cell ...
0
votes
0answers
54 views

Apple Numbers 3: how to set a background-color for the whole paper?

I want to set the backgroundcolor (in Numbers 3) of the paper to specific color. I tried to fill the cells but it does not work. I tried to to do it with an rectangle but it does not work. See the ...
0
votes
0answers
18 views

Numbers Full Screen on iPhone

I have recently got an iPhone. I transferred some of my Numbers spreadsheets. I expected these to be smaller than on iPad and Mac, but 20% of the screen is used for menu and list of sheeets (even on a ...
0
votes
0answers
101 views

Locally created excel file does not open in Numbers

I have a local process which creates an excel file using the python library openpyxl. I am not able to open the file in Numbers. When I try I receive the simple message "filename can't be opened." I ...
0
votes
0answers
22 views

Writing Text in Cells in Numbers

How do I get the cell in numbers to expand but not merge with the other cell when the text is too long? Like, I want it to stay in the same line, unlike wrap where it'll just force the text down. ...
0
votes
0answers
26 views

How can Apple iWork's number generate the empty data field?

The left is excel and the right is number. I would like to do the result like the left one, and how can I do it in number? Thanks.
0
votes
0answers
40 views

User stylesheet / formatting for all osx apple apps

I'm increasingly spending lots of time tweaking text formats from one document to the next, updating styles, formats and generally improving them. Is there a way i can export styles from numbers, ...
0
votes
0answers
83 views

Can't open Numbers, but can open Numbers.app/Contents/MacOS/Numbers

Okay, this is weird. I can't open Numbers by trying to open the .app file, but I can open it by drilling down into the app and opening Numbers.app/Contents/MacOS/Numbers via terminal. Anyone have ...
0
votes
0answers
73 views

How to update the formula in a column without deleting comments using Numbers for Mac

The question pretty much sums it up, I have a huge sheet with many calculated cells, conditional formatting and comments. In one column, lets say column K, I have a formula similar to this, ...
0
votes
0answers
32 views

Numbers never responds

When I try to run Numbers, it bounces for a while, and then just stops. No windows, no menu bar, nothing. When I Ctrl-click the icon, it says not responding, so I force-quit. I have never actually ...
0
votes
0answers
52 views

Does numbers have a way to auto-fill an entire column?

Excel has a feature where when you are trying to auto-fill equations (i.e. you can drag an equation down and it makes an appropriate equation for the next row), you can double-click the drag-handle ...
0
votes
0answers
59 views

Entering only the time in a iOS Numbers form

I use Numbers on my iPhone to keep track of a few things that have well-defined attributes. Each of these documents has a sheet that acts as a simple database, and a form that I use to enter rows into ...