Sometimes, when you need to use repetitive data in Excel, you can use handy feature called Autofill. Autofill will help you with repetitive data such as months, days of a week and so on. Excel also gives you a possibility to customize your own lists that you want o use.
Autofill with Defined Lists
First let's enter name of the first month. After you finish typing "January" press Ctrl-Enter to stay in the same cell. Move you mouse cursor near bottom-right corner until your cursor changes its shape into a black cross-hair.
Now you can move your cursor horizontally and vertically. Until you release your button, Excel shows you which month will be last on the list.
Afer you release mouse cursor, all names of months are inserted.
You don't have to insert first month or day to make Autofill work. You can choose anyone you want. Let's try "Friday".
As you can see, when it gets to the end of the series, it starts again from the beginning. You can also use abbreviated forms of months or weeks.
Autofill with Numbers
Numbers are little different when you use Autofill. When you enter a number and try to use Autofill you notice that it gives you whole bunch of the same numbers. This happens because there is no build in series.
If you want to make incremental list of numbers just press Ctrl and hold it until you release mouse button.
You can also create custom lists by selecting multiple cells, for example: odd numbers, even numbers or numbers incremented by 10. To do this, select two cells and then drag your cursor.
Custom Lists
But what if we need a list that is not defined in Excel. For example a list of our workers? You can create your custom pre-made series. In order to do that click File Tab to select the Backstage Viewand choose Options. On the left side of Excel Options choose Advanced. Scroll down to the bottom and inside General region choose "Edit Custom Lists..."
In the new window you can find two areas with data.
- This is a place where you can find defined lists
- Here you can enter data to create your own lists
Now when you enter a name of one of your workers you can use Autofill to insert other names.
0 comments:
Post a Comment