Often, while creating a complex model or dashboard, you may want to include additional training material in the workbook. So let us learn how to embed flash movies, youtube videos etc. in to Excel workbooks.
To Embed Flash Movies, Youtube Videos in to Excel, follow these steps.
Step 1: Go to Developer Tab
Go to Developer tab in excel ribbon and locate insert button. From here, select the insert button and click on “More controls”. See this illustration.
PS: If you do not have developer tab, learn how to enable it.
Step 2: Insert a Shockwave Flash Object
From the list of controls shown, select the one that says “Shockwave flash object”. Once you do that, your mouse pointer changes to + sign. Draw a rectangle to insert a flash object on to your Excel workbook.
When you finish drawing, you will see a crossed-out rectangle, like this:
Step 3: Set properties of the Flash Object
Right click on the rectangle now and select properties. Locate the property Movie and set it to the path of your Youtube video along with ?fs=1&hl=en_US in the end, like this.
Step 4: Exit Design Mode
Close the properties window. Now, from Developer tab, click on the big button that says “Design Mode” to exit design mode.
Instantly you will see the youtube video loading in the embedded flash object.
Click play to watch it.
Bonus tips:
- You can use design mode to resize the youtube video size.
- You can embed other flash movies, flash games etc. using the same technique. The path of movie can be a URL or a local computer path.
- You can also embed other types of objects like Quick Time Movies, Windows Media Player movies etc.
Gotchas You should be aware of:
- Do not save in compatibility mode. While saving the workbook, select XLSX format if you are running Excel 2007 or above. If you save the workbook in compatible mode, you may not see the videos working when you re-open it.
Download this Excel Workbook that has a Youtube Video that Explains how to Embed Youtube Videos in to Excel
That is right. I have made a youtube video explaining how to embed youtube videos in to excel. Then I embedded that youtube video in to an excel workbook 😀
Click here to download the excel workbook.
More Excel Howtos:
- Using Word-art in Excel
- How to make a birthday reminder in Excel
- How to insert currency codes & other special symbols in to Excel
- … More Excel Howtos & Excel Video Tutorials
PS: Special thanks to Manzoor for sharing this technique on our forums.
11 Responses to “Fix Incorrect Percentages with this Paste-Special Trick”
I've just taught yesterday to a colleague of mine how to convert amounts in local currency into another by pasting special the ROE.
great thing to know !!!
Chandoo - this is such a great trick and helps save time. If you don't use this shortcut, you have to take can create a formula where =(ref cell /100), copy that all the way down, covert it to a percentage and then copy/paste values to the original column. This does it all much faster. Nice job!
I was just asking peers yesterday if anyone know if an easy way to do this, I've been editing each cell and adding a % manually vs setting the cell to Percentage for months and just finally reached my wits end. What perfect timing! Thanks, great tip!
If it's just appearance you care about, another alternative is to use this custom number format:
0"%"
By adding the percent sign in quotes, it gets treated as text and won't do what you warned about here: "You can not just format the cells to % format either, excel shows 23 as 2300% then."
Dear Jon S. You are the reason I love the internet. 3 year old comments making my life easier.
Thank you.
Here is a quicker protocol.
Enter 10000% into the extra cell, copy this cell, select the range you need to convert to percentages, and use paste special > divide. Since the Paste > All option is selected, it not only divides by 10000% (i.e. 100), it also applies the % format to the cells being pasted on.
@Martin: That is another very good use of Divide / Multiply operations.
@Tony, @Jody: Thank you 🙂
@Jon S: Good one...
@Jon... now why didnt I think of that.. Excellent
Thank You so much. it is really helped me.
Big help...Thanks
Thanks. That really saved me a lot of time!
Is Show Formulas is turned on in the Formula Ribbon, it will stay in decimal form until that is turned off. Drove me batty for an hour until I just figured it out.