Excel's AutoFill feature is based on the program's ability to spot patterns in the data that you enter. For example, if you type "Week 1" in a given cell, you can have Excel automatically fill in "Week 2", "Week 3", etc. simply by dragging the AutoFill handle. This is to be found in the bottom right of the cell. If the cursor moves over it, the cursor changes appearance to a plus sign (+). When it changes you simply click, hold, drag in any direction and Excel will spot the pattern and maintain it to generate automatic data entries.
Whenever you make use of the AutoFill handle Excel displays the AutoFill Options drop down menu below the last cell which has been generated. If the program has not entered the required data, you can choose one of the entries in the AutoFill Options so that it knows what you actually meant it to do. For example, choosing Copy Cells, gives you an exact copy of what was in the original cell.
Excel also contains the ability to automatically enter arbitrary series of data using a facility called Custom Lists. Some lists are built into Excel, for example, the months of the year. To use the AutoFill feature, type in the first value in the list, for example, "Jan" or "January". Next, click on the AutoFill handle (in the bottom right of the active cell) and drag it in any direction. Excel will automatically enter the rest of the custom list.
In addition to these built-in lists Excel allows you to create your own custom lists. For example, suppose we worked for a company that has branches in several towns. It's almost certain that we would list these towns quite frequently in our spreadsheets. We could therefore save ourselves considerable time by setting this up as a custom list.
To create a custom list, simply select some cells that contain the information. Next, choose Excel options by clicking on the Office button. Click "Edit Custom Lists" in the "Popular" tab. Excel lists the contents of the cells that were highlighted. To set up the selected data as a custom list, simply click on the "Import" button.
Having created a custom list, you can use it in any of your worksheets, not just the one that contained the original information. To conjure up the entries in the list, simply enter the first value. Next, drag the AutoFill handle and Excel will generate the remaining entries. When you use this facility, you are able to drag in any direction and you don't have to start with the first entry in the custom list.
Custom lists can also be entered directly in the "Custom Lists" dialog box. To do this, click on the "List Entries" button and type the list separating entries with a carriage return. After entering the list, click on the Add button to make it permanent.
To delete an unwanted custom list, just click on it and press the "Delete" button. Excel checks that you want to delete the list and when you click "OK", the custom list is removed. - 16928
Whenever you make use of the AutoFill handle Excel displays the AutoFill Options drop down menu below the last cell which has been generated. If the program has not entered the required data, you can choose one of the entries in the AutoFill Options so that it knows what you actually meant it to do. For example, choosing Copy Cells, gives you an exact copy of what was in the original cell.
Excel also contains the ability to automatically enter arbitrary series of data using a facility called Custom Lists. Some lists are built into Excel, for example, the months of the year. To use the AutoFill feature, type in the first value in the list, for example, "Jan" or "January". Next, click on the AutoFill handle (in the bottom right of the active cell) and drag it in any direction. Excel will automatically enter the rest of the custom list.
In addition to these built-in lists Excel allows you to create your own custom lists. For example, suppose we worked for a company that has branches in several towns. It's almost certain that we would list these towns quite frequently in our spreadsheets. We could therefore save ourselves considerable time by setting this up as a custom list.
To create a custom list, simply select some cells that contain the information. Next, choose Excel options by clicking on the Office button. Click "Edit Custom Lists" in the "Popular" tab. Excel lists the contents of the cells that were highlighted. To set up the selected data as a custom list, simply click on the "Import" button.
Having created a custom list, you can use it in any of your worksheets, not just the one that contained the original information. To conjure up the entries in the list, simply enter the first value. Next, drag the AutoFill handle and Excel will generate the remaining entries. When you use this facility, you are able to drag in any direction and you don't have to start with the first entry in the custom list.
Custom lists can also be entered directly in the "Custom Lists" dialog box. To do this, click on the "List Entries" button and type the list separating entries with a carriage return. After entering the list, click on the Add button to make it permanent.
To delete an unwanted custom list, just click on it and press the "Delete" button. Excel checks that you want to delete the list and when you click "OK", the custom list is removed. - 16928
About the Author:
Author is a developer and trainer with OnSiteTrainingCourses.Com, an independent computer training company offering Microsoft Excel Classes in London and throughout the UK.
No comments:
Post a Comment