How to convert excel spreadsheet rows to Slides
Stacy
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.
Tom Conrad
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.
--
Tom Conrad
Stacy
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
Echo S
--
Echo [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/
"Stacy" <St...@discussions.microsoft.com> wrote in message
news:31BFAA5E-2CF9-4F21...@microsoft.com...
Steve Rindsberg
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:
Give it a test and if you need any help getting it set up, email me at steve
at-sign pptools dot com
-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================
Hudspeth@discussions.microsoft.com Ann Hudspeth
"Steve Rindsberg" wrote:
> Stacy,
>
> In case you missed Echo's reply to your reply to Tom's reply to your ... Whew!
> ... question
Steve Rindsberg
> This is so awesome! I was just searching for something that did this! Thanks!
Music to my ears. <g> Glad you like it!