Microsoft Office Tutorials and References
In Depth Information
Fill a Range with a Series of Values
Working with Ranges
Fill a Custom Series of Values
1 Click in the first cell and type
the first value in the series.
2 Select the range you want to
fill, including the initial value.
3 Click the Home tab.
4 Click Fill ( ).
5 Click Series .
The Series dialog box appears.
6 In the Type group, select
the type of series you
want to fill (
to ).
7 If you selected Date in
Step , select an option 6
in the Date unit group
( changes to ).
8 In the Step value text
box, type the value you
want to use.
9 Click OK.
C Excel fills the range with
the series you created.
Can I create my own AutoFill series?
Yes. You can create a custom list , which is a series of text values. When you add the first value in your
custom list, you can then use AutoFill to fill a range with the rest of the series. Follow these steps:
1 Click the File tab.
2 Click Options .
The Excel Options dialog box appears.
3 Click Advanced .
4 Scroll down to the General section and then
click Edit Custom Lists .
5 Click NEW LIST .
6 In the List entries box, type each item in your
list, and press
after each item.
7 Click Add .
8 Click OK to return to the Excel Options dialog
9 Click OK.
The Custom Lists dialog box appears.
Search JabSto ::

Custom Search