Microsoft Office Tutorials and References
In Depth Information
Entering data using fills
Entering data using fills
Entering a long series of data, such as the days in the month,
weekdays, or a series of numbers with a definite progression, is
tedious. As you type or paste the data, it’s easy to forget which
months have 31 days or on which day of the week the first of
a month falls. Excel makes entering such series simple: Using
AutoFill, you can type a label or value in one cell and assign it to
many other cells; type labels or values in two or more cells and
have Excel extend the series based on the relationship of the cell
entries; or even extend dates by a day, a month, or a year.
Fill data using AutoFill
1 Type the label or value that you want to appear in multiple cells.
2 Drag the Fill handle down or across the cells you want to fill.
TIP If you hold down the Ctrl key as you drag the Fill handle,
Excel changes how it fills in your series. For example, if dragging
the Fill handle would normally copy a single value into the cells that
you drag over, dragging while holding down the Ctrl key causes the
value to increment (for example, dragging the Fill handle of a cell that
contains the value “1” increments the value to 2, then 3, and so on).
TRY ThIS Type 1/1/2013 in cell A1 and then drag the Fill
handle across the cells you want to fill. Excel fills your cells by
increasing the day for every entry. Now click the AutoFill Options
button that appears, and click Fill Years.
Search JabSto ::

Custom Search