Use table styles in Numbers on Mac
The easiest way to change the look of a table is to apply a different table style to it, which you can do at any time.
If you customize the look of a table and want to apply the same formatting to other tables, you can create a new table style. The new style is saved along with the styles that come with the template.
Numbers determines how to create the table style based on the most frequently used style for some attributes, such as cell fill and border style. For example, if your table uses many different fonts, the new table style adopts the font that appears the most often in your table.
Apply a different style to a table
Go to the Numbers app on your Mac.
Open a spreadsheet, then click the table.
In the Format sidebar, click the Table tab.
Select a different style from the options at the top of the sidebar.
Click on the left and on the right if there are more available styles.
If you made changes to your table’s look before applying a different table style, the table retains those changes after you apply the new style. To override those changes when you apply a new style, Control-click the new table style, then choose Clear Overrides and Apply Style.
Revert changes to a table style
If you made changes to a table’s look—for example, by changing the border of table cells—you can revert these changes by reapplying the original table style.
Go to the Numbers app on your Mac.
Open a spreadsheet, then click the table.
In the Format sidebar, click the Table tab.
Control-click the table style you want to reapply and choose “Clear Overrides and Apply Style.”
Save a table as a new style
If you made changes to a table’s look and want to save these changes, you can create a new table style that you can use again later. You can’t add new table styles in a spreadsheet shared with others.
Go to the Numbers app on your Mac.
Open a spreadsheet, then click the table with the formatting you want to save as a new style.
In the Format sidebar, click the Table tab.
Click the arrow to the right of the table styles to navigate to the last group of styles, then click to add your style.
The new table style is added to the table styles at the top of the sidebar. You can drag styles to organize them however you like.
Create a table style that reflects the colors in an image
You can create a new table style that reflects the colors of a particular image. This can be helpful when you want to make a visual connection between the data in the table and the subject of the image.
The new style includes a table title, a header row and column, and a footer row—all of which match colors from the image. When you apply the new style to a selected table, it imparts the same colors to these features in the table (if the table has them).
Go to the Numbers app on your Mac.
Open a spreadsheet, then click any table in your spreadsheet, or click in the toolbar and add a table.
In the Format sidebar, click the Table tab.
Navigate to an image anywhere on your computer.
To browse your photos, click in the toolbar.
Drag the image to the table styles in the sidebar.
Alternatively, you can Control-click a table style in the sidebar, choose Create Style from Image from the shortcut menu, then browse for an image.
A new table style with colors from the image is added to the table styles at the top of the sidebar; it doesn’t replace the style you Control-clicked to open the pop-up menu.
To apply the new style to the selected table, click the style in the sidebar—it isn’t applied automatically when you create it.
Redefine a table style
To quickly change the look of all tables that have the same style applied, redefine the style, then apply it to all the tables.
Go to the Numbers app on your Mac.
Open a spreadsheet, select a table whose style you want to change, then modify its appearance so it looks the way you want.
Select the table you just modified (if it’s no longer selected).
In the Format sidebar, click the Table tab.
At the top of the sidebar, Control-click the style you want to redefine, then choose Redefine Style from Selection.
Choose one of the following:
Update all objects that use the current style: This changes the look of all tables that currently use this style.
Don’t update objects, and disconnect them from the style: This changes only the selected table.
Click OK.
The style is updated in the sidebar, and all tables that use the style are updated.
Organize table styles
You can rearrange the table styles in the sidebar for easier access to the ones that you use most often.
Go to the Numbers app on your Mac.
Open a spreadsheet, click any table in your spreadsheet, or click in the toolbar and add a table.
In the Format sidebar, click the Table tab.
At the top of the sidebar, click and hold the style you want to move until it flashes.
Drag the style to a new location.
If you have multiple style panes and want to move a style from one pane to another, drag it over the left or right arrow to open the other pane, then drag it to where you want it.
Delete a table style
Go to the Numbers app on your Mac.
Open a spreadsheet, then click any table.
In the Format sidebar, click the Table tab.
Control-click the style you want to delete, then choose Delete Style.