Numbers for Mac

Numbers how-to guides

Every Numbers guide we have, newest first. Each one lists the menu path, the shortcut and what to do when it does not work.

A person at a desk typing on a laptop, the setting for adding a checkbox in Numbers on MacEasy · 3 minHow to add a checkbox in Numbers on Mac: table cells, Format sidebar, Data FormatHow to add a checkbox in Numbers on Mac: select table cells, open the Format sidebar, and choose Checkbox from the Data Format menu.Person at a laptop keyboard checking a spreadsheet before adding a formula in Numbers on MacEasy · 5 minHow to add a formula in Numbers on Mac: step by step for Numbers 15.4Learn how to add a formula in Numbers on Mac: click a cell, type =, add cells and operators, then press Return. Steps for Numbers 15.4.Person adding a new sheet in Numbers on a Mac laptop at a deskEasy · 2 minHow to add a sheet in Numbers on Mac: plus button and shortcut, step by stepAdd a sheet in Numbers on Mac with the plus button or Shift-Command-N. Steps, sheet versus table tips and fixes for Numbers 15.4 and macOS 26.Person at a desk on a Mac laptop learning how to add a table in Numbers on MacEasy · 5 minHow to add a table in Numbers on Mac: the Table button, styles and resizingLearn how to add a table in Numbers on Mac: click the Table button, pick a style, then resize it, add rows and format it in the Format sidebar.Person at a laptop learning how to add a text box in Numbers on MacEasy · 4 minHow to add a text box in Numbers on Mac: Text button steps for Numbers 15.4How to add a text box in Numbers on Mac: click the Text button in the toolbar, drag the box into place, then type. Steps for resizing and deleting too.Person at a laptop reviewing a spreadsheet table, where header rows in Numbers on Mac keep labels visibleEasy · 3 minHow to add header rows in Numbers on Mac: Format sidebar steps for Numbers 15How to add header rows in Numbers on Mac: open the Format sidebar, click Table, and set Headers & Footer to a number. Steps for Numbers 15, with fixes.Person working on a laptop at a desk with a spreadsheet, the kind of table where you create a drop down list in Numbers on MacEasy · 10 minHow to create a drop-down list in Numbers on Mac: Pop-Up Menu steps, Numbers 15.4Learn how to create a drop down list in Numbers on Mac. Select cells, open the Format sidebar, and choose Pop-Up Menu, the Numbers name for it.Person working on a spreadsheet on a laptop, the kind of table work where you duplicate a table in Numbers on MacEasy · 3 minHow to duplicate a table in Numbers on Mac: Command-D steps for Numbers 15.4How to duplicate a table in Numbers on Mac: select the table by its handle, press ⌘D, then drag the copy clear. Steps for Numbers 15.4.Person working on a spreadsheet on a Mac, learning how to export numbers to excel on macEasy · 5 minHow to export numbers to excel on mac: File menu steps for macOS 12 to 27How to export numbers to excel on mac: File > Export To > Excel, pick your worksheet layout, then click Export. Steps for each macOS version.Person at a desk with a laptop, preparing to export numbers to pdf on mac for a clientEasy · 5 minHow to export numbers to pdf on mac: a spreadsheet in Numbers, step by stepLearn how to export numbers to pdf on mac with File > Export To > PDF or Share > Export and Send, plus fixes for blank pages and missing comments.Person at a laptop on a desk, working through a table of data to filter a table in Numbers on MacEasy · 5 minHow to filter a table in Numbers on Mac: filter table rows step by stepLearn how to filter a table in Numbers on Mac with the Organize sidebar, Quick Filter, and the ⌥⌘F shortcut. Steps and fixes included.Person working at a Mac laptop on a spreadsheet, the setting for finding and replacing text in Numbers on MacEasy · 5 minHow to find and replace in Numbers on Mac: step by step, limits and fixesHow to find and replace in Numbers on Mac: press Command-F, pick Replace All or Replace, and avoid the blank-field trap in your spreadsheet.Person learning how to format cells as currency in Numbers on Mac at a laptop deskEasy · 3 minHow to format cells as currency in Numbers on Mac: steps for Numbers 15.4Learn how to format cells as currency in Numbers on Mac: select cells, pick Currency in the Format sidebar, then set decimals and the symbol.Person at a desk learning how to highlight cells in Numbers on Mac on a laptopEasy · 6 minHow to highlight cells in Numbers on Mac with conditional rules, step by stepLearn how to highlight cells in Numbers on Mac with conditional rules. Select cells, add a rule, pick a color, then fix common problems.Person at a desk who wants to add an image in Numbers on MacEasy · 5 minHow to add an image in Numbers on Mac: step by step for Numbers 15.4How to add an image in Numbers on Mac: use Insert Media, drag a file onto the sheet, or replace a picture in Numbers 15.4 on macOS 26.Person at a Mac checking a spreadsheet formula, the setting for how to look up a function in Numbers on MacEasy · 5 minHow to look up a function in Numbers on Mac with Formulas and Functions HelpLearn how to look up a function in Numbers on Mac using the Help menu and the Functions Browser, with steps for Numbers 15.4 and error fixes.Person at a laptop working on a spreadsheet table, the kind where you merge cells in Numbers on MacEasy · 3 minHow to merge cells in Numbers on Mac: table cells, Control-click steps and fixesHow to merge cells in Numbers on Mac: select adjacent cells, Control-click them, choose Merge Cells. Covers unmerging, data loss and dimmed menus.Person at a desk reading steps for how to open excel file in numbers on macEasy · 4 minHow to open excel file in Numbers on Mac: three methods for Numbers 15.4How to open excel file in Numbers on Mac: drag the file onto Numbers, use File > Open, or Control-click it in Finder. Steps for Numbers 15.4.Person at a laptop with a spreadsheet open, learning how to rename a sheet in Numbers on MacEasy · 2 minHow to rename a sheet in Numbers on Mac: step by step for Numbers 15.4How to rename a sheet in Numbers on Mac: double-click the sheet's name on its tab, type the new name, then press Return. Works in Numbers 15.4.Person at a Mac learning how to share a spreadsheet in Numbers on MacEasy · 6 minHow to share a spreadsheet in Numbers on Mac: invite people or send a linkHow to share a spreadsheet in Numbers on Mac: click Share, choose Share a Link, set who can access and edit, then send it by Mail or Messages.Person at a desk sorting a table in Numbers on a MacEasy · 5 minHow to sort a table in Numbers on Mac by column, step by stepLearn how to sort a table in Numbers on Mac: use the column arrow for one column, or the Organize sidebar's Sort tab for several levels.Person using a Mac laptop to work on a spreadsheet, the kind of file you can sync with iCloud in NumbersEasy · 15 minHow to use iCloud with Numbers on Mac: sync, save and find spreadsheets in macOS 26Learn how to use iCloud with Numbers on Mac: turn on sync, save and move spreadsheets to iCloud Drive, and fix common errors in Numbers 15.4.Person at a desk on a Mac keyboard, practicing how to use keyboard shortcuts in Numbers on MacEasy · 12 minHow to use keyboard shortcuts in Numbers on Mac: rows, formulas, sheets and custom keysHow to use keyboard shortcuts in Numbers on Mac: the keys for rows, formulas, Find and sheets, plus how to set your own in System Settings.