Exam 77-420 Microsoft Excel 2013
2. Create Cells and Ranges
2.1 Insert Data In Cells and Ranges: Autofill


Home -> Number ->Format Cells

Fill a Series with AutoFill

Now, one way to put in the dates for the next month would be to type them all. Do you want to know a faster way? AutoFill is a quick method for filling in data. It is not quite the same as copy and paste.

 

5. Try This: Use The AutoFill

Please select Cell A2, first.

Look at the bottom right corner of Cell A2.

The AutoFill Handle is a small square. When you run your mouse over the Handle, your mouse will become a thin black cross.

 

Hold the AutoFill handle and drag down to Row 24.

 

What Do You See? The dates will increment (add another day to each Row) as you Fill Down Cell A2.

 

Keep going...

graphic2
graphic1
 
graphic3