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
73
votes
3answers
25k views

Why does Numbers hide a huge PNG file in exported Excel sheets?

OK, this is a weird one. I take my blank Numbers sheet: ...and export it to Excel: Whoah, that seems a little large. Let's rename the Excel doc to .zip and have a look inside: Digging a little ...
27
votes
5answers
85k views

How can I do text-to-columns in Numbers?

I've got a column where each cell in the column contains two different pieces of data separated by a known delimiter ", ". How can I split each cell in this column around the delimiter? Given: ...
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. ...
15
votes
3answers
13k views

Keyboard shortcut to delete row in Numbers

I can add rows conveniently using Option+Shift+Up Arrow (insert above) or Option+Shift+Down Arrow(insert below). Is there a keyboard shortcut to delete the current row?
14
votes
2answers
26k views

Numbers: Count unique items in a column

I'd like to count the occurrence of unique items found in one column of about 120 items. I can't find a way to do this in Numbers.app
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?
13
votes
2answers
29k views

Is there a way in Numbers to flip columns with rows?

Is there a way in Numbers to flip columns with rows ? I have several tables in my sheet and I need to swap columns with rows for each table. e.g. A1 A2 A3 B1 B2 B3 C1 C2 C3 should become: ...
12
votes
9answers
41k views

How to gracefully import CSV files into Numbers.app v3?

I have a process, which has worked faithfully for years in Numbers '09, whereby I download my Bank account data in CSV format, then drag that data directly into my Numbers sheet (after creating an ...
12
votes
1answer
20k views

How to uninstall Numbers and Keynote on Mavericks?

I installed Pages version 5 on Mavericks via the "App Store". But the problem is Keynote and Numbers are installed also. I'm not interested in Keynote and definitely not in Numbers. I want to ...
12
votes
1answer
2k views

How do I combine separate cells in a Numbers spreadsheet and paste the result as text into a TextEdit document?

I have a Numbers spreadsheet. Column B contains first names, column C contains surnames. I need an easy way to combine and reformat this data so that it’s in the format Surname, Firstname. I then ...
11
votes
1answer
15k views

Swap X and Y axes on Numbers 3.1

This link is now outdated with the new release of numbers. I want to transpose the X- and Y-axes on a chart in Numbers 3.1. How the heck can I do this? The first chart I made was able to sum my ...
10
votes
3answers
19k views

Can Numbers save a file as CSV?

I'm trying to switch over from Excel to Numbers. Is it possible to save a file as a CSV in Numbers? The whole idea behind this is I prefer to have my documents on the cloud as well as on Numbers for ...
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 ...
9
votes
3answers
8k views

How do I keep Numbers from mangling numbers when importing a CSV?

When I open a CSV file in Numbers, it "helpfully" converts fields it recognizes as numeric by stripping leading zeros, converting things it recognizes as dates, etc. Take for example, you type a UPC ...
9
votes
1answer
2k views

Keyboard Shortcut to Fill Right in Numbers?

In Numbers, is there an equivalent keyboard shortcut to Excel's "Fill Right" Ctrl + R and "Fill Down" Ctrl + D?
8
votes
4answers
24k views

How to change the colors of individual bars in Numbers 3.2

How do I change the colors of individual bars, in a bar chart of in Apple's Numbers 3.2.x
8
votes
1answer
35k views

How to create sum in Numbers up to a specific row?

I have column which contains prices for my work. The last row of that column should contain the total. Currently I have to adjust the SUM() calculation every time I add or remove a row. Can I somehow ...
8
votes
1answer
2k views

Can I use Javascript to write a custom function for Numbers?

It's always annoyed me that I can't write a custom function for Numbers. It would make the spreadsheet so much more useful to me. In Google Apps spreadsheets you can do it, using Javascript. In ...
7
votes
3answers
39k views

How can I use a secondary axis in Numbers?

One of my main problems with Numbers is the fact that it has much less of the functionality of Excel. That's why I barely use Numbers. One of the main things that I always thought impossible was ...
7
votes
2answers
405 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 ...
7
votes
2answers
9k views

Numbers v3.1: Automatically link URLs in spreadsheet?

I've inherited a spreadsheet that has a loooong column (thousands) of URLs, all unclickable. I'd like to make them clickable. I have tried the following: Highlighting the column. Select column, then ...
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
2answers
4k views

How can I rename the columns in Numbers?

I'm working with a language file, with columns for different languages. My first row is the language names. Is it possible to have the "A", "B", "C", etc as language names instead. That way, when I ...
6
votes
2answers
109 views

In Numbers can you auto-populate a cell with a date when another cell is populated?

I'm an avid Excel user and recently I've had to figure out how to use Numbers. So far I've been able to replicate all the Excel functionality that I use in Numbers... except for one thing. In Excel ...
6
votes
1answer
2k views

Numbers: Grouping daily data into weekly data

I have a spreadsheet where I am keeping track of several statistics on a daily basis. I have another spreadsheet where I am keeping track of several statistics on a weekly basis. I want to graph the ...
6
votes
2answers
25k views

COUNTIF using two conditions from data inside and outside the dataset

I'm struggling to use numbers to do a function. Specifically, I want to use COUNTIF to check two things within my data set table and put that information into another table that we'll call "query set"....
6
votes
1answer
76 views

Does Apple's Numbers support 3rd party plugins / data providers / formulas / functions?

Numbers has the ability to pull in prices for various stocks and currencies. However, I am after the ability for it to pull in prices for various cryptocurrencies, not just BTC, such as Cryptofinance ...
6
votes
1answer
459 views

is there a way to disable update notifications in iWork apps (Pages, Keynote, Numbers)?

Even with App Store Automatic Updates set to OFF, all of the iWork apps pop up a modal dialog box on startup to inform you there is an update. Is there a way to disable this behavior (in El Capitan)?
6
votes
3answers
234 views

Is this possible to link the value to a database in Apple's iWork suite?

For example, I would like to make a Pages document that has a value that's linked to the company information and Keynotes and Numbers as well. So, when our company information changes, all the ...
6
votes
0answers
691 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 ...
6
votes
1answer
893 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.
5
votes
3answers
5k views

Open CSV File with Different Separator

I'm currently using the default Numbers application to open my CSVs. My current use case involves a file that I had to use a different type of separator (|). Is there any way to change the separator? ...
5
votes
4answers
22k views

How to convert .number file to any of the readble format including excel and pdf without having mac

I have an important .number iworks file. My Mac is now no more... How do I convert .number file to any of the readble format including excel and pdf without having mac.
5
votes
2answers
3k views

Time as x-axis in chart with Apple Numbers

I'm trying to make an area chart in Apple Numbers (on Mac) where I have a series of values I want to plot on y-axis against time on the x-axis. Each value has a date that it occurred but the dates ...
5
votes
1answer
12k views

Locking cells in numbers

Is there an easy way to lock individual cells or a group of cells in Numbers to prevent the data in the cell from being changed?
5
votes
3answers
5k views

Numbers: Countif with condition the content of a cell

I am struggling to come with a solution on this problem, making me wonder if the Countif function is designed to work this way, or what is wrong with my syntax at the end. I have my first table with ...
5
votes
2answers
8k views

How can I change the data source of a chart in Numbers '09?

I have made a chart in Numbers '09 and now I want to create another very similar chart but with different data, so I have copied and pasted the chart and now I want to make it take its source data ...
5
votes
1answer
72 views

How can I change a Numbers graph x axis to go from the lowest value to the highest value?

I'm graphing columns A and B, where A is the x axis. I have entries entered in A like so: 1, 3, 2, 4, 5... and so on. When I select A and B and make a graph, it seems like the x axis does not ...
5
votes
1answer
502 views

Is there an equation in Numbers that will give me the sum of numbers based on a separate column?

I'm trying to find out if there is a way to create an equation that looks at one column, if it is equal to a certain value, then add the value in the other column? Example: #Table of running values: ...
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 ...
5
votes
2answers
7k views

Link information between spreadsheets in iPad using Numbers

Could you link to data in one spreadsheet from another using Numbers for iPad?
5
votes
1answer
344 views

How to find in one sheet in Numbers?

When I try to search something in Numbers, it will find in all sheets. Is it possible to search in currently selected sheet only? MacBook Air macOS Sierra 10.12.3, Numbers 4.0.5
5
votes
1answer
5k views

Numbers: conditonal highlight based on a date in a different column

In numbers, I would like to change the background colour of Column D based on whether the date in Column A is still in the future (i.e. graying out). I can get the colour formatting to work on the ...
5
votes
3answers
2k views

How to store new iWork (2013) documents in a flat file (for version control)?

With the October 2013 iWork update, the new UI is great but it seems one cannot store documents as 'flat file' any more. This really limits my ability to store the files, essentially ruling self-...
4
votes
1answer
9k views

Deleting formula sources without destroying formula output, using Numbers for Mac

I would like to delete the source column for a formula in Numbers 3.2.2, without destroying values in the formula's output column. Specifically, I have a column of "Last, First" names, which I parse ...
4
votes
2answers
14k views

How to display zero value as blank cell in mac numbers 3.1

How do I display zero value as blank cell in mac numbers 3.1 yet maintain a formula. I want a running balance column that only shows balance to the line of the last entry like a checkbook register. ...
4
votes
3answers
5k views

iWork '09 Keeps asking to be Registered

I'm a teacher in a classroom with 8, 9 10 and 11 year olds who each have a macbook or a macbook pro. Fun job. We have a standard 10.6.6 image with iWork '09 (4.03). In previous images, iWork would ...
4
votes
1answer
12k views

Conditional SUM() based on text of a cell using iWork

I have some basic data Name | Amount Jake | 10 Jake | 12 Jake | 13 Ben | 1 Ben | 14 Ali | 9 Ali | 4 I want to total up the amount for each person so I end up with something like Jake | 35 Ben |...
4
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 ...
4
votes
1answer
16k views

How to change cell background color in numbers according to some rules?

Making it simple, using Numbers, how can you set up the following: If number is positive make background cell green, else make it red.