Change the look of text in Numbers on iPad
You can change how text looks by changing its font, size, or color, or by adding bold, italic, or other formatting. You can also fill text with gradients or images, or add an outline. To highlight text, you can add color behind it.
Change text appearance
Select the text you want to change—or tap a text box, shape, or table cell—then tap .
Tap Cell (for text in a table) or Text (for text in a shape or text box), then do any of the following:
Apply a different paragraph style: Tap the style name below Paragraph Style, then tap a new paragraph style. You can’t apply a paragraph style to text in a table cell.
Change the font: Tap Font, then tap a new font. To see more options for the font (light italic, semibold, and so on), tap next to the font name.
Apply bold, italic, underline, or strikethrough: Tap any of the buttons below Font.
Change the size: Tap next to Size to decrease or increase the font size, or tap the font size and enter a new value.
You can use text formatting buttons in the shortcut bar above the keyboard to quickly add bold, italic, or underline to text. These buttons appear on the right of the predictive text fields.
If your keyboard doesn’t show predictive text, you can turn it on in Settings > General > Keyboard.
Change the color of text
Select the text you want to change—or tap a text box, shape, or table cell—then tap .
Tap Cell (for text in a table) or Text (for text in a shape or text box) to show the text controls.
Tap Text Color, then choose one of the following:
A color or gradient designed to go with the template: Tap Preset, swipe left or right to see all the choices, then tap a color.
Any color: Tap Color, then tap a color.
To preview text in different colors, touch and hold a color, then drag across the grid. A color label appears for each previewed color to help you reproduce an exact match. Release your finger to select a color.
A color from elsewhere in the spreadsheet: Tap Color, then swipe left to the color wheel. Tap , then tap any color outside of the selected text. To preview colors, touch and hold a color in the spreadsheet, then drag across other colors in the spreadsheet. Release your finger to select a color.
A custom color: Tap Color, swipe left to the color wheel, then drag the slider around the wheel. To change color brightness, drag the top horizontal slider. To change color saturation, drag the bottom slider. To revert to the previous color, tap the circle in the center of the color wheel (the left half shows the previous color).
A recently created custom color or a recently selected color from elsewhere in the spreadsheet: Tap Color, swipe left to the color wheel, then tap a color well to the right of .
A two-color gradient fill: Tap Gradient, tap Start Color or End Color, then tap a color or swipe left to use the color wheel. To switch the gradient direction, tap Flip Color. To change the gradient angle, drag the Angle slider. To apply the gradient based on the length of the shape or text box (not the size of the selected text), select the checkbox next to Apply Gradient to Entire Object. The gradient changes when the size of the object or text box changes.
Fill text with an image
Select the text you want to change—or tap a text box, shape, or table cell—then tap .
Tap Cell (for text in a table) or Text (for text in a shape or text box) to show the text controls.
Tap Text Color or Color, then tap Image.
Tap Change Image, then do one of the following:
Tap a photo.
Tap Take Photo.
Tap “Insert from” to choose an image from iCloud Drive.
If the image doesn’t look the way you expected or you want to change how the image fills the object, tap an option:
Original Size: Places the image inside the text without altering the image’s original dimensions. To resize the image, drag the Scale slider.
Stretch: Resizes the image to fit the text’s dimensions, which might change the image’s proportions.
Tile: Repeats the image inside the text. To resize the image, drag the Scale slider.
Scale to Fill: Makes the image larger or smaller to leave no space in the text.
Scale to Fit: Resizes the image to fit the text’s dimensions, but maintains the image’s proportions. Some text might not be filled.
To create a tinted image, turn on Color Overlay and tap Fill to select a tint color.
To make the tint more or less transparent, drag the Opacity slider.
Add or remove a text outline
Select the text you want to change—or tap a text box, shape, or table cell—then tap .
Tap Cell (for text in a table) or Text (for text in a shape or text box) to show the text controls.
Tap in the Font section of the controls.
Turn Outline on or off.
If you add an outline, use the controls to change its style, color, and width.
Tip: You can remove the text color to emphasize the outline. Tap , tap Text, then tap Text Color. Tap Preset, swipe to the black and white options, and then tap No Fill.
Add a background color to text
You can add color behind any selection of text—individual characters, words, or entire paragraphs—to create a highlight effect.
Select the text you want to change—or tap a text box or shape—then tap .
If you don’t see text controls, tap Text.
Tap in the Font section of the controls.
Swipe up, then tap Text Background.
Swipe left or right to see colors (tap Preset or Color to change the options), then tap one.
For more information about color options, see “Change the color of text,” above.
To remove the background color from selected text, tap Preset, then swipe to the black and white options and tap No Fill.
Add a background color to a paragraph
Use this method when you want the color behind the text to extend from margin to margin as a block of color.
Note: If the paragraph is in a table cell, you need to add the background color to the table cell. See Change the border and background of table cells.
Tap the paragraph or select multiple paragraphs where you want the background color to appear.
Tap in the toolbar, tap Text at the top of the menu, then tap Paragraph Borders & Background (you may need to scroll down).
Tap Background, then choose one of the following:
A color designed to go with the theme: Tap Preset, swipe left or right to see all the choices, then tap a color.
Any color: Tap Color, then tap a color. To preview different background colors, touch and hold a color, then drag across the grid. A color label appears for each previewed color to help you reproduce an exact match. Release your finger to select a color.
A color from elsewhere on the spreadsheet: Tap Color, swipe left, then tap . Tap any color on the sheet. To preview colors, touch and hold a color on the sheet, then drag across other colors on the sheet. Release your finger to select a color.
Remove a background color from behind paragraphs
If the color you want to remove extends from margin to margin, you can use this method to remove it.
Select the paragraphs you want to remove the background color from.
Tap , then tap Paragraph Borders & Background in the Text Menu.
Tap Background, tap Preset, then tap No Fill (you may need to swipe left first).
When you open a spreadsheet that uses fonts that you don’t have, a missing font notification appears briefly at the top of the sheet. If you want to replace the missing font, tap the notification, tap Resolve Font Warnings, then tap Resolve. If the notification is no longer visible, tap , tap Show Document Warnings, tap Resolve Font Warnings, then tap Resolve.
To install a new or missing font on your iPad, you can download it from the App Store. See the iPad User Guide for instructions.
You can keep text formatting consistent in a spreadsheet by using text styles.