+ Reply to Thread
Results 1 to 3 of 3

Inserting Excel table into PowerPoint

Hybrid View

  1. #1
    Registered User
    Join Date
    05-31-2004
    MS-Off Ver
    Office 2007, Office 2003
    Posts
    35

    Inserting Excel table into PowerPoint

    Hi

    I have a page in Excel that is a calendar with text and coloured box entries. I have tried everything to insert this Excel page into PowerPoint however whatever I try, I cannot make the full page appear in PowerPoint. I have tried linking, cutting and pasting, opening a new table in PowerPoint, altering the handles in PowerPoint, resizing the font etc. For whatever reason, I cannot alter the Excel page to fit into one landscape PowerPoint page. In Excel the page is fine to print as a single sheet or can be viewed on one page if shrunk.

    Appreciate someone's help!

    Thanks

    danison

  2. #2
    Forum Contributor
    Join Date
    08-23-2004
    Posts
    210
    I think your problem is with PowerPoint, rather than with Excel.
    But see if the passage below helps:

    Quote from PowerPoint's Help:
    Copy Microsoft Excel worksheet cells into a presentation

    1 On the worksheet, select the range you want to copy, and then click Copy .
    2 Switch to the presentation, and then click where you want to insert the cells.
    3 On the Edit menu in PowerPoint, click Paste Special.
    4 To paste the cells so you can size and position them as you would a picture, click Microsoft Excel 8.0 Worksheet Object.

    To paste the cells as text separated by tabs, click Unformatted Text.

    5 To keep only the current result of a formula, click Paste.

    To make sure the result is updated if the original data changes in Microsoft Excel, click Paste link.

    Notes

    · The Paste link option is available only if you select the Microsoft Excel 8.0 Worksheet Object format.
    · If you select the Microsoft Excel 8.0 Worksheet Object and Paste options, only the visible data in the cells appears in the embedded picture. If data is cut off, double-click the object, and then resize the columns to show all data. If you paste a worksheet object with the Paste link option, the linked picture reflects the column width and other formatting of the original cells as they currently appear in the source workbook.

    · If you select the Paste link option, the result is pasted as a linked object. If you select the Microsoft Excel 8.0 Worksheet Object and Paste options, the result is pasted as an embedded object. For more information about linked and embedded objects, click .
    · If you linked the cells and might later want to include additional rows or columns of data, first name the range in Microsoft Excel. Then copy the range and paste the cells as a linked object in PowerPoint. If you add more data to the range in Microsoft Excel, you can redefine the range name to include the additional cells. The new data is added to the linked object in PowerPoint the next time you update the link. Unquote:

  3. #3
    Registered User
    Join Date
    05-31-2004
    MS-Off Ver
    Office 2007, Office 2003
    Posts
    35

    Will give it a go..

    Thanks Rod, will give it a shot and let you know how it works!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1