 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / General PowerPoint Questions / October 2007How to convert excel spreadsheet rows to Slides
I have an excel spreadsheet of many rows and many columns - each one text for the most part. I want to create a ppt of this spreadsheet so that each row is a new slide. For a simple example, I have a spreadsheet with three columns (fields): Owner, Pet type, name of pet And then 2 rows of data: Joe, Dog, Spot Jane, Frog, Kermit other than manually creating the slides, is there a way I can create ppt slides so that there is one slide for Joe showing he owns a dog named spot, then another slide for Jane showing she owns a frog named kermit? (sorry - my actual business xls is much more professional, but also very wordy, so figured I would use simple example and play data). I can get the data to be forms in access - which is in a way the look and feel I am looking for - but can't get it to ppt slides. Thanks for your help. You didn't identify your Office version. The options may differ slightly for Office 2007. The following applies to Office 2003. There are several ways to get spreadsheet data into powerpoint. Each method has its strengths and weaknesses. - You can select and copy a range of cols and cells from Excel and then use powepoint's "paste" or "paste special" functions to put the selected cells onto a slide. "paste" or "paste special" are on the edit menu. Paste functions are also on the right-click shortcut menu. 1) paste the selected cells onto the slide as a powerpoint table. 2) Paste the selection as a MS Excel Worksheet object. Pastes the contents of the Clipboard into your presentation so that you can activate it using Microsoft Office Excel 2003. 3) Paste selection as html format: Pastes the contents of the Clipboard into your presentation as HTML Format. 4) Paste selection as picture format: (win meta file, enhanced metafile, bitmap, device independent bitmap) Pastes the contents of the Clipboard into your presentation as a <selected format> picture. 5) Paste link to selection as Excel Worksheet object. This method, inserts a picture of the selected cells into your presentation. It also creates a link shortcut to the source file so that changes to the source file will be reflected in your presentation. 6) Paste link to selection as Attached Hyperlink: Pastes the contents of the Clipboard into your presentation as a Hyperlink. 7) Insert an Excel Worksheet object onto the slide. Go to excel select a cell range, return to ppt, double click on the worksheet object and paste the range into the spreadsheet. This method is similar to cut and pasting between worksheets within excel. This method does not leave hidden data on hidden worksheets.  SignatureTom Conrad > I have an excel spreadsheet of many rows and many columns - each one text for > the most part. I want to create a ppt of this spreadsheet so that each row is [quoted text clipped - 16 lines] > > Thanks for your help. THanks for the response, but this isn't quite what I am trying to do. This just pastes the cells to look like xls row on each slide...I want to fill in the fields from the excel spreadsheet in a specified designed format...moire like what an access form, where you each field can be in a different part, color coded, etc, but becuase I have over 50 rows, was wondering how to create a template or macro to do this automatically instead of manually. FYI - I do have office 2003 > You didn't identify your Office version. The options may differ slightly for > Office 2007. [quoted text clipped - 57 lines] > > > > Thanks for your help. Look into PPTMerge. http://www.pptools.com/ SignatureEcho [MS PPT MVP] http://www.echosvoice.com What's new in PPT 2007? http://www.echosvoice.com/2007.htm Fixing PowerPoint Annoyances http://www.oreilly.com/catalog/powerpointannoy/ > THanks for the response, but this isn't quite what I am trying to do. This > just pastes the cells to look like xls row on each slide...I want to fill [quoted text clipped - 87 lines] >> > >> > Thanks for your help. Stacy, In case you missed Echo's reply to your reply to Tom's reply to your ... Whew! .. question PPT Merge is our add-in that does exactly what you're looking for (and quite a bit more). There's a fully functional free demo here: http://www.pptools.com/merge/ Give it a test and if you need any help getting it set up, email me at steve at-sign pptools dot com > I have an excel spreadsheet of many rows and many columns - each one text for > the most part. I want to create a ppt of this spreadsheet so that each row is [quoted text clipped - 16 lines] > > Thanks for your help. ----------------------------------------- Steve Rindsberg, PPT MVP PPT FAQ: www.pptfaq.com PPTools: www.pptools.com ================================================ This is so awesome! I was just searching for something that did this! Thanks! > Stacy, > [quoted text clipped - 37 lines] > PPTools: www.pptools.com > ================================================ > This is so awesome! I was just searching for something that did this! Thanks! Music to my ears. <g> Glad you like it! > > Stacy, > > [quoted text clipped - 37 lines] > > PPTools: www.pptools.com > > ================================================ ----------------------------------------- Steve Rindsberg, PPT MVP PPT FAQ: www.pptfaq.com PPTools: www.pptools.com ================================================ |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.