Objective 3.1 Insert and format tables
- 3.1.1 Create and import tables
- 3.1.2 Change table structure
- 3.1.3 Format tables
3.1 Contents
3.1.1 Create and import tables
Create and import tables When you want to present a lot of data in an organized and easy-to-read format, a table is often your best choice. You can create a table in one of the following ways:
If you want to use data from an Excel worksheet in a PowerPoint table, you can do any of the following:
To enter information in a table, you simply click a cell and then enter text. You can also move the cursor from cell to cell by pressing the Tab key. |
Tables display information in rows and columns |
To create a new table
Or
|
Some content placeholders include table options |
To insert a table from Word
- In the source document, click the table border to select it.
- Copy the table to the Microsoft Office Clipboard.
- Switch to PowerPoint, display the destination slide, and then paste the table from the Clipboard.
To paste Excel data as a table
- In the Excel worksheet, select and copy the data you want to display in the PowerPoint table.
- Switch to PowerPoint, display the destination slide, and then paste the data.
- To change the default paste option (Use Destination Styles), click the Paste Options button, and then click the option you want.
To embed an editable worksheet
|
|
Or
|
To hide unused columns and rows
- Double-click the worksheet object.
- When the worksheet opens in an Excel window within PowerPoint, size the frame around the worksheet so that it is just big enough to contain the active part of the worksheet.
- Click outside the frame to return to PowerPoint.
To resize the worksheet
- Point to any handle (the sets of dots) around the worksheet object, and then drag to enlarge or shrink it.
To modify an embedded worksheet
- Double-click the worksheet object.
- Use Excel techniques to edit and format the embedded object.
To link to a worksheet
- Follow the instructions for embedding a worksheet, but in the Insert Object dialog box, select the Link check box before clicking OK.
To update a linked worksheet
- Double-click the table on the slide to open the linked worksheet in Excel, make the changes, and then save them.
- If you update the linked worksheet in Excel and want to synchronize the table on the slide, right-click the table on the slide, and then click Update Link.
To update table data
- Use normal editing techniques to change the data in a cell.
To delete a table
- On the Layout tool tab, in the Rows & Columns group, click the Delete button, and then click Delete Table.