sodcalculator

10 Tech How-To

Format Tables in Numbers on iPhone & iPad

Guide 10-52345 · Updated · Step by step

This guide shows you how to format tables in the Numbers app on your iPhone or iPad, covering everything from changing cell colors and text styles to adjusting row heights, column widths, and table borders. You’ll learn the exact taps and menus needed to make your spreadsheets look clean and professional, whether you’re tracking a budget, planning an event, or organizing data for work or school. No prior experience with Numbers is required, but you should have the app installed and a spreadsheet open to follow along.

What You’ll Need

  • An iPhone or iPad with the Numbers app installed (it’s free from the App Store if you don’t have it).
  • A spreadsheet already created in Numbers, or you can create a new blank one to practice on.
  • iOS or iPadOS 16 or later for the most current menu layouts; older versions have similar options but may be in slightly different spots.

Step-by-Step

  1. Open your spreadsheet. Tap the Numbers icon, then tap the file you want to edit. If you’re starting fresh, tap the plus button (+) and choose “Blank” to create a new sheet.
  2. Select the table or cells you want to format. Tap once on the table to select it. To format specific cells, tap and drag across them; you’ll see blue handles appear around your selection. To select an entire row or column, tap the gray bar with the row number or column letter.
  3. Open the formatting menu. With your table or cells selected, tap the paintbrush icon (Format) in the top-right corner of the screen. This opens the Format panel on the right side (on iPad) or as a bottom sheet (on iPhone).
  4. Change cell background colors. In the Format panel, tap “Cell” at the top. You’ll see a “Fill” section; tap the color swatch to choose a background color for the selected cells. You can also tap the color wheel icon for a custom color, or use the eyedropper to match a color from elsewhere on your screen.
  5. Format text inside cells. Still in the “Cell” tab, look for the “Font” section. Here you can change the font family, size, bold/italic/underline, and text color. Tap the “T” with a color bar underneath to change text color. Use the alignment buttons (left, center, right, justify) to position text within cells.
  6. Adjust number formats. If your cells contain numbers, tap “Number” at the top of the Format panel. Choose from options like Currency, Percentage, Date, or Time. You can set decimal places, thousands separators, and negative number style (e.g., red with parentheses).
  7. Add or remove borders. In the Format panel, tap “Table” at the top. Under “Table Borders,” you can choose a border style for the whole table or just the selected cells. Tap the border icon and select which edges to apply it to (top, bottom, left, right, or all). You can also set the border color and thickness.
  8. Change row heights and column widths. Tap any row number or column letter to select it, then drag the edge of that row or column to resize. For precise sizing, select the row/column, tap the Format brush, then tap “Row” or “Column” and enter exact values in the “Height” or “Width” fields.
  9. Style header rows and columns. With the table selected, tap “Table” in the Format panel. Toggle on “Header Rows” or “Header Columns” to turn the top row or left column into headers. These get a distinct style automatically. You can also tap “Header” in the “Cell” section to change their fill color, text style, or add a title.
  10. Merge or split cells. Select two or more adjacent cells, tap the Format brush, then tap “Cell” and choose “Merge Cells.” To split a merged cell back, select it and tap “Unmerge Cells.” This is great for creating title banners or grouping labels.
  11. Use preset table styles. Tap the table, then in the Format panel tap “Table” and scroll through the style thumbnails at the top. These apply coordinated colors, borders, and alternating row shading instantly. You can still customize individual cells after applying a style.
  12. Hide or show gridlines. In the “Table” section of the Format panel, toggle “Gridlines” on or off. Turning them off makes the table look cleaner, while on helps distinguish cells. You can also choose to show only horizontal or only vertical lines.
  13. Freeze header rows or columns. To keep headers visible while scrolling, tap the table, then tap the Format brush, tap “Table,” and enable “Freeze Header Rows” or “Freeze Header Columns.” This is essential for long lists.
  14. Copy formatting with the paintbrush. Select a cell with the formatting you like, tap it, then tap “Copy Style” from the pop-up menu. Select the target cells, tap again, and choose “Paste Style.” This copies only the formatting, not the data.

Common Mistakes

  • Formatting the wrong selection: Tapping a cell once selects it, but tapping the table border selects the whole table. If your changes aren’t applying where you expect, check the blue handles to see what’s actually selected.
  • Forgetting to tap “Done” or “Apply”: On iPhone, some formatting changes require tapping a checkmark or “Done” in the top corner to confirm. If you swipe away without confirming, changes may revert.
  • Mixing up text and number formats: If you set a cell to “Text” format, numbers become text and can’t be used in calculations. Always use “Number” or “Currency” for values you’ll sum or multiply.
  • Overusing colors: Applying many bright fills can make a table hard to read. Use color sparingly for headers, totals, or conditional highlights.
  • Dragging instead of resizing: When you drag a row or column edge, you might accidentally move the entire column. Make sure you’re grabbing the exact boundary line, not the middle of the header.

Tips

  • Use alternating row colors: In the “Table” tab, toggle “Alternating Rows” to add subtle shading. This makes long tables much easier to scan.
  • Create a custom table style: After formatting a table exactly how you like, tap the table, go to “Table” in the Format panel, swipe left on the style thumbnails, and tap “+” to save it as a custom style for reuse.
  • Format cells based on values: Tap a cell, then in the Format panel tap “Conditional Highlighting.” You can set rules like “greater than 100” to turn green or “less than 0” to turn red. This is powerful for budgets and tracking.
  • Use the undo button: If you make a formatting mistake, shake your iPhone/iPad or tap the undo arrow (curved left) at the top to revert the last change. You can undo multiple steps.
  • Zoom in for precision: Pinch to zoom the sheet before adjusting borders or cell sizes. This makes it easier to tap exactly the right handle.

Troubleshooting

  • Format options are grayed out: This usually means you have a chart or image selected, not a table. Tap a cell in the table first, then open the Format brush.
  • Changes apply to the whole table instead of selected cells: Ensure you’ve actually selected cells by dragging across them, not just tapped once. If you see a single blue border around one cell, only that cell is selected.
  • Row height won’t change: If the row contains wrapped text, the height may auto-fit. Turn off “Wrap Text” in the Cell tab, or manually set a height in the Row tab after selecting the row.
  • Borders don’t show: Check that the border color isn’t white (invisible on white background) and that the border style is set to a solid line, not “None.” Also, borders may not appear if the table style has “No Borders” applied; switch to a different style or manually add them.
  • Number format shows “###” or wrong values: The column is too narrow to display the full number. Widen the column or reduce decimal places. Also, ensure the cell is formatted as “Number,” not “Text.”
  • Merged cells can’t be unmerged: If you merged a range and then added data to it, unmerging will keep the data in the top-left cell and delete the rest. Copy any important data elsewhere before unmerging.

Frequently Asked Questions

Can I format a table in Numbers on iPhone the same way as on iPad? Yes, the options are identical, but on iPhone the Format panel appears as a slide-up sheet that may require scrolling to see all sections. The steps are the same.

How do I change the font of an entire column at once? Tap the column letter to select the whole column, then open the Format brush and change the font in the “Cell” tab. This applies to all cells in that column.

Is there a way to copy formatting from one table to another? Yes, select a cell with the desired formatting, tap “Copy Style,” then select the target table or cells and tap “Paste Style.” This works across different tables in the same document.

Why does my table lose formatting when I export to Excel? Numbers uses styles that Excel may not fully support. Basic formatting like colors, fonts, and borders usually transfers, but complex conditional highlighting or custom table styles may not. Check the exported file and adjust in Excel if needed.

Can I set a default format for all new tables? Yes, create a table, format it as you like, then tap the table, go to “Table” in the Format panel, swipe left on the style thumbnails, and tap “+” to save it. Then, when you add a new table, swipe through styles and pick yours.

How do I remove all formatting from a table? Select the table, tap the Format brush, then tap “Table” and choose the first style thumbnail (usually a plain white table with black borders). This resets most formatting, though you may still need to manually clear cell fills by setting them to “No Fill.”

Related

General steps for current mainstream versions; menus can differ by device and version. See the disclaimer or report an error.

More in this bed

The whole Tech How-To bed →