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

Entering data automatically with Auto Fill - Microsoft Excel Tutorial

From the course: Excel 2010 Essential Training

Start my 1-month free trial

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…

Contents