Most Useful Excel Keyboard Shortcuts

[@hydrazine799]

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]

What about for Mac?

[@denised.5300]

Thank you professor I'm trying to get a new job

[@yvng4697]

@@denised.5300 did u got the new job?

[@mariatovar1657]

3edxxxxxxxxxxxxxxxx

[@mariatovar1657]

C,,xxxxxxxxz,,,z,cxxcxx,---'

[@charanmg9437]

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]

Charan MG Thank u my good man !!

[@foodparadise5792]

You are the hero of the century.

[@anjumshaikh3270]

Thank you sir.

[@jayrichzhanra4988]

Thank you very much! Saved my time. Next vid.

[@MihaelaV68]

Charan MG thank you

[@Leann222]

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]

Thankz

[@great9391]

He's good anyway

[@mahmoudranjbarniavol3197]

Thinks

[@trueleyes]

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.

[@adam346]

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]

😅😂😂😂😂

[@lindseyporter8763]

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.

[@MasterBillieChong8989]

You're really giving me confidence to further enhance my knowledge on excel

[@laman8914]

Short cuts are fun to work with. Makes work easier. Thanks

[@raveeshroy]

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

[@haqueheraclia186]

Wow Thanks this wonderful Video

[@breannadimaio1060]

WHat a bright & shining light, thank you for this!!!

[@hellentrinnahk]

Your content have helped learn MS Excel at a high speed, Big up!

[@fayrouzbattah1734]

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♡

[@ninawestlake14]

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!💛👌🙌😘💯

[@omarrefaye3105]

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 ❤️ .

[@sivakumar.v.rsanjayannamal7741]

very useful tips , it saves lot of time and easy to work in spread sheets

[@samuelomolo3375]

I hav perfected my excel skills now.Thanks for making them easy to understand.

[@chascarpenter5006]

Very good, easy to understand & said @ a speed you could listen to all day.

[@johnhogan6775]

I like the control T function. It makes the work look very professional.

[@lanietaray6566]

Thank you for this useful information. It helped a lot to enhance my skills in excel

[@jadad1010]

Thank you. These basics are helpful for beginners

[@graemed-g522]

Control T - that could have save me so much time, thank you.

[@philiplbrown]

super informative video. Clear, concise and very well presented.

[@HOWTOEngineering]

VERY USEFUL

[@AbdulKarim-id4wk]

Very helpful for excel users. Many thanks for uploading such an important tutorial.

[@jayshree3592]

Amazing excel tutorial thanks alot

[@venukrishna8453]

Amazing video learnt a lot

[@abhilashasimha]

You taught very well. Your teaching is very nice.

[@NasirKhan-vh9bg]

Highly appreciate. Nice way of explaining and elaborating 👍👍👍

[@sgn01149]

excellent informaiton

[@Neo-madnes]

so handy I am heading back to the work force and these videos are fantastic thank you

[@mariasarri1517]

Your videos are amazing! You are a great teacher... Thank you!

[@dadosscreen7498]

Hi maria

[@KishanKumar-tv8yw]

Essential Excel Shortcuts: 0:16 Ctrl + S: Save your file. Handy to avoid losing work! 0:30 Ctrl + P: Opens the print dialog box. Quick access to printing options. 0:46 Ctrl + T: Converts selected cells into a table. Useful for organizing data. 3:05 Ctrl + Home: Moves to the upper-left cell (A1) of your worksheet. 3:30 Ctrl + End: Moves to the last cell with data on your worksheet. 3:49 Ctrl + Down Arrow: Jumps to the bottom of the current data range. 5:08 Ctrl + Page Up: Switches to the previous worksheet tab. 5:25 Ctrl + Page Down: Switches to the next worksheet tab. 5:48 Ctrl + D: Autofill cells with the content above. 7:29 Ctrl + A: Selects all cells in the worksheet or table. 7:58 Ctrl + C: Copies the selected cells. 8:03 Ctrl + V: Pastes the copied content. 8:22 Ctrl + Space Bar: Selects the entire column. 8:41 Shift + Space Bar: Selects the entire row. These shortcuts will definitely speed up your workflow and make navigating Excel a breeze. Want to learn more about any specific feature or shortcut?

[@nischalnepal9102]

thanks for information and your support

[@gopalakrishnan5895]

This lesson is 👌🌲

[@helenshukla1126]

Thanks so much for sharing that... the shortcut for wrapping text was a savior!

[@donaldjones637]

A couple more handy ones. Fn + 4 -- repeats the last command you did. Ctl + I -- Inserts a row (Or inserts a column if you have just done Ctl + space) So Shift + Space | Ctl + I | Fn +4 | 4 (while still holding the function key down) |4 will add in three rows.

[@timothykwemoi9036]

Incredibly helpful,thank you

[@starbright1458]

I have learned so much thank u 🙏

[@sourovajmain2048]

Ctrl + D is new for me. Thanks

[@getfanmedia]

I'm a follower of your videos, they are all interesting. thanks for sharing your knowledge.

[@melfromtoronto8746]

WOW. I'll be practicing these shortcut keys at work from now on. Thanks again! (y)

[@Kolian1274]

Hello I enjoy watching your channel can you tell me how can I create a random number between 20 to 39 to create five digit random number In Excel

[@coastersandcars63]

Wow, thanks man! I learn a new trick in EVERY video!

[@mn6780]

Thanks Just what I was looking for

[@las0aguas]

Thank you for videos they help me a lot in my job

[@audreyreyes3881]

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.

[@lindaadalla2956]

This is very helpful and interesting ❤thank you so much!!!

[@snaik7372]

You are so helpful i found Excel very interesting after watching your video keep the good work ❤

[@rachelagbuya9606]

Thank you so much for this

[@el4942]

you're a great teacher. this was very helpful. thanks

[@LizbeeHeart16]

Your videos are changing my life. Thanks!!

[@botdavid323]

I'm learning Excel right now. Thanks for the info!

[@bestlearnings4265]

"Excel is an ocean of undiscovered possibilities, where every click and formula unveils solutions waiting to be found."

[@nengtech6914]

thanks for your sharing

[@KartiniSihombingKaSihT0P]

Very informative video Thank you for sharing

[@paulvanobberghen]

CTRL + R will do the same as CTRL + D but will copy to the right if you've selected some cells on the same row. (R = Right and D = Down?)

[@juliegoldman5500]

New to Excel great short cuts

[@ankonish]

isn't dragging the black + mark more efficient than ctrl+D ?

[@sanelasarac7425]

Thank you!

[@douglasansah435]

Thank for wonderful videos. Do you no any game that contains excel for practice?

[@fadishamoun2271]

Thanks, I struggle when using Ctr key + up, when there is a filter because it is always send me to the filter cell not to the cell after the filter? Do you know what to do here? Thanks

[@solomonkhumana338]

great teacher

[@samirtiwari9115]

Can we use this video in our channel Will there be copyright issues or not ?

[@nicenaiz6992]

It's a big help. Thank you so much!

[@jamesmyrthong6112]

Thank You Very much 🙏🙏🙏🇮🇳🇮🇳🇮🇳

[@SamsonJSMLthokchom]

It was really helpful ...please keep posting more

[@NicoleC510]

best teacher!

[@zanpotter3014]

Thank you this sir. I am going to the exam about excel next week.

[@migueles4834]

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]

P0 P

[@syljihomom]

Best excel tutorial!! Your explanation is very clear, to the point and very helpful. Thank you.

[@wasimprince4353]

Hi you need to learn excel more i will teach you

[@pratikshameshram5872]

Thank you sir

[@r.lurdumaryn.rayappan7511]

Very good video

[@auroradsouza8927]

Thank you

[@collinsnzuya999]

thank you so much

[@minhae970524]

Thank you for this amazing tutorial!

[@simpleexcelexamples9619]

Very useful to work more efficiently in Excel! Thank you for this great video 😊

[@teridelcollo6221]

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.

[@lynnhandy5638]

Fabulous, just what I needed for my new job!!

[@adeelulhaque3624]

All I already knew but it was very useful for me :)

[@dddog9024]

Useful, Thanks

[@patricebennett1100]

That was so helpful. Love your content 🌸

[@Practical-Theoretical]

Very helpful, thanks mate

[@bbchetri5313]

Really very much helpful

[@balnarayana]

Sir very good explanation with congratulations and thanks

[@sujanikoralagedon1097]

Nice work 😃😜

[@great9391]

Useful.... Training my 🧠

[@kirangurung3108]

Thanks 🙏

[@karennickolette5831]

Do you have a document that lists all of the excel shortcuts that you had in the video about the most useful excel keyboard shortcuts?

[@thesispepmethod]

do you know the shortcuts for mac?

[@lollipopper7878]

Thank you so much, you just helped me in my last minute studies!

[@asikinabduldie5945]

thank u very much sir!!!!!!!

[@christellelafrance3706]

Very interesting.

[@aishasultanaishasultan6266]

Informative video

[@anelson6137]

This was much needed!!!!👍🏼

[@rameshkanakatte9209]

In my excel work sheet when I press tab key, the cell is not shifting to next cell but at the long cell. What can I do?

[@s.karlongolocooper4953]

Thanks for your this lesson.

[@poilou2607]

What is the shortcut for number format : 554658,32 ==> 554 658 ? Ctrl + ! is OK for spaces but how do i delete the coma ?? THX

[@a2ainfo879]

Thats great. it helps.

[@ClubHondumexMedia]

Thank you for your videos 👍