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
1k views

How Do i Pivot Table in Numbers 3.2?

I'm new to Numbers and currently using Numbers 3.2. I already got a clue of how to use SUMIFS to create Pivot Table in Numbers. But i'm still looking for a better answer of how to generate the ...
1
vote
1answer
508 views

How do you rotate a cell in Numbers (3.2)?

I want to rotate the header row by 45 degrees to look like this (from Excel). How do you do this in Numbers?
1
vote
1answer
40 views

How do I change the sheet color in Numbers 3.x?

Right now the sheet color is white. But it is hard on my eyes. How do I change the sheet color to black? I'm using a Numbers 3.x in OSx 10.9.3
-1
votes
2answers
100 views

Equivalent of cmd+down in Numbers

This is the key combination I would use in MS Excel to jump to the last contiguous cell in the current column. Similarly, cmd+shift+down would perform the same jump while selecting all the cells along ...
2
votes
1answer
31 views

Change Default Table Style when opening a CSV file

Background I often open a CSV file on Numbers, and then I see the table of which style is 'Basic'. I want to use another style (e.g. 'Gray'), but it's annoying to change the style every time I open ...
2
votes
1answer
18 views

Sequential numbering for pseudo-“Rows”

tl;dr: Formula to number rows that doesn't break when some "rows" are made of multiple, merged spreadsheet rows. Scenario: I am making a check-list (of things to look at when apartment-hunting) in ...
1
vote
0answers
38 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
1answer
32 views

One Odd-Sized page in Pages Document for PDF

Need to embed a Numbers spreadsheet in a Pages doc that will “live” as a PDF. Generating a scaled image that I then embed results in mediocre resolution.
1
vote
0answers
32 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
1answer
345 views

Comma separated list to Columns / Mac Numbers

I have a very huge list of Data (.txt file) .e.g. 945874,stu2,3826,120558,74,15 1836682,CHAOSTAURUS,90,978,3853,0 1411981,KasiaLover,101,28285,684,5 8270041,Daniel33de,3883,2389,2397,1 ..... etc ...
2
votes
2answers
129 views

Directory contents into a spreadsheet entry

I would like to turn the contents of a folder into entries for Numbers (or Excel) - is there a way to automate doing this?
0
votes
0answers
43 views

How to calculate total rental income of a property in Numbers?

I'm trying to calculate the total rental income of a property which increases in value over time. If I assume that the rent will always be 5% of the property value, and that the property is initially ...
1
vote
2answers
43 views

Keyboard shortcut for prev/next sheet in Numbers 3

is there a keyboard shortcut for moving to the next or previous sheet in Numbers 3? I have a dream I found those shortcuts, but can't seem to figure out what they were...
0
votes
0answers
37 views

Numbers 3.1: Maintain Link to CSV

Is there a mechanism to maintain a link between a CSV that may change and a Numbers file? I would like to maintain a Numbers file that uses table data from a CSV whose contents will be updated every ...
0
votes
0answers
31 views

Map date and time entries to single day in Numbers

I am keeping track of a certain value that varies during the day, and from day to day. I make entries in my Numbers table as I get the values during the day. Column A is the time entry: month day year ...
2
votes
2answers
97 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 ...
1
vote
1answer
29 views

Tracing the forward use of values in formulas in Numbers

I use Numbers version 3.1 on Mavericks. One can easily look at a formula in a given cell and immediately see the other cell references it uses. I think of this as a backwards look. Does any means ...
2
votes
0answers
32 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 ...
3
votes
1answer
383 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, ...
2
votes
0answers
75 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
2answers
1k 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. ...
1
vote
0answers
73 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
28 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
1answer
109 views

Insert MathType Equation is disabled in Numbers

I am running Numbers 3.1. When I try to select the Insert > MathType Equation... option, it is disabled. There doesn't seem to be anything in the help related to this feature. How can I use this ...
2
votes
0answers
37 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.
1
vote
1answer
166 views

Updating a chart dynamically in Numbers

Background: I've been having some sleep issues so I have started tracking my sleep habits along with some other data but so far, they are just entries in Evernote and as such it is not possible to see ...
3
votes
1answer
1k 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 ...
2
votes
2answers
517 views

Connecting MySQL DB to Apple iWork Numbers?

I'd like to visualize some data from a MySQL database using a Mac, but it hasn't been easy finding a solution to this. I understand Excel has DB connectivity, but currently I only have Apple Numbers. ...
0
votes
0answers
30 views

iMac OS X 10.9.1

I am a new user of Macs and Numbers and need a little help. I am creating a Numbers page for a game I play in which I have multiple trains with various loads they can carry. I have entered this data ...
2
votes
1answer
136 views

Reinstall Numbers?

I got myself into a state where App Store says that I have numbers "installed" but in fact I don't have it installed. I tried the recommended option/click and shift/click over the installed button and ...
3
votes
1answer
3k 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 ...
1
vote
1answer
89 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 ...
3
votes
1answer
422 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 ...
2
votes
1answer
2k 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 ...
5
votes
1answer
3k 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 ...
0
votes
0answers
16 views

Copying - Old Version vs. New Version of Numbers

I use Numbers for a relatively primitive way to catalog books I have read. The old version would copy the date (month/year) and the author's name once I entered the first couple characters. Now I have ...
1
vote
2answers
1k views

Can I remove items from my App Store updates

The App Store wants me to update my Pages 4.3 to Pages 5.0. Given the changes to and reviews of Pages 5.0, I wish to stay with 4.3. Can I somehow delete the upgrade reminder from the list? I ...
6
votes
3answers
117 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 ...
4
votes
1answer
511 views

Numbers no longer opens .xls spreadsheet

I have very recently converted to a MacBook Air from a PC and have a 1.3mb .xls file which 1 week ago Numbers happily opened, edited and saved in its own format. Today, when I opened it it was ...
2
votes
1answer
1k 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?
1
vote
1answer
339 views

Numbers: How to change cell text conditionally?

I am trying to change the text of a cell in Numbers 3 according to a condition. E.g. if A1-A2 is a negative value, the text shall be 'Negative'. If the value is positive the text shall be 'Positive'. ...
0
votes
1answer
605 views

Insert date & time in latest version of Numbers

I've looked around online and have found references to an "Insert => Date & Time" capability in Numbers for OSX. But it's not there in my version of Numbers (3.0.1 -- 1483). Has this capability ...
3
votes
1answer
255 views

Numbers 3 - How to apply custom chart style

Using Numbers 3.0 with Mavericks. I am creating a bunch of scatter plots in numbers. I want to remove the big bubbly data point symbols and simply display the data as connected points. Setting this ...
4
votes
2answers
157 views

How to write AND condition in Numbers

I have a dataset where I want to write a COUNTIFstatement in Numbers (Mavericks). Specifically I want to count if a number is between 16 and 30. So far I have tried: COUNTIF(test-array, ">15 AND ...
4
votes
2answers
2k 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 ...
5
votes
2answers
5k 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: ...
0
votes
0answers
30 views

iWork Numbers 3: detect change in row

I'd like to update the datetime in a cell whenever any cell in the row changes. Is this possible in iWork Numbers 3? If not possible to look for changes in entire row then perhaps only "watching" a ...
0
votes
1answer
39 views

Where has Numbers gone?

I created several spreadsheets in Numbers. Lately I have been using Excel, which won't open them. I can't find Numbers in my application folder--is it hiding somewhere??
0
votes
1answer
805 views

Mac Numbers date functions

Can I colour a cell red if todays date is on or after the date I have entered in the cell? I have tried the IF function and conditional formatting but cannot make it work...
0
votes
2answers
42 views

Numbers.app - How do I add a series of columns

I have a spreadsheet with about 600 rows and 20 columns. I want to add a unique identifier to each cell so that I can use the exported CSV output in another app. So I thought that I could add a ...