Most Useful Excel Keyboard Shortcuts
Тәжірибелік нұсқаулар және стиль
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
Пікірлер: 323
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
@ruthihejirika9467
2 жыл бұрын
What about for Mac?
@mieczyslawm7093
2 жыл бұрын
How about fuq you. Your Control + T is on my keyboard Control + L.
@denised.5300
2 жыл бұрын
Thank you professor I'm trying to get a new job
@yvng4697
Жыл бұрын
@@denised.5300 did u got the new job?
@mariatovar1657
Жыл бұрын
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
@sassouusasoo3607
5 жыл бұрын
Charan MG Thank u my good man !!
@foodparadise5792
4 жыл бұрын
You are the hero of the century.
@anjumshaikh3270
4 жыл бұрын
Thank you sir.
@jayrichzhanra4988
4 жыл бұрын
Thank you very much! Saved my time. Next vid.
@MihaelaV68
4 жыл бұрын
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.
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.
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♡
Your videos are amazing! You are a great teacher... Thank you!
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 ❤️ .
How many of you are watching this having lied about your ability to use excel and are now panicking?
@jinteljanemoreno2794
Жыл бұрын
Hahahahah
@shehlanasimmirza_1980
Жыл бұрын
Lmaooo
@maiwasekumwenda4186
6 ай бұрын
😅😂😂😂😂
WHat a bright & shining light, thank you for this!!!
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!!
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
It's a big help. Thank you so much!
Very helpful for excel users. Many thanks for uploading such an important tutorial.
You're really giving me confidence to further enhance my knowledge on excel
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! 😀
@Mustaqbal230
3 жыл бұрын
Thankz
@great9391
2 жыл бұрын
He's good anyway
@mahmoudranjbarniavol3197
2 жыл бұрын
Thinks
you're a great teacher. this was very helpful. thanks
Very good, easy to understand & said @ a speed you could listen to all day.
Your videos are changing my life. Thanks!!
super informative video. Clear, concise and very well presented.
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
Thank you for this amazing tutorial!
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. These basics are helpful for beginners
I hav perfected my excel skills now.Thanks for making them easy to understand.
very useful tips , it saves lot of time and easy to work in spread sheets
thank you so much for this. Very useful
Great information. Thanks for sharing
I like the control T function. It makes the work look very professional.
WOW. I'll be practicing these shortcut keys at work from now on. Thanks again! (y)
Highly appreciate. Nice way of explaining and elaborating 👍👍👍
thanks for information and your support
I am very pleased with this very clear video. Thank you
That was so helpful. Love your content 🌸
Awesome Video. Just Liked it. The commands are really very cool the way it was explained. Keep up the great work.
I found some very useful shortcuts, thank you for sharing!
Short cuts are fun to work with. Makes work easier. Thanks
Very helpful. Thank you!
Fabulous, just what I needed for my new job!!
Thank you so much, you just helped me in my last minute studies!
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 !
Incredibly helpful,thank you
Thank you very much! Keep up the good work!
Amazing video learnt a lot
I have learned so much thank u 🙏
This is going to be so helpful, thanks.
Your videos have been very helpful!
Your content have helped learn MS Excel at a high speed, Big up!
thanks for your sharing
Very helpful, thanks mate
Very useful tutorial for memorising the shortcuts.
Amazing excel tutorial thanks alot
i benefited from this..and keep on bringing us more knowledge like this..i enjoy it
Best excel tutorial!! Your explanation is very clear, to the point and very helpful. Thank you.
@wasimprince4353
5 жыл бұрын
Hi you need to learn excel more i will teach you
Thank you for your videos 👍
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.
Awesome, thank you!
Very useful to work more efficiently in Excel! Thank you for this great video 😊
Thanks! It would be a great help. Gonna use it on my exams in IT Application Tools in Business
Thank you so much for this
Very informative video Thank you for sharing
I'm learning Excel right now. Thanks for the info!
Wow, thanks man! I learn a new trick in EVERY video!
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.
Wow Thanks this wonderful Video
I'm a follower of your videos, they are all interesting. thanks for sharing your knowledge.
really helpful, thank you so very much
It was really helpful ...please keep posting more
This was much needed!!!!👍🏼
Awesome Tips ~ Thanks Much !
You taught very well. Your teaching is very nice.
thank you for sharing this video ,it's really helpful ,,God bless !
Ctrl + T saves so much time. Thanks
thanku...excellent presentation sir...!!!
so handy I am heading back to the work force and these videos are fantastic thank you
You are so helpful i found Excel very interesting after watching your video keep the good work ❤
New to Excel great short cuts
It was very helpful thanks.
Very useful thank you
Very useful, thank you sir👍
I really love your videos, they are really beneficial.... Kudos to you :)
These are amazing! Thank you so so so much! You are GREAT at this!
@wasimprince4353
5 жыл бұрын
Yes very useful
Thanks for your this lesson.
thanks for your effort
So useful, thank you ^^
Useful, Thanks
Nice video Thank you
You are an excellent teacher
Appreciate you for this video buddy
Thank you for videos they help me a lot in my job
Thanks man, it help a lot
Control T - that could have save me so much time, thank you.
Thank you!
Good video, thanks
I learned a lot from here thankyou ❤️
So great love your video
VERY USEFUL
Thanks Just what I was looking for
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.
@afzalansari1137
2 жыл бұрын
P0 P
Thank you for the video, good content, my question is, about the column numbers, # 1 is located in the head line, it would be possible to put # 1 one place down? and keep the head line empty?, thank you