Most Useful Excel Keyboard Shortcuts
Vložit
- čas přidán 8. 04. 2018
- My entire playlist of Excel tutorials: bit.ly/tech4excel Learn what I consider to be the most useful Excel keyboard shortcuts. Some of the shortcuts included are: Ctrl+S, Ctrl+T, Ctrl+Home, Ctrl+D, and more. Download the example Excel file here: bit.ly/usefulexcelshortcuts
***Consider supporting Technology for Teachers and Students on Patreon***: / technologyforteachersa...
See below links to the CDs and bands mentioned in the video:
The Killers - Wonderful Wonderful: amzn.to/2G7AKlF
Brandon Flowers - The Desired Effect: amzn.to/2G6gBMG
Blaqk Audio -Material: amzn.to/2DUOfo1
Covenant - The Blinding Dark: amzn.to/2n1J0uH
Depeche Mode - Spirit: amzn.to/2E0BUio
Erasure - World Be Gone: amzn.to/2G46U1t
Future Islands - The Far Field: amzn.to/2DC7yVx
Hurts - Desire: amzn.to/2DX6Dww
OMD - The Punishment of Luxury: amzn.to/2DpzVmA
The Frozen Autumn - The Fellow Traveller: amzn.to/2DXfA9f
The Jellyrox - Bang and Whimper: amzn.to/2Drnvue
Ulver - The Assassination of Julius Caesar: amzn.to/2DoFLEB - Jak na to + styl
0:16 Ctrl+S = Save your file
0:30 Ctrl+P = Print option
0:46 Ctrl+T = Turn selected cells into table
3:05 Ctrl+Home = Upper left cell
3:30 Ctrl+End = Lower right cell
3:49 Ctrl+Down Arrow = Bottom of the data
5:08 Ctrl+Page Up = Go to previous sheet
5:25 Ctrl+Page Down = Go to next sheet
5:48 Ctrl+D = Autofill
7:29 Ctrl+A = Select all cells in the table
7:58 Ctrl+C = Copy
8:03 Ctrl+V = Paste
8:22 Ctrl+Space Bar = Selects entire column
8:41 Shift+Space Bar = Selects entire row
What about for Mac?
How about fuq you. Your Control + T is on my keyboard Control + L.
Thank you professor I'm trying to get a new job
@@denised.5300 did u got the new job?
3edxxxxxxxxxxxxxxxx
Ctrl + home = top left cell
Ctrl + end = lower right cell
Ctrl + down button = selected column lower cell
Ctrl + t = selected data converted to TABLE
Ctrl + space bar = selects the entire column cells
Ctrl + page down = switch to next sheet
Ctrl+ page up = switch to previous sheet
Ctrl + d = tap one the cell drag down to add that data press ctrl+d
Ctrl + a = selects all
Ctrl + v = paste
Shift + space bar = selects the entire row
Charan MG Thank u my good man !!
You are the hero of the century.
Thank you sir.
Thank you very much! Saved my time. Next vid.
Charan MG thank you
Thanks so much for this invaluable information! I'm feeling more confident about my upcoming job in which excel will frequently be used. You're absolutely correct in stressing the importance of using the keyboard vs. the mouse in terms of efficiency.
Looove it♡ av learned a loooot from u about excel.. I downloaded all ur excel videos before i go to a job interview and thanks to God i had the priority to have the job.. Thanks♡
Nice work , that was useful . I may write that on a paper 📝 and give it to anyone who works on excel . Thanks for the video and I'm waiting for the next one ❤️ .
I’ve recently commented on another of the excel tutorials but I must tell you...these are gold!! I just learned two things I wasn’t searching for but spent an hour on in a paid online course!
Thank you thank you. I have vowed to master excel and your videos have made that seem less insane! 😀
Thankz
He's good anyway
Thinks
Your videos are amazing! You are a great teacher... Thank you!
WHat a bright & shining light, thank you for this!!!
You're really giving me confidence to further enhance my knowledge on excel
Thanks so much for sharing that... the shortcut for wrapping text was a savior!
Thank you for this useful information. It helped a lot to enhance my skills in excel
Very helpful for excel users. Many thanks for uploading such an important tutorial.
How many of you are watching this having lied about your ability to use excel and are now panicking?
Hahahahah
Lmaooo
😅😂😂😂😂
I hav perfected my excel skills now.Thanks for making them easy to understand.
Very good, easy to understand & said @ a speed you could listen to all day.
I learned a few that are new to me thats all the matters love learning new things to Excel - this application is never ending lol thanks for the video !
you're a great teacher. this was very helpful. thanks
Your videos are changing my life. Thanks!!
Thank you so much, you just helped me in my last minute studies!
I like the control T function. It makes the work look very professional.
You are a God send! You've boosted my confidence and you are the only teacher i ever understood in regards to computer knowledge! I love you! Bless you!💛👌🙌😘💯
Thank you for the knowledge, YOUR ARE THE BOSS!, The content is really good, not a lot of others but straight to the core of the case, well explained and really nice performed
It's a big help. Thank you so much!
Thanks! It would be a great help. Gonna use it on my exams in IT Application Tools in Business
I found some very useful shortcuts, thank you for sharing!
very useful tips , it saves lot of time and easy to work in spread sheets
I am very pleased with this very clear video. Thank you
i benefited from this..and keep on bringing us more knowledge like this..i enjoy it
Awesome Video. Just Liked it. The commands are really very cool the way it was explained. Keep up the great work.
Very useful tutorial for memorising the shortcuts.
Loved! Thank you so much. I appreciate you taking your time with explaining the steps, and revisiting previous material as a refresher. Your videos are my fav!!
NOW YOU'RE TALKING, These I can use. I never knew where to find these KEYSTOKES and so I don't use any keystrokes but now I will. THNX PROFESSOR.
This is going to be so helpful, thanks.
Fabulous, just what I needed for my new job!!
super informative video. Clear, concise and very well presented.
Thank you for this amazing tutorial!
Best excel tutorial!! Your explanation is very clear, to the point and very helpful. Thank you.
Hi you need to learn excel more i will teach you
Thank you. These basics are helpful for beginners
Your videos have been very helpful!
Your content have helped learn MS Excel at a high speed, Big up!
Wow, thanks man! I learn a new trick in EVERY video!
WOW. I'll be practicing these shortcut keys at work from now on. Thanks again! (y)
Great information. Thanks for sharing
Thank you very much! Keep up the good work!
That was so helpful. Love your content 🌸
so handy I am heading back to the work force and these videos are fantastic thank you
Short cuts are fun to work with. Makes work easier. Thanks
I just wanted to say thank you for taking the time out and explaining things clearly. Where can I get a PDF file of your Excel shortcuts.
Highly appreciate. Nice way of explaining and elaborating 👍👍👍
Control T - that could have save me so much time, thank you.
thanku...excellent presentation sir...!!!
Awesome, thank you!
I'm learning Excel right now. Thanks for the info!
I've been working in Excel for over three years now, and I am unreasonably excited to hear about Ctrl + Space and Shift + Space, even though highlighting the full row typically works for me.
Very helpful. Thank you!
thank you for sharing this video ,it's really helpful ,,God bless !
I really love your videos, they are really beneficial.... Kudos to you :)
New to Excel great short cuts
Ctrl + T saves so much time. Thanks
thank you so much for this. Very useful
So useful, thank you ^^
This was much needed!!!!👍🏼
You are an excellent teacher
You are so helpful i found Excel very interesting after watching your video keep the good work ❤
Bro, you are saving my life *daily.*
really helpful, thank you so very much
These are amazing! Thank you so so so much! You are GREAT at this!
Yes very useful
You taught very well. Your teaching is very nice.
Appreciate you for this video buddy
It was very helpful thanks.
I have learned so much thank u 🙏
I learned a lot from here thankyou ❤️
Awesome Tips ~ Thanks Much !
I'm a follower of your videos, they are all interesting. thanks for sharing your knowledge.
Incredibly helpful,thank you
Thanks for your very useful and pedagogical videos. I've learned quite a lot of stuff through them. One question: for me Ctrl + Space doesn't select the column, as you claim, but the entire table area. What could be the reason for that? Also, is there a key or combination of keys to cancel a specific selection? If I do Shift + Space it selects the row where I'm at, but is there a one-click way to de-select the row instead of clicking outside the selection area? I've tried repeating the same shortcut (Shift + Space) and Escape key but nothing works other than clicking outside the selection area. Thanks in advance and keep up your great work.
P0
P
Very helpful, thanks mate
Thank you for videos they help me a lot in my job
Very useful to work more efficiently in Excel! Thank you for this great video 😊
thanks for information and your support
Amazing video learnt a lot
Very useful, thank you sir👍
Thanks man, it help a lot
So great love your video
Amazing excel tutorial thanks alot
thanks for your effort
It was really helpful ...please keep posting more
Thanks for your this lesson.
All I already knew but it was very useful for me :)
Good video, thanks
Thank you for your videos 👍
Very useful thank you
Very useful !
To the point thank you
Its amazing tutorial.. Hope to see more shortcut in excel videos.. First time here
thank you so much I learned a lot
whoaa so useful, thank you so much........
Thank you so much😁👍🏾
Thank you so much for this
i enjoyed the lessons, that was wonderful, thank u