Name: NUMBERS
Brand: APPLE
Rating: 9 (239 reviews)

Question 1

How to create a new table in Numbers?

Accepted Answer

Click the Tables button in the toolbar and choose a predefined table, or select Insert > Table. You can also drag cells from another table.

Question 2

How to add a formula to a cell?

Accepted Answer

Select the cell, type the = sign to open the Formula Editor, then enter your formula. You can also use the Formula bar or the Function Browser.

Question 3

Can I import an Excel file into Numbers?

Accepted Answer

Yes, Numbers can import .xls, .xlsx, .csv and .ofx files. Drag the file onto the Numbers icon or use File > Open.

Question 4

How to create a chart from table data?

Accepted Answer

Select the cells containing the data, then click Charts in the toolbar and choose a chart type. You can modify the plotted data via the Chart Inspector.

Question 5

How to print a spreadsheet with headers?

Accepted Answer

Switch to Print Preview (View menu), enable layout display, then click in the header or footer to add text or page numbers.

Question 6

Is it possible to add images to table cells?

Accepted Answer

Yes, drag an image from the Media Browser or Finder directly into a cell. You can also use the Cell Inspector to set an image fill.

Question 7

How to sort table data?

Accepted Answer

Select the table, click the Sort button in the toolbar, or use Table > Sort. Choose the sort column and order (ascending or descending).

Question 8

Can I protect my Numbers file with a password?

Accepted Answer

Numbers does not offer built-in password protection, but you can use Mac OS X encryption features (e.g., FileVault) or add a password to the file via Disk Utility.

Question 9

How to add Address Book data to a table?

Accepted Answer

Use Insert > Address Book and follow the instructions to map fields. You can add data to an existing table or create a new one.

Question 10

What to do if a font is missing in the document?

Accepted Answer

Numbers will display a warning dialog. Click Replace Font to choose a replacement font. You can also install the missing font in your Mac's Fonts folder.

Question 11

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 12

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 13

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 14

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 15

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 16

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 17

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 18

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 19

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 20

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.

Question 21

How to automatically calculate a date 6 months after a given date in Apple Numbers?

Accepted Answer

To automatically calculate a date that is 6 months after a specified date in a Numbers cell, you can use the DATE function combined with YEAR, MONTH, and DAY. Here’s how to do it:

Assume the initial date is in cell A1.
In the cell where you want to display the date 6 months later, enter the following formula:

=DATE(YEAR(A1), MONTH(A1) + 6, DAY(A1))

This formula works as follows:

YEAR(A1) retrieves the year of the initial date.
MONTH(A1) + 6 adds 6 months to the month of the initial date.
DAY(A1) keeps the same day.

Numbers automatically adjusts the year if the month exceeds 12 (for example, if the initial date is in July, the formula correctly calculates the date in January of the following year).

This method allows you to easily automate the calculation of dates shifted by several months in your spreadsheets.

Question 22

How to save a chart as a new style in Apple Numbers?

Accepted Answer

Numbers does not have a function to save an individual chart as a reusable new style, unlike tables. However, Apple Numbers offers several solutions to reuse the formatting of your charts.

Set default attributes for a chart type: This is the official method to standardize the appearance of charts. Select a chart that you have formatted to your liking (colors, fonts, labels, legends, etc.), then click on Format in the sidebar. Go to the Advanced tab and choose 'Set default style for chart type'. From then on, all new charts of the same type (bars, columns, lines, pie, etc.) created on this spreadsheet will automatically use these settings.

Copy and paste a formatted chart: A simple alternative is to copy an already formatted chart. Select the customized chart, then press Command+C (Mac) or Control+C (Windows). Then click where you want to place the new chart and paste with Command+V or Control+V. The duplicated chart retains all the original formatting. You can then modify the associated data without losing the style.

Direct customization: Each chart can be fully customized via the Format panel. Select the chart, then click on Format in the sidebar to access color, fill, stroke, label, legend, and other formatting options. Changes made only affect that specific chart.

To ensure visual consistency in your spreadsheet, we recommend setting default attributes at the beginning of your work, then duplicating formatted charts as needed rather than recreating them manually.

Question 23

How to activate and use the 'Search in Selection' option in Apple Numbers?

Accepted Answer

Important: Apple Numbers does not offer an explicit native option called 'Search in Selection' like some other spreadsheets. Contrary to what you might assume, pre-selecting cells does not prevent the search from scanning the entire document. Here’s how search actually works in Numbers and the available options.

To access the Find and Replace function, you have two options. On Mac, use the keyboard shortcut Command + F, or navigate to the View menu (in the toolbar) and select Show Find and Replace. A search bar appears at the top of your spreadsheet. Enter the text you want to find in the input field, and Numbers automatically highlights all matching occurrences as you type.

To refine your search, Numbers offers you two specific options. Click on the dropdown menu to the left of the search field to access these settings: Whole Words (which avoids finding partial matches - for example, searching for 'analysis' will not find 'analyze') and Case Sensitive (which limits results to text that exactly matches your capitalization). You can combine these two options for even more precise results.

If you want to replace text, click on Find and Replace in the same menu. You can then replace each occurrence individually after review, or use Replace All to change all matches in one action. Note that you cannot replace text in cells containing formulas - Numbers only allows you to replace values in simple cells without calculations.

To limit your search to a specific area of your sheet, the best workaround is to use the built-in Shortcuts app on your Apple device. You can create or download a 'Find and Replace in Selection' shortcut that restricts the search only to the cells you have previously selected. Simply select your range of cells in Numbers, then run this shortcut from the menu or if you have pinned it to the menu bar.

This limitation exists across all versions of Numbers: Mac, iPad, and iPhone. Apple has not added a native button for 'Search in Selection' despite recurring user requests. So, if a full document search does not meet your needs, prefer the shortcut or perform your search normally and then ignore the results outside the area that interests you.

Question 24

How to limit search and replace to a specific column or row in Apple Numbers?

Accepted Answer

To limit search and replace to a specific column or row in Apple Numbers, follow these steps:

Steps to limit search and replace

Open your spreadsheet in the Numbers application.
Select the column or row in question by clicking on the column header (letter) or the row number. This will highlight the selection.
Access the Find and Replace function by pressing Command + F or by going to the Edit > Find > Find and Replace... menu.
Enable the

Question 25

How to change the comment triangle color in Apple Numbers?

Accepted Answer

In Apple Numbers, you can change the color of your comments by changing your author color. Although the small triangle in the corner of the cell remains visible, its color and that of the comment bubble change according to your settings. This feature is very useful in a collaborative context to quickly identify the author of each comment.
Here’s how to change the comment color:

Click on View in the menu bar
Select Comments
Click on Author Color
Choose the desired color from the options provided

The new color will be immediately applied to all your existing comments in the current workbook. If your document is shared via iCloud, the color will be synchronized for your Apple account across all your devices (Mac, iPad, iPhone) and visible to other collaborators.
Important points to remember: For your new author color to be saved in the Numbers preferences, you must add at least one new comment or make a change with this new color. Your color settings will also apply to all future workbooks you create. In collaboration with other users, each participant will have their own automatically assigned comment color, which greatly facilitates identifying who wrote each comment and to whom it is addressed.

Product type	Spreadsheet software for Mac OS X
Version	iWork '08 (Numbers 1.0)
Main functions	Creating spreadsheets, tables, formulas, charts, formatting, import/export Excel, PDF, CSV
Supported file formats	.numbers (native), .xls, .xlsx, .csv, .pdf, .ofx
Interface languages	French, English, German, Spanish, Italian, etc.
Minimum system requirements	Mac with PowerPC G4 or Intel processor, Mac OS X 10.4.10 or later, 512 MB RAM
Number of sheets per document	Unlimited (depending on memory)
Available chart types	Bars, columns, lines, pie, scatter, 3D
Built-in calculation functions	Over 250 functions (financial, statistical, trigonometric, etc.)
Import from Address Book	Yes
Export to iWeb	Yes
Printing	Print preview, headers/footers, page numbering, adjustable margins
Conditional formatting	Yes
Sorting and filtering tables	Yes
Maintenance and cleaning	Updates via Apple Software Update; keep system up to date
Security	Document password protection (via operating system)
Spare parts and repairability	Apple technical support, online assistance, repair via Apple Store or authorized service center
General information	Professional spreadsheet software from Apple's iWork suite, comprehensive 946-page user manual in PDF format

67	Using Date and Time Format
68	Using Fraction Format
69	Using Scientific Format
69	Using Text Format
70	Using a Checkbox and Other Control Formats
73	Controlling Cell Values
74	Adding Images and Colors to Cells
74	Automatically Filling Table Cells
75	Using Rows and Columns
75	Adding Rows
76	Adding Columns
76	Rearranging Rows and Columns
77	Deleting Rows and Columns
77	Using a Table Header Row or Column
78	Using a Footer Row
79	Options for Hiding Rows and Columns
79	Resizing Rows and Columns
80	Alternating Row Colors
81	Using Table Cells
81	Merging Table Cells
81	Dividing Table Cells
82	Formatting Cell Borders
83	Copying and Moving Cells
84	Adding Comments
84	Reorganizing Tables
85	Sorting Table Cells
86	Filtering Rows

87	Using Table Styles
87	Using Styles Applicable to Tables
88	Applying Styles to Tables
88	Modifying a Table Style
88	Modifying Table Style Attributes
89	Copying and Pasting Table Styles
89	Using the Default Table Style
90	Creating Styles Applicable to Tables
90	Renaming a Style Applicable to Tables
90	Deleting a Table Style

91	Using Formulas and Functions in Tables
91	Using Formulas
92	A Guided Tour of Using Formulas

94	Performing Instant Calculations
95	Adding a Quick Formula
96	Basic Calculation With Values in the Same Row
96	Basic Calculation With Values in the Same Column
96	Deleting a Formula
97	Using the Formula Editor
97	Adding a New Formula Using the Formula Editor
98	Modifying a Formula Using the Formula Editor
98	Using the Formula Bar
99	Adding a New Formula Using the Formula Bar
100	Modifying a Formula Using the Formula Bar
100	Using Cell References
100	Adding Cell References to a Formula
102	Copying or Moving Formulas Containing Cell References
103	Applying a Formula to Column or Row Cells at Once
103	Managing Errors and Warnings
104	Using Operators
104	Calculating Arithmetic Operations
105	Explaining Arithmetic Operators
105	Explaining Comparison Operators
106	Using Functions

NUMBERS - Spreadsheet APPLE - Free user manual and instructions

Frequently Asked Questions - NUMBERS APPLE

User questions about NUMBERS APPLE

1. Manually add a column for numbers

2. Use text boxes on printed pages

3. Export to another software for automatic numbering

1. Selecting non-contiguous cells

2. Using non-contiguous cells in a formula

3. Example with SUMIF

Summary

Steps to set a repeated header row

Additional information

Steps to insert a checkbox:

Using the checkbox in a formula:

Usage examples:

Accepted date formats in Numbers

Checking and setting the cell format

Steps to limit search and replace

USER MANUAL NUMBERS APPLE

User Guide

Preface 16 Welcome to the Numbers User Guide

Chapter 1 18 Numbers Techniques and Tools

Chapter 2 31 Using a Numbers Spreadsheet

Chapter 3

46 Using Tables

Chapter 4

Chapter 5

Chapter 6

Chapter 7

133 Using Text

Chapter 8

108	Using Charts
108	About Charts
111	Adding a Chart
113	Modifying a Chart
114	Modifying the Chart Orientation
114	Modifying the Data Plotted on a Chart
114	Adding Data to a Chart
115	Adding Data to a Chart From Multiple Tables
115	Removing Data From a Chart
116	Replacing a Data Series
116	Deleting a Chart
116	Moving a Chart
117	Changing the Chart Type
118	Formatting the General Attributes of a Chart
118	Using a Legend
118	Using a Chart Title
119	Resizing a Chart
119	Rotating Charts
120	Adding Axis Labels and Tick Marks
120	Displaying Axes and Borders