Numbers User Guide for Mac
- Intro to Numbers
- Intro to images, charts, and other objects
- Create a spreadsheet
- Open or close spreadsheets
- Personalize templates
- Use sheets
- Undo or redo changes
- Save your spreadsheet
- Find a spreadsheet
- Delete a spreadsheet
- Print a spreadsheet
- Change the sheet background
- Touch Bar for Numbers
- Use VoiceOver to create a spreadsheet
- Wrap text to fit in a cell
- Highlight cells
- Filter data
- Alphabetize or sort data in a table
- Modify chart data
- Move and resize charts
- Select text and place the insertion point
- Use a keyboard shortcut to apply a style
- Format lists
- Add and edit equations
- Add a highlight effect to text
- Add links
- Add rules (lines) to separate text
- Add lines and arrows
- Animate, share, or save drawings
- Set movie and image formats
- Change object transparency
- Fill objects with color or an image
- Add a border to an object or sheet
- Add a caption or title
- Add a reflection or shadow
- Use object styles
- Resize, rotate, and flip objects
- Use iCloud with Numbers
- Import an Excel or text file
- Export to Excel or another file format
- Reduce the spreadsheet file size
- Save a large spreadsheet as a package file
- Restore an earlier version of a spreadsheet
- Move a spreadsheet
- Lock a spreadsheet
- Password-protect a spreadsheet
- Create and manage custom templates
Highlight text in Numbers on Mac
You can highlight text in text boxes and in shapes. These highlights aren’t visible in printed spreadsheets.
When multiple people are working on a spreadsheet, each person’s highlights appear in a unique color. To learn how to change your color, see Set author name and comment color in Numbers on Mac.
Tip: If you want highlights that are visible in your final spreadsheet, add a background color to text in any color. This type of highlight isn’t included with Numbers review tools.
Add a highlight
Select the text you want to highlight.
Choose Insert > Highlight (from the Insert menu at the top of your screen).
The Insert button on the Numbers toolbar doesn’t have the Highlight command.
You can’t highlight text in table cells, but you can add conditional highlighting to a cell to change a cell’s appearance based on its value.
Add a comment to highlighted text
Move the pointer over the highlighted text.
Click “Add a comment,” then type your comment.
Remove a highlight
Move the pointer over the highlighted text, then click Delete.
If the Delete button doesn't appear, that means the highlight was added as color behind the text. To remove it, remove the background color.