Questions tagged [numbers]

A spreadsheet application developed by Apple as part of its iWork suite availble for iOS, macOS and cross-platform via iCloud. It is the Apple alternative to Microsoft Office Excel.

Filter by
Sorted by
Tagged with
7
votes
2answers
408 views

How do I get iWork / iMovie / Garage Band free of charge?

Everything that I have read says that iWorks/ iMovie etc should be free for Mac users after 1 September 2013. I already bought Pages but want Numbers and iMovie. My MacBook Pro with retina is early ...
14
votes
4answers
1k 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?
3
votes
1answer
11k views

How do I sum up specific things in Numbers?

I have a spreadsheet in the newest iWork Numbers.app, with something like: CATEGORY | POINTS HW | 100 HW | 100 NW | 12 HW | 50 NW | 23 I want to just sum up all the ...
2
votes
2answers
9k 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
8answers
12k views

Remove hyperlink formatting from address

I have created a Numbers spreadsheet containing a set of data including email addresses. Some of these addresses appear as hyperlinks, and I can't seem to edit or change them. Every time I try to ...
1
vote
1answer
3k 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 ...
1
vote
4answers
8k views

Set Print Range in Numbers.app

Is there any way to set a print range in Apple Numbers.app spreadsheets, to print just a subset of cells rather than entire document?
21
votes
2answers
6k 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. ...
7
votes
2answers
21k 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 ...
6
votes
0answers
695 views

Numbers shortcut to select next non-empty cell

I have just purchased my first Mac and am having problems with Numbers. I want to select the next cell in a given direction that is non-empty (or jump to the end of a contiguous chunk of cells that ...
5
votes
2answers
2k views

SUMIF statement with two different conditions (Text based and checkbox)

How can I create a SUMIF statement with multiple criteria? I have a spreadsheets where I track hours for different clients in one table, and below this table I want to summarize in a summary table ...
5
votes
1answer
20k 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 ...
9
votes
3answers
18k views

How to fill down in Numbers without dragging?

I have a 20,000 line spreadsheet in Apple Numbers, and I need to fill a column with data. I don't want to sit there dragging down the fill handle for thousands of rows. How can I fill the whole ...
4
votes
1answer
794 views

Is it possible to swap two cells content in numbers?

I have a couple of rows and I have to move some cells from one row to another. Right now, I have to Copy/cut cell A1 Paste it in an auxiliary empty cell C1 then copy A2 paste it in A1 finally cut C1 ...
3
votes
1answer
504 views

Numbers Lookup Finding incorrect values

I have many tables with two columns (key-value style) and I want to combine all the values in a single table. I lookup key in a first column and insert a value from the second one. I've encountered an ...
2
votes
4answers
11k views

Batch convert Apple Pages files to Microsoft Word doc files

How can I convert a large number of Pages and Numbers files into corresponding MS Office format in a quick manner.
3
votes
2answers
14k 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
1answer
93 views

How to print one Numbers row per page, formatted nicely

I have a Numbers spreadsheet consisting of data that I would like to print. However, I would like to have each row of the table printed out on its own separate page. Moreover, each row contains a lot ...
2
votes
1answer
1k views

Count contents of one column if an adjacent cell matches a query in Numbers

I have a spreadsheet maintained in Numbers where I record my practices at the range, which lists type of weapon (pistol, rifle, shotgun), as well as the numbers of shots fired. I am readily able to ...
2
votes
2answers
1k views

iWork Numbers evaluate string

I have a cell with the following content 2262/4121. I want to have a cell next to it that contains the result of that expression. Is there a function for that?
2
votes
1answer
12k views

How to sort column by date in Numbers?

I've my column in format dd/mm/yyyy and I would like to sort them by date. But I can't find any way of sorting the column by date. If I Sort Ascending, it doesn't recognise that the rows have the date ...
2
votes
1answer
9k 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.
2
votes
0answers
19 views

SUMIFS with comparisons to relative cells

(This is somewhat similar to How do I reference a cell from within a "...IF"-type function condition string? and SUMIF statement with two different conditions (Text based and checkbox)) I ...
1
vote
1answer
2k 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 is ...
1
vote
1answer
3k 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
861 views

Charts from numbers not dynamically updating in Pages/Keynote

I have the latest (5/2015) Pages, Numbers, and Keynote on Yosemite. I created a chart in numbers and then copied it to Pages or Keynote. I then want to be able to change the data in Numbers and see ...