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.
23 guides
Lazur in Numbers →
How 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.
How 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.
How 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.
How 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.
How 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.
How 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.
How 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.
How 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.
How 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.
How 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.
How 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.
How 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.
How 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.
How 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.
How 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.
How 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.
How 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.
How 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.
How 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.
How 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.
How 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.
How 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.
How 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.