If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Importing List of Words from Excel to PP
Hi!
I am a teacher and have a list in Excel of 225 "sight" words. I would like to import these words into a power point presentation with one word per slide so the kids can have electronic flash cards. Is there a way to do this without retyping each word? Thanks. |
#2
|
|||
|
|||
Kitty,
Save your Excel file as a text file, with each word on an independent line. Open PowerPoint and do File-- Open. Change the type to All Outlines and navigate to where you saved the file. Each word should end up on its own slide in the title placeholder. Format the presentation as you want. (You can even add pictures to the slides to show what the words mean.) How's that for sneaky fixes? Quick, easy, and no hassle! -- Kathryn Jacobs, Microsoft MVP PowerPoint and OneNote Author of Kathy Jacobs on PowerPoint - Available now from Holy Macro! Books Get PowerPoint answers at http://www.powerpointanswers.com Featured Presenter at PPT 2004 - http://www.pptlive.com Need to learn about advanced PowerPoint Animations? Check out: http://www.eclecticacademy.com/newclasses.htm#pptanim I believe life is meant to be lived. But: if we live without making a difference, it makes no difference that we lived "Kitty" wrote in message ... Hi! I am a teacher and have a list in Excel of 225 "sight" words. I would like to import these words into a power point presentation with one word per slide so the kids can have electronic flash cards. Is there a way to do this without retyping each word? Thanks. |
#3
|
|||
|
|||
In article , Kathy J wrote:
Kitty, Save your Excel file as a text file, with each word on an independent line. Open PowerPoint and do File-- Open. Change the type to All Outlines and navigate to where you saved the file. Each word should end up on its own slide in the title placeholder. Format the presentation as you want. (You can even add pictures to the slides to show what the words mean.) How's that for sneaky fixes? Quick, easy, and no hassle! One wrinkle ... might need to bust the text file into two parts. I think PPT may limit you to adding 100 slides this way. Once you have both converted to PPT, Insert, Slides, From File should merge the two. -- Steve Rindsberg, PPT MVP PPT FAQ: www.pptfaq.com PPTools: www.pptools.com ================================================ Featured Presenter, PowerPoint Live 2004 October 10-13, San Diego, CA www.PowerPointLive.com ================================================ |
#4
|
|||
|
|||
Steve,
I don't think the file needs to be split - I've just tested it with over 400 copy and pasted words in a list and it worked just fine. Want me to send you the text file so that you can test it? -- Kathryn Jacobs, Microsoft MVP PowerPoint and OneNote Author of Kathy Jacobs on PowerPoint - Available now from Holy Macro! Books Get PowerPoint answers at http://www.powerpointanswers.com Featured Presenter at PPT 2004 - http://www.pptlive.com Need to learn about advanced PowerPoint Animations? Check out: http://www.eclecticacademy.com/newclasses.htm#pptanim I believe life is meant to be lived. But: if we live without making a difference, it makes no difference that we lived "Steve Rindsberg" wrote in message ... In article , Kathy J wrote: Kitty, Save your Excel file as a text file, with each word on an independent line. Open PowerPoint and do File-- Open. Change the type to All Outlines and navigate to where you saved the file. Each word should end up on its own slide in the title placeholder. Format the presentation as you want. (You can even add pictures to the slides to show what the words mean.) How's that for sneaky fixes? Quick, easy, and no hassle! One wrinkle ... might need to bust the text file into two parts. I think PPT may limit you to adding 100 slides this way. Once you have both converted to PPT, Insert, Slides, From File should merge the two. -- Steve Rindsberg, PPT MVP PPT FAQ: www.pptfaq.com PPTools: www.pptools.com ================================================ Featured Presenter, PowerPoint Live 2004 October 10-13, San Diego, CA www.PowerPointLive.com ================================================ |
#5
|
|||
|
|||
Kathy, thank you for allowing me to post the technique he
http://www.indezine.com/notes/2004/0...-in-excel.html -- Geetesh Bajaj, Microsoft PowerPoint MVP PowerPoint Notes: http://www.indezine.com/notes Free Templates: http://www.indezine.com/powerpoint/t...templates.html Technical Specialist, PowerPoint Live http://www.powerpointlive.com "Kathy J" wrote in message ... Steve, I don't think the file needs to be split - I've just tested it with over 400 copy and pasted words in a list and it worked just fine. Want me to send you the text file so that you can test it? -- Kathryn Jacobs, Microsoft MVP PowerPoint and OneNote Author of Kathy Jacobs on PowerPoint - Available now from Holy Macro! Books Get PowerPoint answers at http://www.powerpointanswers.com Featured Presenter at PPT 2004 - http://www.pptlive.com Need to learn about advanced PowerPoint Animations? Check out: http://www.eclecticacademy.com/newclasses.htm#pptanim I believe life is meant to be lived. But: if we live without making a difference, it makes no difference that we lived "Steve Rindsberg" wrote in message ... In article , Kathy J wrote: Kitty, Save your Excel file as a text file, with each word on an independent line. Open PowerPoint and do File-- Open. Change the type to All Outlines and navigate to where you saved the file. Each word should end up on its own slide in the title placeholder. Format the presentation as you want. (You can even add pictures to the slides to show what the words mean.) How's that for sneaky fixes? Quick, easy, and no hassle! One wrinkle ... might need to bust the text file into two parts. I think PPT may limit you to adding 100 slides this way. Once you have both converted to PPT, Insert, Slides, From File should merge the two. -- Steve Rindsberg, PPT MVP PPT FAQ: www.pptfaq.com PPTools: www.pptools.com ================================================ Featured Presenter, PowerPoint Live 2004 October 10-13, San Diego, CA www.PowerPointLive.com ================================================ |
#6
|
|||
|
|||
In article , Kathy J wrote:
Steve, I don't think the file needs to be split - I've just tested it with over 400 copy and pasted words in a list and it worked just fine. Want me to send you the text file so that you can test it? It may be version-dependent. If you say it works, it works. In which version? g -- Steve Rindsberg, PPT MVP PPT FAQ: www.pptfaq.com PPTools: www.pptools.com ================================================ Featured Presenter, PowerPoint Live 2004 October 10-13, San Diego, CA www.PowerPointLive.com ================================================ |
#7
|
|||
|
|||
2003 - You want me to check it on the other ones? I'll do it later
today.... -- Kathryn Jacobs, Microsoft MVP PowerPoint and OneNote Author of Kathy Jacobs on PowerPoint - Available now from Holy Macro! Books Get PowerPoint answers at http://www.powerpointanswers.com Featured Presenter at PPT 2004 - http://www.pptlive.com Need to learn about advanced PowerPoint Animations? Check out: http://www.eclecticacademy.com/newclasses.htm#pptanim I believe life is meant to be lived. But: if we live without making a difference, it makes no difference that we lived "Steve Rindsberg" wrote in message ... In article , Kathy J wrote: Steve, I don't think the file needs to be split - I've just tested it with over 400 copy and pasted words in a list and it worked just fine. Want me to send you the text file so that you can test it? It may be version-dependent. If you say it works, it works. In which version? g -- Steve Rindsberg, PPT MVP PPT FAQ: www.pptfaq.com PPTools: www.pptools.com ================================================ Featured Presenter, PowerPoint Live 2004 October 10-13, San Diego, CA www.PowerPointLive.com ================================================ |
#8
|
|||
|
|||
Steve, I tried 400 words in PowerPoint 2000 and 2003 and it worked.
However, I have not tried 400 titles with different indents - also no variations in form from slide to slide were used since all slides only included a title. Also, I don't have PowerPoint 97 installed to test - anyone with PowerPoint 97 installed? -- Geetesh Bajaj, Microsoft PowerPoint MVP PowerPoint Notes: http://www.indezine.com/notes Free Templates: http://www.indezine.com/powerpoint/t...templates.html Technical Specialist, PowerPoint Live http://www.powerpointlive.com "Steve Rindsberg" wrote in message ... In article , Kathy J wrote: Steve, I don't think the file needs to be split - I've just tested it with over 400 copy and pasted words in a list and it worked just fine. Want me to send you the text file so that you can test it? It may be version-dependent. If you say it works, it works. In which version? g -- Steve Rindsberg, PPT MVP PPT FAQ: www.pptfaq.com PPTools: www.pptools.com ================================================ Featured Presenter, PowerPoint Live 2004 October 10-13, San Diego, CA www.PowerPointLive.com ================================================ |
#9
|
|||
|
|||
Thanks for checking, Geetesh/Kathy.
Firing up a box with 97 installed right now. Hang on ... Nope. I must be remembering that limit from an earlier version of PPT than 97. 97 blipped a 400 line text file into slides in nothing flat. -- Steve Rindsberg, PPT MVP PPT FAQ: www.pptfaq.com PPTools: www.pptools.com ================================================ Featured Presenter, PowerPoint Live 2004 October 10-13, San Diego, CA www.PowerPointLive.com ================================================ |
#10
|
|||
|
|||
Thanks for checking. I didn't think it would fail on the earlier versions,
since it is based on an ancient tip of yours, but wasn't positive. -- Kathryn Jacobs, Microsoft MVP PowerPoint and OneNote Author of Kathy Jacobs on PowerPoint - Available now from Holy Macro! Books Get PowerPoint answers at http://www.powerpointanswers.com Featured Presenter at PPT 2004 - http://www.pptlive.com Need to learn about advanced PowerPoint Animations? Check out: http://www.eclecticacademy.com/newclasses.htm#pptanim I believe life is meant to be lived. But: if we live without making a difference, it makes no difference that we lived "Steve Rindsberg" wrote in message ... Thanks for checking, Geetesh/Kathy. Firing up a box with 97 installed right now. Hang on ... Nope. I must be remembering that limit from an earlier version of PPT than 97. 97 blipped a 400 line text file into slides in nothing flat. -- Steve Rindsberg, PPT MVP PPT FAQ: www.pptfaq.com PPTools: www.pptools.com ================================================ Featured Presenter, PowerPoint Live 2004 October 10-13, San Diego, CA www.PowerPointLive.com ================================================ |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Importing Contacts From Excel to a Distribution List | SJT | General Discussion | 0 | August 19th, 2004 06:31 PM |
synchronizing form and list box | Deb Smith | Using Forms | 8 | June 21st, 2004 08:15 PM |
Coverting Lotus 123 files to use with excel | Muffin1947 | General Discussion | 6 | June 20th, 2004 10:18 AM |
Excel Data List - why does it delete the data below the list? | ryanlillywhite | General Discussion | 1 | June 14th, 2004 06:56 PM |
Autofilter/filter in Excel only shows 1000 rows in dropdown list. | Sven Stian | Worksheet Functions | 2 | March 25th, 2004 08:07 AM |