28 votes

How to fill down in Numbers without dragging?

Found a way. Select the column Deselect the header row (Cmd click on the header row cell) Table Menu > Autofill Cells > Autofill Down This will ​not​ infer a pattern. (ex 1,2,3 it will just copy ...
Joshua Dance's user avatar
  • 1,873
25 votes

Is there a hack for "Save As..." command?

With the File menu open, press and hold the Option key to get the Save As... command. Update: Some new users of macOS may be concerned about the discoverability of the command, as it is not visible ...
Nimesh Neema's user avatar
  • 51.9k
17 votes
Accepted

Open CSV File with Different Delimiter

In Numbers you can use any separator when importing csv tables. On the format sidebar, in the table tab, look for adjust Import settings. Inside it you have delimited options where you can even use ...
TomRitchey's user avatar
17 votes

Old version (macOS Sierra) for Pages, Keynote and Numbers, iWork

You need to have an old version of Pages, Keynote and Numbers installed in your Applications folder to be able to update them. If you lack these (either because you deleted them or never had them ...
Tatjana Heuser's user avatar
13 votes

Time as x-axis in chart with Apple Numbers

This can't be done with an area graph. You need to use a scatter graph, or to insert hidden rows for each increment missing. This has been an annoyance of mine for a long time — I have provided ...
grg's user avatar
  • 201k
12 votes

Time as x-axis in chart with Apple Numbers

you need an x-y scatter (or a x-y balloon, though I haven't tried this one) The most important part is to NOT USE the row and column headers! enter your data in two columns, the first column is the ...
Joseph Ian Walker's user avatar
11 votes
Accepted

Numbers can’t be installed on “macos” because macOS version 11 or later is required

Open the App Store application. If necessary, sign in. Press the key combination ⌘0 or select Store→View My Account..... If you previously downloaded Numbers, then you should be able to download the ...
David Anderson's user avatar
10 votes

How to fill down in Numbers without dragging?

It is late for response here. I have a file with 65500 rows which I need to add sequence of numbers (1,2,3,etc) to it. This is how you do it. Row 1, column 1 type 1 In Row 2, column 2 type use ...
Mr H's user avatar
  • 201
10 votes
Accepted

Locking cells in numbers

The short answer is, no, however you can lock a table. To lock a Table, select it and then, from the Menu bar, click: Arrange > Lock The longer answer is, if you want to protect* a cell or ...
user3439894's user avatar
  • 58.7k
10 votes

Is there a hack for "Save As..." command?

As others have said, you can get ‘Save As’ with the Option key. However, I prefer another way, which I have been promoting since Mountain Lion came out in 2012. Go to System Preferences » Keyboard » ...
TJ Luoma's user avatar
  • 20.7k
10 votes
Accepted

Trying to catalog my movie collection into Numbers app and "48 hours" becomes "2d"

By default, Numbers formats table cells automatically. If you enter only a numeric character, it assumes it is a number and displays it accordingly. Entries that look like durations are automatically ...
Alper's user avatar
  • 3,956
9 votes
Accepted

Almost all Functions in Numbers on MacOS Give Me Syntax Errors

Try using ; as a separator between parameters instead of ,. If you start typing the function name in a cell and let it autocomplete you should also be able to see which separator will work and how the ...
Lizzan's user avatar
  • 9,128
9 votes
Accepted

Changing CSV Delimiting Character in Numbers

Open csv file Click on adjust settings popup that appears on top right. In format section, in Table tab, at the bottom, find adjust import settings Change delimiter.
anki's user avatar
  • 11.8k
8 votes
Accepted

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

Just to make an official answer: Use the SUMIFS() function to use 2 or more conditions. From the documentation: The SUMIFS function returns the sum of the cells in a collection where the test ...
bjbk's user avatar
  • 9,463
8 votes
Accepted

How to convert a cell with a duration (datetime difference) to number in Numbers?

Use the DUR2HOURS() formula. DUR2HOURS(F3) Pass the duration from F3 to the formula.
bjbk's user avatar
  • 9,463
7 votes
Accepted

Numbers: Make numbers negative

A workaround is to create a column with formulas like "=-1 * A1", then copy and "Paste Formula Results" (⇧⌘V). But I'm sure there are better solutions.
Yuri Schimke's user avatar
7 votes
Accepted

Merge Spreadsheets

Let's make some assumptions: The only column in Table 2 you care about is Website All of the data in both Name columns is 100% correct and can be matched "exactly" (i.e. not fuzzily) The columns are ...
shadowtalker's user avatar
7 votes
Accepted

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

This answer assumes: you have a header row and, because of that, the first row containing your data is Row 2. that Column D is empty Please see my notes at the end if the above assumptions are ...
Monomeeth's user avatar
  • 64.6k
7 votes

How can I turn off the "Numbers" application?

To really address your question, you can uninstall the application or you can just change it so that all .csv files are opened in your application of choice. Just right-click on a file that uses the ...
ErniePC12's user avatar
  • 1,264
6 votes

How can I use a secondary axis in Numbers?

Yes Numbers does now supports two axes. Steps are: Select the chart, change the type to 2D 2-Axis Make sure you have more than one data series selected. The Series tab for each data series will allow ...
MichaelR's user avatar
  • 734
6 votes

Numbers: Count unique items in a column

You can use Numbers' (new) Pivot Table tool to summarize data To get count of unique value: Make sure your table is selected On toolbar, click Pivot Table In sidebar, select your column under Fields ...
Paul's user avatar
  • 221
6 votes

Lookup up cell values in Numbers

This answer to a related question explains how to use VLOOKUP in combination with IFERROR. If VLOOKUP cannot find the exact match, then it throws an error. To catch this error, wrapping the formula ...
bjbk's user avatar
  • 9,463
6 votes
Accepted

Get Numbers & Pages et al. on macOS 10.11 El Capitan

I had this issue too. Whenever I used an Apple ID that hadn't previously downloaded iWork I wasn't able to download the free version on 10.11. I even tried this workaround. What did work was getting ...
sansSpoon's user avatar
  • 1,037
6 votes
Accepted

Apple Numbers IF rules with checkboxes

A look at SUMIFS and SUMIF in the help files will point you in the right direction. First case: Total all currency in column when checkbox is not ticked. A checkbox not ticked returns false, ...
bjbk's user avatar
  • 9,463
6 votes
Accepted

Creating a search engine within Numbers on a Mac

All steps in this answer need to be carried out on your Search sheet. There is no need to touch your Data sheet. First make sure you have at least 4,506 rows available in your Search Sheet. The ...
Monomeeth's user avatar
  • 64.6k
5 votes
Accepted

Concatenate not working in Numbers

Some locales use semicolon as a separator for parameters in formulae, such as Turkey. You can check this by using a comma after the first parameter, then clicking a cell. If you see a semicolon being ...
grg's user avatar
  • 201k
5 votes

Numbers - Conditional Sum

Ok, so it's something like this SUMIF(B2:B37,"=IP",C2:C37) Where B is the text column to test,=IP is the test condition, C are the values to sum.
resting's user avatar
  • 827
5 votes
Accepted

How can I export a Numbers 3.x chart to PDF?

open the context menu on the chart (e.g., control-click or right-mouse click) select Copy as PDF. paste into application (e.g. Adobe Illustrator) or in Preview create a new file with File -> New from ...
orbeckst's user avatar
  • 226
5 votes
Accepted

Numbers: Creating a Summary table based on values from different table

If your category column contains categories that are correctly spelled each time, then a simple solution would be to use the SUMIFS() and the COUNTIFS() formulas. In the Summary table, add a category ...
bjbk's user avatar
  • 9,463

Only top scored, non community-wiki answers of a minimum length are eligible