Most Useful Excel Keyboard Shortcuts
Вставка
- Опубліковано 8 кві 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 - Навчання та стиль
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 ❤️ .
Your videos are amazing! You are a great teacher... Thank you!
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
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.
You're really giving me confidence to further enhance my knowledge on excel
WHat a bright & shining light, thank you for this!!!
How many of you are watching this having lied about your ability to use excel and are now panicking?
Hahahahah
Lmaooo
😅😂😂😂😂
Thank you for this useful information. It helped a lot to enhance my skills in excel
Thanks so much for sharing that... the shortcut for wrapping text was a savior!
Very helpful for excel users. Many thanks for uploading such an important tutorial.
Your videos are changing my life. Thanks!!
It's a big help. Thank you so much!
you're a great teacher. this was very helpful. thanks
I hav perfected my excel skills now.Thanks for making them easy to understand.
I like the control T function. It makes the work look very professional.
very useful tips , it saves lot of time and easy to work in spread sheets
Thanks! It would be a great help. Gonna use it on my exams in IT Application Tools in Business
Thank you for this amazing tutorial!
super informative video. Clear, concise and very well presented.
Thank you so much, you just helped me in my last minute studies!
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
thanku...excellent presentation sir...!!!
Very good, easy to understand & said @ a speed you could listen to all day.
VERY USEFUL
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
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 !
I found some very useful shortcuts, thank you for sharing!
I am very pleased with this very clear video. Thank you
Fabulous, just what I needed for my new job!!
Very useful tutorial for memorising the shortcuts.
thank you so much for this. Very useful
This is going to be so helpful, thanks.
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
Highly appreciate. Nice way of explaining and elaborating 👍👍👍
Great information. Thanks for sharing
Your content have helped learn MS Excel at a high speed, Big up!
i benefited from this..and keep on bringing us more knowledge like this..i enjoy it
Your videos have been very helpful!
New to Excel great short cuts
thanks for information and your support
Awesome Video. Just Liked it. The commands are really very cool the way it was explained. Keep up the great work.
Awesome, thank you!
I'm learning Excel right now. Thanks for the info!
I have learned so much thank u 🙏
thank you for sharing this video ,it's really helpful ,,God bless !
Short cuts are fun to work with. Makes work easier. Thanks
WOW. I'll be practicing these shortcut keys at work from now on. Thanks again! (y)
Incredibly helpful,thank you
Thank you very much! Keep up the good work!
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.
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!!
Amazing video learnt a lot
Control T - that could have save me so much time, thank you.
so handy I am heading back to the work force and these videos are fantastic thank you
Wow, thanks man! I learn a new trick in EVERY video!
Amazing excel tutorial thanks alot
Very helpful. Thank you!
You taught very well. Your teaching is very nice.
really helpful, thank you so very much
That was so helpful. Love your content 🌸
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.
Thank you so much for this
Ctrl + T saves so much time. Thanks
Thank you for videos they help me a lot in my job
It was very helpful thanks.
thanks for your sharing
Wow Thanks this wonderful Video
1:03 TO TURN THE DATA INTO A TABLE PRESS CONTROL+T 2:57 GO TO THE TOP LEFT CORNER OF EXCEL SHEET 3:25 GO TO THE BOTTOM RIGHT CORNER OF YOUR EXCEL SHEET 3:47 CONTROL+DOWN ARROW TAKES YOU TO THE BOTTOM OF DATA IN A COLUMN 4:44 IF YOU WANT TO SELECT PREVIOUS SHEET PRESS CONTROL+PAGE UP KEY 5:21 IF YOU WANT TO MOVE TO THE NEXT SHEET PRESS CONTROL+PAGE DOWN KEY 8:21 CONTROL+SPACE FOR SELECTIONG ENTIRE COLUMN 8:39 SHIFT +SPACE SELECTS THE ENTIRE ROW
Very informative video
Thank you for sharing
You are so helpful i found Excel very interesting after watching your video keep the good work ❤
I'm a follower of your videos, they are all interesting. thanks for sharing your knowledge.
These are amazing! Thank you so so so much! You are GREAT at this!
Yes very useful
thanks for your effort
You are an excellent teacher
Very helpful, thanks mate
It was really helpful ...please keep posting more
So useful, 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
Appreciate you for this video buddy
Awesome Tips ~ Thanks Much !
I really love your videos, they are really beneficial.... Kudos to you :)
I learned a lot from here thankyou ❤️
Thank you!
Thank you for your videos 👍
Thanks for your this lesson.
Bro, you are saving my life *daily.*
Very useful, thank you sir👍
Tks a lot sir
Thanks man, it help a lot
Good video, thanks
This was much needed!!!!👍🏼
Very useful thank you
To the point thank you
Useful, Thanks
Nice video
Thank you