From the course: Excel 2010 Essential Training
Unlock the full course today
Join today to access over 22,400 courses taught by industry experts or purchase this course individually.
Entering data automatically with Auto Fill - Microsoft Excel Tutorial
From the course: Excel 2010 Essential Training
Entering data automatically with Auto Fill
Rather than typing a lot of repetitive data, why not let Excel do it for you? If you take a look here at this sheet, we have months and we did this in the previous movie. Now let's just select all those cells and delete. Let's get back to this first one here in B5 and type the word January and instead of pressing Enter, which would move us down to the next row, let's press Ctrl+Enter so we stay there. Now, if you take the close look at the cell, you'll notice in the lower right corner of the cell is a little square dot. Now your mouse pointer is usually this big plus sign, but if you put the mouse pointer on that square dot, the mouse pointer turns to a crosshair. That's what's called the Autofill mouse pointer or the Autofill handle. When you get that and it has to be that, it can't be another mouse pointer, drag to the right and look what happens. It fills in the months for you. Well that's pretty cool and there's a few other things we could do. Let's go down here to Sheet 2. And…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.