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.
Source: Microsoft