Ask Different Stack Exchange
Ask Different Stack Exchange

Questions tagged [numbers]

Apple Numbers is an application for creating spreadsheets and graphs. Use this tag for all versions of this app, web based, iPad and iPhone as well as macOS

image

The Numbers tag is for questions about the Numbers application, the equivalent of Microsoft Excel.

This tag can be used for questions about the application on and and also about the web version available on computers at iCloud.

This tag can be used for questions that relate to numbers. For example it can be used for:

  • How to group data
  • If your data isn’t grouped as expected
  • Numbers charts and graphs
  • Equations

A full list of functions is available here.

For Microsoft office applications use

705 questions
26
votes
4 answers

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
Greg K.
  • 453
22
votes
4 answers

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 column with a value?
Joshua Dance
  • 1,873
19
votes
2 answers

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: A1 B1 C1 A2 B2 C2 A3 B3 C3 thanks
aneuryzm
  • 5,429
18
votes
2 answers

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 aren't equally spaced. Numbers is showing them as if…
Mark Robinson
  • 433
14
votes
4 answers

How to Change File Type Associations?

How do I stop Numbers from being the default program when a financial file is downloaded or imported?
Cassandra
  • 141
8
votes
3 answers

Numbers: Can I highlight the row and column of the selected cell?

When reading larger spreadsheets, it would be helpful to highlight the row and column that the currently selected cell is in. I'm not talking about conditional formatting or anything in the spreadsheet itself, I'm just talking about a viewing…
T3db0t
  • 335
8
votes
1 answer

Numbers app: conditional highlighting using color scales?

Is this possible, like you can in other spreadsheet software to do something like this? (color scales)
Neithan Max
  • 391
8
votes
4 answers

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
Mark Tomlin
  • 1,426
8
votes
1 answer

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 magically sum up to the row the SUM() formula is…
Krumelur
  • 985
7
votes
2 answers

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 left 2 red left 3 green left …
Kevin Peterson
  • 462
7
votes
1 answer

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
Nick
  • 171
7
votes
2 answers

How to get the current sheet name into the cell in Numbers.app

Scenario: Have a spreadsheet (Numbers.app v3.6.2/El Capitan) it contains multiple Sheets (every sheet contains multiple tables, but this doesn't matter) Every sheet is renamed to some defined name, for example the Sheet 2 is renamed to Feb (month…
clt60
  • 8,459
7
votes
1 answer

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?
user203859
6
votes
2 answers

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 the hours per client if that work is finished and if…
jafi
  • 83
6
votes
1 answer

Merge Spreadsheets

[Numbers, macOS] I need to merge data in 2 spreadsheets / tables. Both of them contain contact information. The second table contains a column that I want to append to the first table. Now, I can't just copy/paste the column, because even though the…
LinusGeffarth
  • 961
1
2 3
…
17 18