Q: How to insert page numbers in the footer of an Apple Numbers document?

In the Numbers application from Apple, there is no built-in feature to automatically add page numbers in the footer like in some word processing software. However, you can work around this limitation using the following methods: 1. Manually add a column for numbers Open your Numbers document. Insert a new column where you want to display the numbers (for example, at the beginning or end of the table). Manually enter the numbers corresponding to each row or section. Format this column to look like a footer (smaller font size, gray color, centered alignment, etc.). 2. Use text boxes on printed pages If you want the numbers to appear only when printing, you can add text boxes in the header or footer through the print option. In the print window, click on Show Print Options and look for header and footer options. You can manually insert a page number, but this method is not dynamic and requires manual updating if the document changes. 3. Export to another software for automatic numbering If automatic numbering is essential, you can export your Numbers document to PDF or Excel format. Then, use a word processing software or a PDF editor that allows you to automatically add page numbers in the footer. In summary , Numbers does not handle automatic footer numbering. The best solution is to manually add a column to simulate this numbering or to use external software for printing with page numbers.

Q: What separator should be used between arguments in a formula in Numbers, a comma or a semicolon?

In Apple's Numbers , the separator used between the arguments of a formula mainly depends on your regional settings, particularly the decimal separator. Numbers automatically inserts a comma (,) between arguments when you select cells, but you need to replace it with a semicolon (;) if the decimal separator for your location is a comma (as is the case in French). For example, in France where the decimal separator is the comma, you should write: =SUM(A1;A2;A3) and not: =SUM(A1,A2,A3) This distinction is important because using a comma as an argument separator in a French-speaking locale would create ambiguity: the comma would be both your decimal separator and your argument separator. That is why Numbers allows you to replace the automatically inserted comma with a semicolon when adding cell references. In summary: if your system uses a comma as the decimal separator (French, Belgian, Swiss French localization, etc.), use the semicolon to separate the arguments. If you are using an English-speaking locale where the decimal separator is the point, the comma can generally be retained.

Question 1

How to insert page numbers in the footer of an Apple Numbers document?

Accepted Answer

In the Numbers application from Apple, there is no built-in feature to automatically add page numbers in the footer like in some word processing software. However, you can work around this limitation using the following methods:

1. Manually add a column for numbers

Open your Numbers document.
Insert a new column where you want to display the numbers (for example, at the beginning or end of the table).
Manually enter the numbers corresponding to each row or section.
Format this column to look like a footer (smaller font size, gray color, centered alignment, etc.).

2. Use text boxes on printed pages

If you want the numbers to appear only when printing, you can add text boxes in the header or footer through the print option.
In the print window, click on Show Print Options and look for header and footer options.
You can manually insert a page number, but this method is not dynamic and requires manual updating if the document changes.

3. Export to another software for automatic numbering

If automatic numbering is essential, you can export your Numbers document to PDF or Excel format.
Then, use a word processing software or a PDF editor that allows you to automatically add page numbers in the footer.

In summary, Numbers does not handle automatic footer numbering. The best solution is to manually add a column to simulate this numbering or to use external software for printing with page numbers.

Question 2

How to select and use non-contiguous cells in Apple Numbers for calculations?

Accepted Answer

In Apple Numbers, it is common to need to manipulate cells that are not adjacent, especially when you want to perform calculations like summing or other operations on non-contiguous ranges of cells. Here’s how to handle this situation:

1. Selecting non-contiguous cells

To select multiple cells that are not next to each other, hold down the Command (⌘) key on your keyboard while clicking on each cell you want to include.
This method allows you to highlight several scattered cells in the sheet.

2. Using non-contiguous cells in a formula

Numbers does not directly allow referencing a non-contiguous range in a single range, but you can sum multiple ranges or individual cells by separating them with plus signs (+) in the formula.

For example, to sum cells B1, B3, and B5, you can write:

=B1 + B3 + B5

If you have many cells to include, this can become tedious. In this case, it is advisable to:

Create a helper column where you mark, for example, with a "1" the rows to include.
Use a conditional function like SUMIF to sum only the corresponding cells.

3. Example with SUMIF

Suppose column A contains criteria and column B contains values, and you want to sum the values in B where column A matches a specific criterion:

=SUMIF(A, "Criterion", B)

This method allows you not to worry about the contiguity of the cells, as the function automatically filters the rows according to the criterion.

Summary

To manually select non-adjacent cells, use the Command (⌘) + click.
To calculate with non-contiguous cells, sum them in the formula or use conditional functions.
For complex selections, a helper column with criteria makes calculations easier.

Question 3

How to perform a conditional sum of a column in Numbers on Mac based on a specific value in the previous column?

Accepted Answer

In Apple Numbers on Mac, to perform a conditional sum of a column based on a specific value in the previous column, you need to use the SUMIF function. This function evaluates the cells in a range according to a criterion and sums the corresponding values from another range.

The basic syntax is as follows: =SUMIF(criteria_range, "value", sum_range). For example, if you have categories in column A and amounts in column B, and you want to sum the amounts only for a specific category, you would write: =SUMIF(A:A, "Category", B:B). This formula will check each cell in column A and only sum the values in column B when column A exactly matches your value.

To set up this formula in your Numbers sheet, first select the cell where you want to display the result. Then, click on the function icon (fx) in the toolbar or use the Insert > Function menu to open the function browser. Search for SUMIF and select it to get an input assistant that will guide you in setting the parameters.

It is recommended to specify the exact ranges rather than entire columns for clarity and performance. For example, use =SUMIF(A2:A100, "value", B2:B100) if your data is between rows 2 and 100, thus excluding headers. Remember that the criterion value must exactly match the text or number in the previous column; case sensitivity may not always be ignored depending on your settings.

If you have multiple conditions to apply (for example, summing based on two different columns), Numbers cannot handle multiple criteria in a single SUMIF function. The solution is to create several distinct SUMIF formulas and sum them in a separate cell with a simple addition, for example: =SUMIF(A:A, "Category1", B:B) + SUMIF(A:A, "Category2", B:B).

Question 4

How to repeat a table title on each page when printing in Apple Numbers?

Accepted Answer

To repeat a title or header row on each page when printing in Apple Numbers, follow these simple steps:

Steps to set a repeated header row

Open your Numbers document containing the relevant table.
Select the table in which you want the title to be repeated.
Click on the row that contains the title or column headers to select it.
In the menu bar at the top, click on "Table".
In the dropdown menu, choose "Set as header row".

Once this operation is completed, the selected row will automatically be repeated at the top of each page when printing or exporting your document to PDF.

Additional information

This feature is particularly useful for tables that span multiple pages, to maintain data readability.
You can set multiple header rows if necessary, by repeating the procedure on several rows.
The repetition of titles does not appear in the Numbers interface, but only when printing or in print preview.

Question 5

How to create a dropdown list for all cells in a table in Apple Numbers?

Accepted Answer

To create a dropdown list in table cells in Apple Numbers, you need to add a pop-up menu to each cell. A pop-up menu allows you to predefine the values that a cell can contain, thus limiting the possible entries to your choices.

To add a pop-up menu to cells:

Select the cell or cells where you want to add the dropdown list.
Click on the Other Cell Formats button located in the format bar at the top of the window.
In the dropdown menu, select Pop-up Menu to create a list with the default settings.

To define the items in your list:

Once the pop-up menu is created, click on the Inspector button in the toolbar, then on Cell Inspector.
Make sure Pop-up Menu is selected in the Cell Format menu.
You will see placeholder entries in the Cell Inspector. Click on each entry to modify it and type the value you want to add to your list.
To add a new item to the list, click on the + sign and type the value. Numbers are treated as numbers and not as text.
To remove an item, click on the - sign next to that item.

To apply the same list to multiple cells:

After creating your pop-up menu in one cell, select that cell.
Drag the handle in the bottom right corner of the cell to the other cells where you want to add the same list. This will copy the format and values of the pop-up menu.
You can also copy the cell and paste its format only into other cells.

Once configured, cells with a pop-up menu can only be modified using the dropdown list, ensuring the consistency and validity of your data.

Question 6

How to insert and use a checkbox in a formula in Apple Numbers?

Accepted Answer

In Apple Numbers, it is possible to insert a checkbox in a cell and use it in formulas to create conditional calculations or dynamic displays.

Steps to insert a checkbox:

Select the cell where you want to add the checkbox.
Open the Format panel by clicking on the corresponding icon at the top right.
In the Cell tab, change the Cell Type by selecting Checkbox.

Using the checkbox in a formula:

The checkbox has a boolean value: TRUE if checked, FALSE if unchecked. You can therefore use it directly in your formulas.

For example, if the checkbox is in cell A1, you can write a formula in another cell to display text based on its state:

=IF(A1; "Enabled"; "Disabled")

This formula will display "Enabled" if the checkbox is checked, and "Disabled" otherwise.

Usage examples:

Calculate a value only if the checkbox is checked: =IF(A1; B1 * 2; 0)
Count the number of checked boxes in a range: =COUNTIF(range; TRUE)

These features allow you to make your tables interactive and customized according to your needs.

Question 7

How to create a formula in Numbers to check if a year is a leap year?

Accepted Answer

To determine if a year is a leap year in Numbers, you need to use a formula that applies the rules of the Gregorian calendar. This formula checks three conditions: the year is divisible by 4, it is not a century (unless divisible by 400).

Assuming the year to check is in cell A1. In another cell, enter the following formula:

=IF(AND(MOD(A1, 4) = 0, OR(MOD(A1, 100) <> 0, MOD(A1, 400) = 0)), "Leap Year", "Not a Leap Year")

The MOD function calculates the remainder of the division. MOD(A1, 4) = 0 checks that the year is divisible by 4, which is a necessary condition for a leap year. Then, MOD(A1, 100) <> 0 checks that the year is not a multiple of 100 (i.e., a century like 1900 or 2100). Finally, MOD(A1, 400) = 0 captures the special case of centuries that are still leap years if they are divisible by 400.

The AND function requires that all logical conditions are simultaneously true: the year must be divisible by 4, AND it must either not be a century or be divisible by 400. The OR function provides this alternative: "not a century OR divisible by 400". Finally, the IF function displays "Leap Year" if all conditions are met, otherwise "Not a Leap Year".

For example, the year 2024 is divisible by 4 and is not a century, so the formula returns "Leap Year". The year 1900 is divisible by 4 and by 100, but not by 400, so it returns "Not a Leap Year". The year 2000 is divisible by 4, by 100 AND by 400, so it returns "Leap Year".

Question 8

How to automatically turn a cell red in Numbers when a date is 15 days from the current date?

Accepted Answer

To automatically turn a cell red in Numbers when the date it contains is 15 days from the current date, you can use the conditional formatting feature. Here are the steps to follow:

Select the cell or range of cells containing the dates to check.
In the toolbar, click on the Format button (at the top right).
In the panel that opens, choose Conditional Formatting.
Click on Add a Rule.
In the dropdown menu of rules, select Date is.
Choose the option "in the next 15 days" or "in the 15 days before" depending on whether you want to include future or past dates.
Then set the formatting style, for example, the text or background color to red.
Confirm by clicking on Done.

This rule will automatically apply the red color to cells whose date is within 15 days of the current date, thus facilitating the visualization of upcoming deadlines.

Question 9

What separator should be used between arguments in a formula in Numbers, a comma or a semicolon?

Accepted Answer

In Apple's Numbers, the separator used between the arguments of a formula mainly depends on your regional settings, particularly the decimal separator. Numbers automatically inserts a comma (,) between arguments when you select cells, but you need to replace it with a semicolon (;) if the decimal separator for your location is a comma (as is the case in French).

For example, in France where the decimal separator is the comma, you should write:

=SUM(A1;A2;A3)

and not:

=SUM(A1,A2,A3)

This distinction is important because using a comma as an argument separator in a French-speaking locale would create ambiguity: the comma would be both your decimal separator and your argument separator. That is why Numbers allows you to replace the automatically inserted comma with a semicolon when adding cell references.

In summary: if your system uses a comma as the decimal separator (French, Belgian, Swiss French localization, etc.), use the semicolon to separate the arguments. If you are using an English-speaking locale where the decimal separator is the point, the comma can generally be retained.

Question 10

What date format should be used in cell A1 on Numbers for the formula to work correctly?

Accepted Answer

For the formula to work correctly in Apple Numbers, the date entered in cell A1 must be recognized as a valid date by the application. Here are the key points to follow:

Accepted date formats in Numbers

DD/MM/YYYY (example: 15/03/2023)
YYYY-MM-DD (example: 2023-03-15)
Month Name DD, YYYY (example: March 15, 2023)

Checking and setting the cell format

Select cell A1.
Open the Format menu in the sidebar.
Choose the Cell option and then Date to set the cell format.
Make sure the date is recognized and displayed correctly.

If the date is entered in an unrecognized format or if the cell is not set to Date type, the formula using this cell may not work. Therefore, make sure to follow these formats and set the cell accordingly.

User manual APPLE Spreadsheet : user manuals and guides in PDF

Models APPLE Spreadsheet most viewed

Other categories APPLE

Recent questions about Spreadsheet APPLE