Excel Basics #2: Keyboard Shortcuts

[blizzal2]

how about? 2 types of concrete have different types of limits its either xc1,xc2,xc3,xs1,xs2,xs3,xd1,xd­2,xd3. for all of these there are a seperate table each for 100 or 50 years. and each of these tables there is a list of different cover values 15,20,25....60. So basically my lecturer wants me to be able to make a working programme where you input for example xc2,cover 15,at 100 years and the limit would just pop up...I have all the limits i just need to know what formula to use?

[ExcelIsFun]

@blizzal2 , try:

Excel Magic Trick 866: Four Lookup Values In VLOOKUP Formula? 6 Examples

[navylaks2]

Is there a fast way to get values from other documents into the spreadsheet fast?

[graham11545]

am not getting to press on the p it keep disappearing when i press on it not getting to even see sp

[hawaii137]

am i missing something ?...the file i downloaded doesn't have the information???



[dlitbak]

Hello. Your video was very helpful.

How can I copy the information of upper cell to lower one?

I know that I have ctrl+c then ctrl+v, but here I need to highlight the cell what I want to copy.

[ExcelIsFun]

@dlitbak , I do not know, Try posting Q to:

mrexcel [dot] com/forum

[dlitbak]

@ExcelIsFun  Thank you.

[87aragorn]

man! you've saved jobs of many by adding these videos! God bless and THANKS!

[ExcelIsFun]

@87aragorn , you are welcome!

[mouse6486]

Im very grateful with this video, lots of skills i have learned from this. Thank you kindly. Will buy the book and download the workbook !

[ExcelIsFun]

@mouse6486 , I am glad that you like the video! Thanks for the support!

[17cfltorres]

Excel has always been a mystery to me, and I only knew enough to survive at work. Your videos are a God-send! Thank you for all your work and for literally changing lives! We are grateful beyond measure!!!!

[ExcelIsFun]

You are welcome!

[geoff1424]

sweet! this guy is a saint for doing this!

[djmaazzoo]

Mate this first video is beyond AWESOME! Great Work...and gooooood Karma!

[jagmeetsinghkhalsa]

i dont know anything about excel and for my job i need to work on this ,iam very greatful for your kind help and all i can say is you are good soul ,i know so much about excel now and that too without paying anything,

thanks once again from the bottom of my heart

[ExcelIsFun]

You are welcome from the bottom of my heart!!!

[pagegurl]

LOVE LOVE LOVE your videos! I had NO idea that one could use the ALT key for shortcuts! Thanks for the awesome new info.

[ExcelIsFun]

You are welcome, welcome!!!

[veivei81]

I'm now a huge fan!!!! i never had a dull moment with any of the videos plus, I learned so fast! You are a blessing!

[ExcelIsFun]

I am glad that you like the videos!

[lera5266]

My dear exellsFun- recently I got my dream job, and need to know more about Excel.Your lessons  helped me to work in excel as prof in one week!!!

Thanks so much for your work and help!!!!!

[ExcelIsFun]

You are welcome! Congrats on the new job!

[VAHOLLA]

thank you so much. your videos are great. I have a professor teaching computer concepts in college and he is horrible. he knows Excel very well but does not do well teaching the class. I am buying the DVD too! THANKS!

[ExcelIsFun]

You are welcome! Thanks for watching!

[jimmytwotimez]

i really wish i had you as a teacher....you are superb and i have learned quite a bit from just video 1 and 2

[ExcelIsFun]

I am glad that you like the videos. You can have me for an entire Excel class Beg to Adv. in the book I just published and the DVD that comes out next week! The book, "Slaying Excel Dragons" is at Amazon for $19 and the DVD will be at mrexcel[dot]com next week! Otherwise, there are 1400 Excel videos that I have posted for free here at YouTube!

[musalmansaif]

learning is cool here

and i really appreciate it

but is it possible that u test us when we r done with the series and tell us where we stand ??

[throyy2K]

Question: why do we go to the website you are offering on these instructional videos if we can go to YOUTUBE? Real question:

My thoughts are that you are very helpful with your tutorials and i cant explain how much I am learning, although I'm thinking that YOUTUBE seems to be easiest to watch. Please explain why I should down load, I really dont understand. Sorry to be sounding like an idiot here.

[ExcelIsFun]

If you wnat the Excel worrbook that I used in the video, then download from excelisfun YouTube channel.

[tyinykiller5]

In 2003 the keyboard shortcut for page setup is Alt, F, U lol

3:18

[ExcelIsFun]

Yes, that used to be my best line when teaching my classes - it ALWAYS got a bunch of laughs!!

[blowyourmindset]

Hi there, you are great!

I have a little problem here. How to select a cell let say A1 and A3 (exclude cell A2) without using the mouse? I'm working with thousands of data every day and I'm very seldom using the mouse as working with keyboard shortcut really save lots of time. I hope you can help me sir. Thanks..

[ExcelIsFun]

You could type the two cell references out. There is a GoTo keyboard shortcut, that would work if you were enrering cell references into a formula, but it would take a lot of key strokes.

[blowyourmindset]

@ExcelIsFun Thanks Sir. Thats very useful. I'll discover how to reduce the keystroke.

[BarclayAvenue]

Than,k you so much this is an awesome time-saver.  You are so easy to watch too!

[ExcelIsFun]

I am glad that the videos hlep!

[sexykarito]

I was wondering how to zoom in and out in a laptop? I dont have a mouse other than the one that comes with the laptop and when I press crt and move the "mouse" it doesn't zoom in or out. I usually press crt "+" or "-" and it works only when I want to zoom a website but it doesn't work for word or excell

Thanks for your videos your awesome!

[ExcelIsFun]

I do not know. Did you try the zoom bar in the Staus Bar (at bottom)?

[sexykarito]

@ExcelIsFun ya I did but I was wondering if there was a keyboard shortcut, Thanks though

[panucci2]

thanks a lot!

[ExcelIsFun]

You are welcome!

[santakgrg]

it's a great video ...thank you soo much...

[ExcelIsFun]

You are welcome!

[getchasum38]

These are great videos !  Thanks

[ExcelIsFun]

You are welcome!

[acrmub791]

Great videos. I am new to excel and this really helps...

[ExcelIsFun]

I am glad that it helped!

[michael0001able]

this guy makes excell look epic lol

[ExcelIsFun]

Excel IS fun!

[richuack]

... nice video on keyboard shortcuts, I suspect that practicing and mastering these shortcuts should save lots of time when at work you do these tasks over and over and over !!!

[ExcelIsFun]

You are right!

Bosses love it when you do a regular task, but with keyborad shortcuts instead!

[annthackrey1]

I love your videos and have learned a lot of tips that save me tons of time. THANK YOU for all you do!

[ExcelIsFun]

You are welcome!

[AznBaabe]

i really like your tutorials

they are very heplful :)

[ExcelIsFun]

I am glad that they help!

[imus16]

Excellent. Thank you.

[ExcelIsFun]

EXCELlent! You are welcome!

[ChristVigil]

Dancing ants... lols. Fun learning.

[ExcelIsFun]

I am glad that you liked it!

[eccentricgal]

Hey! Just want to thank you for the videos! They are so clear and easy to follow. I have to use excel in projects for business in the coming school year and I was freaking out. Now i feel a lot more confident, thanks to you! Keep up the amazing work :)

[ExcelIsFun]

I'll keep making them if you keep watching and rating!!

[olzhas123]

Thanks a lot! Great help, you should charge money for this :)

[ExcelIsFun]

You are welcome!

That will be $5, please!

[amycecillau]

Hi Mike,

I have a question: sometimes when I drag down, it paste from the original cell (e.g. if first cell is 1, the dragged cell will be 1) - (I hate this), but I believe that most of the time it would go continuous (e.g. first cell is 1, dragged cell will be 2,3,4,5,...)- How do I solve this problem?

[ExcelIsFun]

type a 1 then a 2 below, highlight that, then drag down. That will give you 1,2,3,4

or type 1, hold CTRL, then drag down.

[amycecillau]

@ExcelIsFun Sometimes it works, sometimes, it didn't mike.. Very frustrating. :(

[ExcelIsFun]

What is it that is working sometimes, but not others?

[amycecillau]

@amycecillau - sorry, has been a while since i replied.

About the problem that i had with the dragging down and all of them was copied into the dragged cell- while what I want a the continuous number

You teach me to type 1 and then hit ctrl+drag or type 1 then next cell 2 and drag.. - sometimes it works, sometimes it doesnt.

[ExcelIsFun]

Both of those tricks work all the time if you do them correctly. Maybe when you type 1 and drag with Ctrl, you are not dragging the fill handle? It is just a matter of practice. Many of the Excel tricks are not easy to do. It takes time and practice. Maybe you can watch the video again and notice what the fill handle and cross hair cursor looks like, and then try it again. I hope it gets easier for you.

[quikieemart]

i thought you said 'fckin' at 2:30 LoLL.

[ExcelIsFun]

No no - I try not to use words like that!

File menu.. But the old keyboard shortcut for Page Setup was Alt + F + U.

[blueblook]

@quikieemart lol, sounds like it a lot

[amycecillau]

is there an extension of "ctrl+shift+down" to highlight alternative cells?

[ExcelIsFun]

I do not know of a keybaord shortcut for that.

[amycecillau]

I believe so too- that's so sad because it is quite important to have this function.

[jkatz94]

i'm really loving these tutorials

[ExcelIsFun]

I am glad that you like them!

[stephanieroxas]

Thank you sooooo much for sharing your knowledge!! Keep up the good work!

[ExcelIsFun]

You are welcome!

[criminallaw12]

Thank you so much. This lesson will actually help me tomorrow in my job interview/exam

[ExcelIsFun]

Good luck tomorrow!

[17garfield21]

Thanks! its very helpful, Im not done yet w/ your lesson, but I find interesting. hope I can learn the macros too. god bless

[ExcelIsFun]

After this series search for the Highline Excel Class series, in that series I have videos about 50 - 55 that are about Recorded Macros (no VBA).

[hemendrajebaliya]

good work keep doing it

[ExcelIsFun]

I will!

[Yawen2010]

Thanks! it's very helpful!

[ExcelIsFun]

I am glad that it was helpful!

[unbalancedrown]

really extensive teaching.Appreciated!

[ExcelIsFun]

You are welcome!

[Nathan29lincoln]

keep it up guy! Great Job!!!

[ExcelIsFun]

Thanks!

[vshayv]

so helpful

[ExcelIsFun]

EXCELlent!!

[MrJs2727]

Your the Best!!! :-)

[ExcelIsFun]

No, just a guy having fun with Excel! I am glad that you liked the video.

[deeprer]

u r awesome dude. keep up the gud work

[ExcelIsFun]

I'll keep making them!

[RAJESHHA]

Great Video... Lots of Learnings.... Thank You very much.

[ExcelIsFun]

You are welcome!

[4abregas]

very very good... i found myself knew little

[ExcelIsFun]

Learning new things is the best!

[TheMrBenjamin]

Hey, Im trying to download your videos using save2pc so I can work through them at my library where I dont have internet access. But its not working. I have downloaded some of your videos last year using the tool. Have you blocked ppl from downloading your videos? Please inform. THanks

[ExcelIsFun]

No I have not blocked anything. As you know I put everything out there for free. Maybe it has to do with the new user interface Google-YouTube has just installed last week!??

[TheMrBenjamin]

@ExcelIsFun , It was the way i was accessing your videos through your playlists, I fidn a way of doing it now, Thanks for all your videos.

[angelheart285]

great ,awesome,excellent.. well done..i love it..million thanks to u...keep up the good works..God bless

[ExcelIsFun]

You are welcome!

[73davie]

Brilliant as ever

[ExcelIsFun]

Thank you! I am glad that the videos are helpful!

[pierombon]

A superb video and easy to learn. Many thanks

[ExcelIsFun]

You are welcome!

[amyshuangw93]

hey man,you are great! !

[ExcelIsFun]

I am glad that you like the videos!

[bruvensky]

Can you explain to me how to download your workbook? I can't tell from what you say on the videos.

[ExcelIsFun]

Search for and watch this video title:

excelisfun Search for Excel Videos, Playlists & Download Workbooks

[raghavgarg4u]

Amazing Video . . . very nice effort ! ! Thanks a lot for posting all of these :)

[ExcelIsFun]

You are welcome!!

[crzymonkey55]

i wanna make babies with you, this is amzing

[ExcelIsFun]

OK - but the babies have to know all the keyboard shortcuts!!!

[rubrbandball]

Thanks, very very helpful

[ExcelIsFun]

You are welcome!

[fahadsaeed50]

great video

[ExcelIsFun]

I am glad that you liked it!!

[amycecillau]

i believe with this video, i can utlise Excel without my mouse.. I love Excel 2007. However, on Excel 2003, I cannot use the Ctrl+F2 for print preview function. No idea why..

[ExcelIsFun]

Ctrl + F2 should work for Print Preview!

[amycecillau]

no, Ctrl+F2 doesnt work with Excel 2003 on my laptop, but does work on Excel 2007. And the randbetween cannot work on 2003 as well... Looks like i gotta upgrade my computer!

[gobblock662]

Thank you very much for your time and effort for making all this. you are a great teacher! god bless you

[ExcelIsFun]

You are welcome!

[zyzzyva57]

Getting ready to test for my MCAS certification in Excel...YouTube is one excellent learning tool

Sadly, many videos are embarrassing in presentation

ExcellsFun and Mr. Excel are excellent resources to save and review and review , because of my A rating

Keep up the good work...It is most welcome

[ExcelIsFun]

I'll keep making them!!

[zyzzyva57]

Video: A

Audio: A

Clarity of Point: A

[ExcelIsFun]

Wow!! Thanks a lot!!!

[sensibilita]

... on the Mac it is very easy to download any YT videos ... in Safari go to 'Window', then 'Activity' ... find the file that is BIG in size (as in, say, 33 MB), click with the mouse .... voila! It will begin downloading! :)

[delicadokirksome]

Hi!

how can I download your videos? and there is a page load error whenever i use the link that you posted to download the workbooks.

thanks....

[ExcelIsFun]

Dear delicadokirksome,

Unless you get a special program (like YouTube Batch Downloader - search Google for free program), you can't download videos.

If you download the workbooks, there should be no problem.

Watch this video to see how to do it:

Search For Excel Videos Download Excel Files excelisfun

--excelisfun

[00anonymous00]

Hi Sir, I use Mac Book , what can I use for shortcuts in that??

Thanks

[ExcelIsFun]

Dear 00anonymous00,

I do not use a Mac, so I don't know Mac keyboard shortcuts. But someone told me that there is a setting in Mac Excel Options that allows you to use PC keyboard shortcuts.

--excelisfun

[lubenitza2004]

how do I get the result for net pay?

[ExcelIsFun]

Dear lubenitza2004,

Click in the cell F2 and type the formula:

=B2-E2

Then hit Enter. You can then copy the formula down.

I have lots of videos about Payroll. If you know how to get to the excelisfun Playlists, I have a whole Playlist just about Payroll. See see how to get to the Playlists, search for and then watch this video:

Search For Excel Videos Download Excel Files excelisfun

--excelisfun

[Accountant2009ca]

Dear ExcellsFun,

You are such a fantastic teacher. I am using ONLY your site to acquire mastery of Excel. I cannot imagine how much work you put into this. If you sell any books in the future, I will be your first customer.

Thank you.

[ExcelIsFun]

Dear Accountant2009ca ,

I am glad that the videos help you learn Excel! The Excel book that I have written is free. Watch this video to see how to download it:

Search For Excel Videos, Playlists, Download Workbooks!

--excelisfun

[islamic22flower22ksa]

thx very informative & useful

gr8 job

[ExcelIsFun]

Dear islamic22flower22ksa,

I am glad that they are useful for you!

--excelisfun

[ExcelIsFun]

Dear planiolro ,

Highlight Visable Cells Only is Alt + ;

Copy Selected Visable Cells is Ctrl = C

--excelisfun

[planiolro]

good video! I would like to know the shortcut to copy only visible cells(which is very important shortcut). I know that you have mentioned it in one of your videos, but I do not remember in which video and since you have 450 Videos is difficult to find it!

[ExcelIsFun]

Dear planiolro ,

Highlight Visable Cells Only is Alt + ;

Copy Selected Visable Cells is Ctrl = C

--excelisfun