Few weeks back I have invited all of you to share your excel keyboard shortcuts in a open thread. More than 50 people commented on that post and shared a hundred excel keyboard shortcuts with us. There were so many wonderful keyboard shortcuts and tricks buried in the comments section of that post. During the weekend, I spent sometime to collect all these beautiful shortcuts and arranged them neatly so that you can easily learn them. Here is the complete list of Excel Keyboard Shortcuts.
Special thanks to all the commenters on the original post. Without you I couldn’t have learned these shortcuts.
Here is the complete list of excel keyboard shortcuts.
- Shortcuts for Selection
- Shortcuts for Editing
- Shortcuts for Navigation
- Shortcuts for Formatting
- Shortcuts for Formulas
- Shortcuts for Excel Options
- Shortcuts for Auto Complete
- Shortcuts for Everything Else
Note: I have *ed some of the most important shortcuts. These are very useful and extremely time saving ones. You may want to remember a few to boost your productivity.
| Select the whole column
Selection
|
| Select the whole row
Selection
|
| Select table
Selection
|
| Save
Selection
|
| Select visible cells only
Selection
|
| Select entire region
Selection
|
| Select range from start cell to far left
Selection
|
| Select range from start cell to end in direction of arrow
Selection
|
| Select a continuous range of data (e.g. pivot), no matter where your cursor is.
Selection
|
| Select blank cells
Selection
|
| Select all cells with comments
Selection
|
| Select all cells that are directly or indirectly referred to by formulas in the selection
Selection
|
| Select all cells with formulas that refer directly or indirectly to the active cell
Selection
|
| Selects all the way to a1 from cursor position
Selection
|
| Select cells in the direction of arrow
Selection
|
| Previous sheet
Navigation
|
| Next sheet
Navigation
|
| Launch GO TO Dialog (from here you can select special or jump to a cell or range)
Navigation
|
| Go to top left (will go to top left of freezed pane if set)
Navigation
|
| Go to last non-blank cell
Navigation
|
| Go to previous sheet
Navigation
|
| Go to next sheet
Navigation
|
| Print
Navigation
|
| Toggle between workbooks in a given session of excel.
Navigation
|
| Change the type of cell reference from relative to absolute or semi-absolute
Formulas
|
| Repeat whatever you did last
Formulas
|
| Debug portions of a formula (select and press)
Formulas
|
| Sum range
Formulas
|
| Enter array formula
Formulas
|
| Select array formula range
Formulas
|
| Display range names (can be used when typing formulas)
Formulas
|
| Evaluate formulas. (its easy to remember when working with some “tuf” formulas!)
Formulas
|
| Copy a formula from above cell and edit
Formulas
|
| Display the formula palette after you type a valid function name in a formula
Formulas
|
| Alternate between displaying cell values and displaying cell formulas
Formulas
|
| Calculate formulas
Formulas
|
| Select all precedent cells
Formulas
|
| Select all dependent cells
Formulas
|
| Format Selection (cells, objects, charts)
Formatting
|
| Bold a cell’s content
Formatting
|
| Format Painter – Paste formats from selection
Formatting
|
| Format as number with 2 dp
Formatting
|
| Format as local currency
Formatting
|
| Format as percentage with 0 dp
Formatting
|
| Hide row
Formatting
|
| Hide column
Formatting
|
| Unhide row
Formatting
|
| Unhide column
Formatting
|
| Display the style command format menu
Formatting
|
| Sets/removes strikeout in current cell
Formatting
|
| Show/hide the top bar when you have a group
Formatting
|
| Single border around selected cells
Formatting
|
| Sort
Formatting
|
| Insert hyperlink
Formatting
|
| Freeze panes
Formatting
|
| Remove grid lines or (alt+t)ov(alt+g)[enter]
Formatting
|
| To wrap lines
Formatting
|
| Save as
Excel Options
|
| Collapse the ribbon (press again to expand)
Excel Options
|
| Opens print preview
Excel Options
|
| Maximize the current window
Excel Options
|
| Activate next window
Excel Options
|
| Activate previous window
Excel Options
|
| Close an excel workbook
Excel Options
|
| Split screens
Excel Options
|
| Create a pivot table in new sheet (of course after selecting the range)
Everything Else
|
| Create a pivot table in the same sheet.
Everything Else
|
| Show visual basic editor
Everything Else
|
| Macro dialog
Everything Else
|
| Apply/remove filter
Everything Else
|
| Keep filter on columns, but show all rows
Everything Else
|
| Insert pivot table
Everything Else
|
| Turn filter on or off
Everything Else
|
| Paste values only
Editing
|
| Edit a cell, place cursor at the end
Editing
|
| Show in-cell drop down with previously entered values
Editing
|
| Fills down value from cell above
Editing
|
| Add a comment or Edit comment
Editing
|
| Insert new sheet
Editing
|
| Insert row
Editing
|
| Delete row
Editing
|
| Copy
Editing
|
| Paste
Editing
|
| Cut
Editing
|
| Undo
Editing
|
| Get a line break inside the cell
Editing
|
| Clear all contents
Editing
|
| Copy
Editing
|
| Paste
Editing
|
| Make chart/pivot chart
Editing
|
| Edit a cell in Apple Macs
Editing
|
| Copy the value from the cell above the active cell into the cell or the formula bar
Editing
|
| Copies whatever is in the cell to the left of it.
Editing
|
| Delete box (cell, row, column)
Editing
|
| Insert box (cell, row, column)
Editing
|
| Enter current date
Auto Complete
|
| Enter current time
Auto Complete
|
Thanks to the contributors
Here is a list of people who contributed these shortcuts.
Vipul, Dau, Stružák, Paul, Eliavs, Pavel S, Fabrice, Noone, Clarity, Jp, Pascal, Jair, Yoav, Nimesh, Bill, Patricia, Mike, Iesmatauw, Chrisham, Harvey, Pranav, Rohit Choudhary, Rohit1409, Rickard, Sachin, Gerald Higgins, Ericlind, Zzz, Felipe, Sridhar, Halva, Catherine, Lavkesh Bhatia, Rick Rothstein, Vishal Haria, Ak, Daniel Ferry, Mehdi Raza.
Thank you 🙂
Share your shortcuts
I know this post is unusally lengthy. But I wanted the list to be as comprehensive as possible. If you know some shortcuts that are not listed, please share them using comments. 🙂
27 Responses to “How to Embed Youtube videos in to Excel Workbooks?”
Thank you!!
The trick is to get that URL for video. Some videos have this feature disabled... hmm...
very cool. how did you record what you do on Excel? it didn't seem like you was using a camcorders.
This is a great tip. Is it possible to insert a PDF on an excel worksheet? I usually receive quotations in pdf format, and would like to show the quote on a worksheet, rather than using hyperlinks. Any and all help would be greatly appreciated.
Your instructions didn't work for me, ether in Excel 2010 or 2007, and I tried several times, following the instructions very carefully and to the letter.
What I found out is that, for some odd reason, copying the YouTube URL then adding the ?fs=1&hl=en_US to the end would not work at all for me.
But if I went to the Embed code in YouTube and copied value parameter (minus quotes) and pasted it into the movie property, the movie would play. The Embed code value parameter includes the link and the extra bit you included at the end. No need to copy that as an extra step.
Best feedback on here. Worked like a charm after removing extra YT code. Thanks..
@Gregory,
Thanks your instructions.
I have carefully followed the Instructions mentioned by you and still i am unable to do embed the video in excel.
Please help and your immedate reply will be higly appreceiable.
Regards
Sonu Monga
A Chartered Accountant
If you are using excel 2010 or higher. then there is nothing like Shockwave flash player.
In that case you have to use windows media player.
There is a control naming Windows Media Player in that list.
Insert that contol and then open properties and insert link in URL.
It will work.
@Gregory,
Thanks your instructions.
I have carefully followed the Instructions mentioned by you and still i am unable to do embed the video in excel.
Please help and your immedate reply will be higly appreceiable.
Regards
Sonu Monga
Chartered Accountant
It wouldn't play because you need to indicate the exact location of flash file....by 'Embedding' the file, you get the the exact URL, so it can be played....some videos can't be 'embedded' that's why it won't work....
My developer tools does not list a control for "Shockwave flash object". Where/How do I find it?
Hi Chandoo,
why don't use OCX Window media player ???
you can play your own local video or music
just indicate exact location (Full path or URL)
i.e :
C:\Users\Public\Music\Sample Music\Kalimba.mp3
C:\Users\Public\Videos\Sample Videos\Wildlife.wmv
with macro and userform :
Sub PlayMedia()
On Error Resume Next
UserForm1.WindowsMediaPlayer1.URL = ThisWorkbook.Path & "/" & ActiveCell.Value
' ----- or
' ----- UserForm1.WindowsMediaPlayer1.URL = Exact location
End Sub
Very cool. I also could not get the instructions to work, but was able to use Gregory's suggestion about the embed code. Thanks for posting!
Thanks Chandoo. This is very cool. I was able to make it work using the embed code copying from http: up to _US as you indicated. This is a great way to provide additional training or message as you package your deliverable.
[...] Trying to become a bit flashier with your dashboards? Maybe you’re just looking to include additional material. Take a look at this quick tool to embed YouTube videos in excel workbooks. [...]
Hi Chandoo,
Excellent tip. Very useful.
Is there anyway to link the path in the properties to a cell value so that the user can select the video from a drop down and then have the video play?
Thanks Myles.... to link the path to a cell, I guess you need to use macros..
nothing happend in Embed Youtube videos in to Excel Workbooks, it shows only white blank screen.
Hi Chandoo, How Do I put more than one URL in movie field?
Hi Chandoo,
very good tip.
But how do I start the embeded video in an xlsm file once the tab is selected or through VBA programming?
Appreciating your answer
Steve
Query:
I have created 4 sheets excel file, but when i print this file to PDF it generates two sheets one PDF and two Sheets one PDF … can i know the setting which i had to change. because i want all 4 sheets in one PDF
while Printing i did setting as "Print Entire Workbook"
Awaiting for your reply.
Help!! THis works great, but I'm trying to use VBA to change the URL, which I can do. The problem I am having is getting it to play via VBA.
The object has both .play and .playing = true properties, but neither will actually play the video after updating the .movie url. The correct video appears within the object, but I can't get it to play from VBA... which I really need it to do.. Thoughts?
Hello
Go to Developerr tab and select more control then find windows media player just click it.
after that you have to right click on the embeded object and select properties there you need to add your video file path.(dont forget to include extension like .avi, .mov etc.) in URL field. Then Press Alt+11 and deselct design mode. Once you close the module your video start playing.....
For the life of me, I cannot get this to work. I have followed Chandoos instructions to the letter and also tried using the embed code as Gregory suggested, all I get is a blank white box where the video should be. Is there any other reason that this might not work? Flash version perhaps? Quite frustrating.
Hi I was wondering if was a way after adding a video if one could save to HTML format and it would work?
Hi Chandoo,
This is very helpful, however, is there a way to auto-play the embedded youtube video as soon as somebody opens the excel file? Can you share the macro for the same?
Hi,
Very cool, how is it possible to start automatically the video when the excel sheet is open?
I would like to start the video when i open the worksheet :).
Best regards.
Hello
When trying this method, I got Flash-embedded videos are no longer supported. Is there a solution for this problem?