The same table in two styles. The first is a standard PowerPoint style. The second is our preferred styling.
The same table in two styles. The first is a standard PowerPoint style. The second is our preferred styling.

How to format better tables

Tables in PowerPoint are incredibly powerful because they keep content automatically aligned, which our brains appreciate. But the default tables usually overdo the formatting, distracting from the actual content. Which makes your readers have to work harder to process the ‘so-what’ of the information.

The simplest way to declutter tables is to use only half of the borders. The alignment of the text means that we see the rows and columns, even with no borders at all. So treat the borders as a way of grouping the information. And keep them subtle.

Here’s our step-by-step guide to a cleaner, more effective table. Plus ready-to-use examples that you can download and paste into your decks. And suggestions for streamlining the steps.

Steps for a better table

Note: we haven’t included recommendations for font size, as that depends on your content. However, we do recommend using a consistent size throughout your document, and it probably needs to be a couple of sizes smaller than your default text size.

1. Clear out the default formatting

Before and after Step 1

Depending on your template, your default table format could have all sorts of table borders, fill and font formatting. You could either go through and remove each of those in turn, but we recommend applying one of the built-in table styles.

Go to the Table Design tab, and in the Table Styles dropdown you can choose either:

No Style, No Grid - this clears out everything but is harder to use in practice because you can’t see where the rows and columns are while you are formatting it.
No Style, Table Grid - this clears everything but leaves a simple black cell border for the whole table. This option is easier because you can easily see where the rows and columns are. You just have to remove any unwanted borders in Step 3.

2. Format header row

Before and after Step 2

This is our go-to format for the column headers:

Make the text bold. Optionally, add a font colour using one of your accent colours (as long as it has enough contrast against the background). Or use all-caps.
Add a border below using 1½pt or 2¼pt thickness and in one of the key accent colours.
Turn the top border off. The quickest way to do this is to select the top border button to turn the border on and then click it again to turn it off.

3. Add row borders

Before and after Step 3

Our standard format for rows:

Thickness ¾pt
Colour: mid-grey. Either the middle of the 5 shades under white (Darker 25%) or a suitable neutral pallet colour.
Turn all column borders off - left, right and inside. 

You should now be left with just horizontal gridlines

4. Adjust the margins

Before and after Step 4

A default table will have fairly wide margins that are often too wide for detailed content. Plus, with no vertical borders, you can take the text up to the edge so that it aligns with the horizontal border edges, giving your tables a more aligned look, and making better use of screen estate.

So we recommend a zero left cell margin but a right cell margin that is big enough to make sure the text from adjacent cells doesn’t run into each other. We also put a small top and bottom margin to help separate the individual rows.

Select the whole table. Table Layout > Cell Margins > Custom Margins
Set the custom margins as follows - Left: 0, Right: 0.4cm, Top: 0.1cm and Bottom: 0.1cm. (For US users, in inches those are: 0”, 0.2”, 0.05” and 0.05”.) 
Screenshot of cell margins dialog box, in both metric and US units

Optionally, if you want to you can also:

Select the last column and set the right margin to zero (since there is nothing for it to run into).
Select the header row and set the top margin to zero (if it is important that the text top-aligns with anything else on your slide).

Bonus tip

You can also adjust cell margins in the Format Shape pane, under the Text Box section. The advantage of this is that you can see the changes as you make them, no need to use the Preview button.

5. Text alignment

Before and after Step 5

Different types of content work best with different text alignments. So go through each column and change the alignment if appropriate:

Left-align: General text: sentences, short phrases, full names
Centre-align: Short fields: dates, Y/N, RAG status, initials, short labels/tags, simple numbers (no more than two digits)
Right-align: long numbers, and any financial figures

For rows, it’s generally easier for readers to top-align all the content.

6. Format the bottom row (if relevant)

Before and after Step 6

If the bottom row contains totals or summary information, you need to make it clear that it is different from the rows above. We suggest the following:

Borders: a top border of the same thickness as the header row. You could use the same colour, or you could use a different accent colour or just black or dark grey. You could also add an identical bottom border.
Text: make the text bold, and potentially use a different colour from the header row text. We usually keep the font size the same.

What if my data is in columns?

Before and after for column-based data

Essentially, just transpose the rules above. A couple of notes:

The first column will contain the header labels. So use the same formatting as above but consider right-aligning the text in that column.
You will probably want to format the first row because these are likely to be option headings. A simple bold and/or all-caps, plus maybe a colour will suffice. But try to so something slightly different from the first column formatting.
The cell margins should be something like this: Left: 0.1cm, Right: 0.1cm, Top: 0 and Bottom: 0.4cm. (Or 0.05”, 0.05”, 0” and 0.2”.) Depending on your content you may need to adjust that bottom margin.
Alignment is not as applicable, so generally you can default to left-alignment for all columns.

That feels like a lot of clicking…

That is quite a few steps, but there are some ways of making this easier. Especially if you use a lot of tables:

  1. Talk to us about building you a template with custom table styles, or just adding them to your existing template.
  2. Download and re-use the example tables below.
  3. Install our custom ribbon. It has all of the border, margin and alignment buttons directly on the ribbon, which significantly reduces the number of clicks you need each time.
  4. Install the free BrightSlide add-in. As well as countless other functions, there is a table format painter that lets you copy the format from one table and paste it to all your others.

Our free download has two tables already set up. You can copy and paste these into your decks, and they will pick up your template formatting: fonts and colours.

Do you want to learn how to improve the quality of your documents so that they reflect the quality of your thinking? Talk to us to discuss how we can help.
Get in contact
Published:
November 10, 2023

JUST launched: Online Self-STUDY LEARNING

We've created our first online course: How to create a great plan-on-a-page. It covers:

What to put in a plan so it is clear and helpful to your audience
How to make it look high quality – so that they trust it
Plus tips and tricks for using PowerPoint features to draw it
A graphic of a plan overlaid onto a maze

How to create a great plan-on-a-page

View the course

And to accompany the course we have built a new Plan-on-a-page kit:

114 ready-built timelines to paste into your deck, each with custom drawing guides and pre-sized task shapes.
A 'sticker book' of useful shapes to help you quickly build clear, flexible and impressive plans that fit seamlessly into your stakeholder update decks
Works in both inches and centimetres
Picks up your template styles automatically
A series of images of the pages available within the plan kit

How to create a great plan-on-a-page

View the KIT

They are available separately, but you’ll save if you buy them together.

Use LAUNCH25 for 25% off both products. Valid until end 2024.
Use LAUNCH25 for 25% off both products. Valid until end 2024.