Numbers is a spreadsheet software included in the iWork productivity suite by Apple.

learn more… | top users | synonyms

4
votes
2answers
3k views

Apple Numbers: keyboard shortcut for “smart fill”?

If I've got some sort of patterned data selected — say sequential numbers — I can click and drag the little circle in the bottom right corner of that selection to “smart fill”. For example: Is ...
1
vote
3answers
5k views

Auto-fill rows between two cells in iWork - Numbers (or MS Excel)

This is my table ...A............ 1 1 2 3 4 5 9 I know the minimum value (A1=1) and I know the maxiumum value (A5=9). Now I want to fill the rows in between with the numbers leading up to ...
1
vote
0answers
395 views

How to plot this in iwork-numbers

I have an array of data like this 0,1 0,56 0,4 0,57 0,6 0,006 0,34 0,46 ... I have another array of data that classifies the data above in categories like this: from 0,1 to 0,5 category A from 0,...
3
votes
4answers
2k views

Export to csv options using Numbers

I'm using Numbers on my Mac at the moment and exporting to a CSV file. Is there a way to enclose every value with ""? For example I'm getting the csv file like this: 1,2,3,4,5,6,7,8,9 When I ...
0
votes
2answers
2k views

Apple Iwork Numbers: How to conditionally highlight a cell

I am using apple numbers to do some modeling. (For those of you who are not familiar it is the apple version of excel that makes awesome looking charts, but has a bit less functionality). I am ...
1
vote
2answers
516 views

Not counting values if strikethrough in iWork- Numbers

I'm building a holiday expense planner and I'm trying to get the sum of a column in a table, however as I pay things off I want to be able to strikethrough the amount and then it minus it from the ...
8
votes
2answers
17k views

How to interchange a column and row in a table (Transpose) in iWork Numbers?

I want to transpose a table (interchange rows to columns and vice versa). How to do that in iWork Numbers.
1
vote
1answer
86 views

How to assign a shape to each series of values in iWork '09 Numbers?

How can I assign a shape to each series of values in iWork '09 Numbers? Currently all series are forced to have the same shape, which makes them hard to distinguish on black and white prints.
2
votes
2answers
5k views

iWork Numbers: how to copy only filtered values?

I'm using Apple's iWork Numbers to look through some big spreadsheets of economic data. I used the Sort & Filter Panel to filter out just the rows of data I need, and now I'd like to copy just ...
0
votes
2answers
1k views

Is there a key or combo to edit a formula in Apple's Numbers without using the mouse?

In Excel (and OpenOffice) I could use F2 to edit the existing formula. So far the only 'shortcut' I've found in Numbers involves clicking the mouse. Since I'm going from moving with the keyboard to ...
0
votes
1answer
4k views

Select each nth row in Numbers

I have an iWork Numbers spreadsheet with thousands of rows. How can I select every 5th row from that spreadsheet? See also: Select each nth row in Excel