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
- Select More Shapes > Business > Charts and Graphs > Charting Shapes.
- Drag the Grid shape onto the drawing page.
- Select the number of rows and columns you want in your table, and select OK.
- Drag the sizing handles on the Grid shape to make the rows and columns larger or smaller.
- Drag the Row Header or Column Header shape onto the drawing page, and position it next to a row or column.
- Double-click a cell, enter data, and then select a blank area of the drawing page to finish.
Embed an Excel worksheet
- Select Insert > Object.
- Select Microsoft Excel Worksheet, and select OK.
- Double-click a cell and enter data.
- To adjust column widths, select the columns and then select Home > Format > AutoFit Column Width.
Format an embedded Excel table
- Select Insert > Table.
- Enter the range of cells in the table area and select OK.
- Select Page Layout > Themes, and choose a table style.
Remove empty columns and rows from an embedded Excel table
- Double-click the table.
- Drag the resize handles to hide empty rows and columns.