Today’s video lesson goes through some of the basic formatting techniques in Excel 2010:

– How to Use the Auto-Fill Drag Handle / Fill Series Options

– How to Use the Format Painter

– Freeze / Unfreeze Panes

– Sheet Formatting (Coloring Tabs / Renaming)

– Print Area Setup / Print Options

Download the latest **Master Workbook **to follow along with the video! The sheet titled “8 – Autofill” in the Master Workbook is what is used in the lesson example:

**Now that you’ve got the basic formatting techniques down, why not learn about Conditional Formatting!**

Hey Ben,

I tried the autofill option, but when i’m dragging the autofill cursor, it;s just copying the topmost tab. So, for e.g, if i try to autofill a column with 1 written on top, it’s just copying 1’s in all the selected rows.

In order to use this function (autofill), you first need to have a series which you need to extend. If you have just one number or one cell, like the example you are citing, that does not constitute a series.

You need to have at least 2 completed cells (i.e. 1,2, or Monday, Tuesday) in order to drag and autofill)

Hi Ben, Thank you so much. It’s really useful video.

This video is not working for me. Just a black screen. I have reloaded the page and still nothing.

I got it.

Too many browsers were open.

Trying to figure out how to sum a value and have it transfer to another sheet?

hello i seem to be missing the sheet tabs and horizontal scrolling bar in the master workbook. i already went through the advanced options and checked the boxes and still nothing. HELP ME PLS

Hey there,

Can you provide a screenshot?

It should be there but may appear to be hidden depending on how large the scroll bar and tabs are.

Let me know.

Thanks,

Ben

Hi Ben, when you talk about Freezing Panes in this video, you show the little marker above the scroll bar which can be dragged down, although I appear to be working on the same version of Excel, I don’t seem to have that option. Is it something that needs to be ‘switched on’ in the various menus?

Hey David,

This option is only visible if you have the panes ‘unfrozen’. Otherwise they are not able to be selected and dragged.

It seems in future version of Excel (i’m in 2016 right now) that the option might have been removed as I don’t see it.

Let me know if you’re still having trouble.

Cheers,

Ben C.

ExcelExposure.com

I’m very new to your site and so far it seems really great!! Thanks so much!! I’m curious though, are there any sort of exercises that are part of the program? If so, where would I find them? If not, do you know where I can find Excel exercises online to practice with? Thanks again!!

Hi, check out the ‘Master Workbook’ page for the workbook to follow along with the lessons.

Dont be jearous Erik, you are doing no good

This is the worst lesson I have ever had to be a part of. He is the worst teacher I have had the pleasure or non pleasure to listen to. you try to explain how to do things, but you dont tell the LISTENER if this happens do this. Not everyone is perfect in Excel and yes we are going to make mistakes. I am so frustrated I will make sure to tell all the people in know not to go on this website.

Thanks for the feedback! It does not seem as though other people have had the same experience, but feel free to look into other free training online.

You sound like such a moron, this guy explains everything so perfect in depth and if you really can’t keep up with the basics maybe you need elementary school reruns

Dont be a plonker

If you need attention, go to your mom. I really like this website.

Your way of expressing seems easy to comprehend,i hope to grab it and execute the same at practice. Thanks

You have dealt with the most minute, yet important topics.

Thank You Ben!

Hello I just started viewing your lesson and they have been very helpful so I would like to start off by saying thanks! However quick question on your second video how did you get to the blank page without the cells when the videos come on you have days and dates in place. I know this is a very basic question but I have no experience with excel only what I have seen in your videos. How where you able to get the text on the page?

I was wondering the same…

I’m not sure if you’ve figured it out by now or not but if you click “view” and “show/hide” the “gridlines” option is there to remove them. Hope this helps.

Thanks!

Thanks. You are teaching me a new “language”.

I’m sure this video must be really useful as other but too bad that the voice was cutting off and I couldn’t hear it.

thank you

Thank you so much – you saved the day for me at work today!

The excel video class is very good and informative. You have done a great job. The way of explaining is very good and understandable. The master workbook is very helpful.

Excellent really good

Thank you very much. Keep sharing your knowledge, I am very grateful to you.

Wonder full way of explanation..

Also check http://www.excel-formulas.in/p/learn-basic-formulas-online.html

incredible. I know nothing at all about excell, except I feel I need to learn it and i started tonight. I have already been thru and understand the first two lessons. If I can get this, this guy is good. Good job Ben.

please help , i’m in indonesia , and the video won’t appear, not only in this guide , but all the lesson’s videos won’t appear. it’s remove by the other media. please help,maybe another link to learn this video?

This is not happening with my system also

Thank you so much!!!

Thanks a million. Excellent work.

i want to insert blank row in a sheet which having data in whole rows ,please guide

I cant download it any one please help me downloading it

I cant download it

Really helpful, thanks.

Ben, this is fantastic. Great course! Thank you.

Glad you’ve enjoyed it so far!

I’m sure you will be an Excel ninja in no time 🙂

Cheers,

Ben

Hi Ben,

I am using Excel 2007 and am not able to find that print page you were speaking about in the end. I could really use the scaling function and am having trouble figuring this out.

Thanks for your time!

Hey Hallie, unfortunately I don’t have excel 2007 but this link appeared to be useful:

http://www.uwec.edu/help/excel07/pr-basic.htm

Other than that I’d say Google it or you can try telling me the problem in a bit more detail.

Cheers,

Ben

Thank you so much for your help 🙂 I’m learning lots!

Very helpful. Thanks a lot Ben.

when i drag down the cross it just copies the same text into all the cells. And when i click on the auto-fill options the only options are, “copy cells,” “fill with formatting,” and “fill without formatting.” The cell is formatted as “general.” any idea what im doing wrong?

It could be a language issue, try changing your excel to English or just translate the days of the week to the language excel is set to in your computer.

Thank you for your time. I found this very helpful!

“Video Lesson: Basic Excel Formatting Techniques |

Free Excel Training!” was indeed a fantastic blog post.

If merely there was a whole lot more web blogs just like this amazing one on

the actual internet. Nonetheless, thanks a lot for your personal precious time, Cleta

Hi Ben, It was great. can you tell me again how to sort out upper and lower case letter

for example: ASHLEY jAmin instead I want Ashley Jamin

Hey Ashley,

That’s actually very easy, but you have to use a formula.

If you use the PROPER() function around the name, it will correct it to start with a capital letter.

Hope that helps,

Ben

thanks allot from your cooperation

Hello Ben, I have Excel Starter 2010, will I be able to follow the lesson plan with this version, or will I be better off using my full version of Excel 2007. Thank you Teresa

Hey Teresa,

I’ve actually never used Excel Start 2010, so I’m not sure of the differences.

I would imagine it would be closer to 2010 than 2007 would be, but that’s just a guess.

Sorry couldn’t be more helpful.

Cheers,

Ben

Good Job There!!!!

HOW TO MULTIPLY MINUS ADD N DIVIDED IN ONE ROW

Thank you so much. These details are trivial but important.

Is there a special reader/viewer that I need to download before I can see the videos? My screen is black and I’m unable to watch videos…

Hi Sue,

Depending on which type of computer / browser you’re using, you may have some issues (I’ve specifically noticed those with Macs having problems).

At https://vimeo.com/excelexposure/videos you can find all of the videos, and on each page there is a download option, which seems to work for those who are having problems.

Hope that helps,

Ben

thanks Ben…Its very useful to learn excel.Once again thanks for your time and efforts.

Hi Ben,

Please guide me where could I find the data to practice all the functions you been teaching. while watching the video it seems so easy, but to practice I kinda get lost . if you could provide me the sample data it would be great to practice simultaneously.

i do appreciate this video, it helped me to remember my excel.

Heckuva good job. I sure appreciate it.

Absolutely awesome! Congratulations both for the hability to teach and the kindness to free offer it!

This is an invaluable tutorial. Thanks so much for explaining the material in an easy to digest and very articulate fashion. My fear of MS Excel has been put to ease.

thank you very much……..

Thanks Ben…Very Helpful…this is definitely going to help me at my workplace..!!

Thanks for the great lecture!

It’s easy to follow and understand!

May I ask how to add the VIEW button in my excel document.

Hi Elena,

Which version of Excel do you have?

If you have 2010, you can right click the ribbon and go to ‘Customize Ribbon’.

At the top you’ll see a drop-down list where it says ‘Choose commands from:’ with ‘Popular Commands’ as the default choice. Change that to ‘Main Tabs’, and you should see ‘View’ as one of the tabs listed. Click on ‘View’ and then click the button that says ‘Add >>’.

Here’s a screenshot to help: http://i.imgur.com/0pdcboF.png

Let me know if you’re still having issues.

Thank you, Ben for the fast replay! I have managed to add the VIEW tab. My excel is 2010.

I simply followed the instructions and the screenshot.

I appreciate it!!!

For me this website is probably the most useful source of information regarding Excel.

I have STEP By STEP book which is Microsoft edition but I am not satisfied.

I also attended excel lectures at my University but didn’t like the way they were teaching us.

Hello Ben, I have Excel Starter 2010, will I be able to follow the lesson plan with this version, or will I be better off using my full version of Excel 2007. Thank you Teresa

Good training!

Hi Ben – Thank you very much for putting this up on the web. I always wanted to learn excel and this seems like a perfect start. One quick question, do you have the examples too in excel? I am trying to follow the video lessons but I spend a lot of time recreating the examples in excel and then following the videos. I don’t want to be presumptuous but it will be great if you can also have the examples in excel that way as we are watching the videos we can follow along more easily without having to type the

Hey Christine,

As it mentions in the post (which I updated to reference the sheet), the Master Workbook has the examples in Excel to follow along with the video lesson. In this lesson, the sheet titled “8 – Autofill” is what is reviewed in the video.

Some lessons have their own file, but most use the Master Workbook, but it should be mentioned/linked in each lesson as to which file you should use.

Hope that helps.

Cheers,

Ben

I really appreciate the way you have set out the series of lessons. I am keen to learn more about excel just for my own personal use and can’t afford an expensive course, and I am so grateful that someone has gone to this trouble and allowed us free access. Thank you.

appreciated your effort sir 🙂 professionals like you make this field awesome 🙂

Its just amazing. why the teachers in school did not teach like that?? thanks a lot its very usefull to me

thnks!!!!!!

Very Nice Teacher ..

Thank you for the valuable information for students like us.

Thank you for this valuable resource!

Thank u so much… i really learn so many new things from this session… thanks again…..

Thank you so much for the lessons. I am starting a new job that will require a much more comprehensive knowledge of excel and I thought I would have to pay hundreds of dollars and sit in a class to get this kind of instruction. Thanks again

Nathan Haws

just finished my associates degree but never really learned excel. I am transferring to a university this fall to study accounting. I want to get better familiarized with excel before then without having to enroll in a $650 course and these tutorials are everything I could ask for and then some. Thank you very much for taking the time to provide such a comprehensive set of lessons!

Just started these lessons and have already learned a myriad of things. Thank you very much for these tutorials.

This has been so very helpful, thank you!!!

Thank you. I need to learn a lot more about excel so this is a great opportunity. thanks once again.

it is really helpfull

thank you so much…

Ben thank you, these are great lessons thank you for your time and willingness to help others.

thank you so much for your effort and time!

thanks for taking the time to create and present this very helpful lesson

very good……….

How did you get to where you don’t view the cell boxes?

Hey Dan,

Those are called gridlines, and I have a screenshot here which shows you how to remove them:

http://excelexposure.com/2012/09/06/alternative-to-merged-cells-quick-tip/gridlines/

Hopefully that’s what you mean by the ‘boxes’.

Cheers,

Ben

excellent .. very helpfull