1-866-245-5224 sales@keystonelearning.com

PowerPoint 2003: Inserting a Microsoft Excel Table

PowerPoint 2003: Inserting a Microsoft Excel Table

Microsoft Excel is a powerful spreadsheet program that comes with Microsoft Office. And, by inserting an Excel table into PowerPoint, you get access to all kinds of Excel features including number formatting, Sort & Filter and calculations.

So, if you’re looking to insert a table into your presentation that contains totals or other calculations, inserting an Excel table as opposed to a PowerPoint table is definitely the way to go.

Inserting a Microsoft Excel Table

     
  1. Choose Insert: Object from the Menu bar
     

Figure 3. Insert Object Dialog Box

    2.       Choose the Microsoft Excel Worksheet

    3.       Click OK



Resizing a Microsoft Excel Table

     
  1. Double-click your table to activate it
     
  2.  
  3. Position your mouse on a selection handle
     
  4.  
  5. Click and drag to the desired size
     

Figure 4. Excel Worksheet on a PowerPoint Slide

Editing a Microsoft Excel Table

There are several ways you can edit a table including inserting rows and columns and formatting a table.

Inserting a Row into an Excel Table
     
  1. Double-click your table to activate it
     
  2.  
  3. Right-click inside your table in a cell below where your new row should appear
     
  4.  
  5. Choose the Insert… from the Shortcut menu
     

Figure 5. Excel Insert Dialog Box

    4.       Choose Entire row and then click OK



Deleting a Row into an Excel Table
     
  1. Double-click your table to activate it
     
  2.  
  3. Right-click inside your table in a cell below where your new row should appear
     
  4.  
  5.  Choose the Delete… from the Shortcut menu
     

Figure 6. Excel Delete Dialog Box

    5.       Choose Entire row and then click OK

Inserting a Column into an Excel Table
     
  1. Double-click your table to activate it
     
  2.  
  3. Right-click inside your table in a cell below where your new row should appear
     
  4.  
  5. Choose the Insert… from the Shortcut menu
     
  6.  
  7. Choose Entire column and then click OK
     
Deleting a Column into an Excel Table
     
  1. Double-click your table to activate it
     
  2.  
  3. Right-click inside your table in a cell below where your new row should appear
     
  4.  
  5. Choose Delete… from the Shortcut menu
     
  6.  
  7. Choose Entire column and then click OK
     
Sorting a Microsoft Excel Table
     
  1. Double-click your table to activate it
     
  2.  
  3. Click inside the column you want to sort your table by
     
  4.  
  5. Click Sort A to Z or Sort Z to A on the Standard toolbar
     
Deleting a Microsoft Excel Table
     
  1. Click the outside of your Excel Table to select the table
     
  2.  
  3. Press [Delete]