Create a table

Try it!

When you want to present information in a table, choose the right one for the job: a quick table built with shapes for simple one with that won’t change, or an embedded Excel worksheet when you need a dynamic information source.

Build a table with shapes

1. Select More Shapes > Business > Charts and Graphs > Charting Shapes.

2. Drag the Grid shape onto the drawing page.

3. Select the number of rows and columns you want in your table, and select OK.

4. Drag the sizing handles on the Grid shape to make the rows and columns larger or smaller.

5. Drag the Row Header or Column Header shape onto the drawing page, and position it next to a row or column.

6. Double-click a cell, enter data, and then select a blank area of the drawing page to finish.

Embed an Excel worksheet

1. Select Insert > Object.

2. Select Microsoft Excel Worksheet, and select OK.

3. Double-click a cell and enter data.

4. To adjust column widths, select the columns and then select Home > Format > AutoFit Column Width.

Format an embedded Excel table

1. Select Insert > Table.

2. Enter the range of cells in the table area and select OK.

3. Select Page Layout > Themes, and choose a table style.

Remove empty columns and rows from an embedded Excel table

1. Double-click the table.

2. Drag the resize handles to hide empty rows and columns.

Want more?

Add a table to a drawing