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 use the AutoFill handle Excel displays the AutoFill Options drop down menu just below the last cell which has been automatically generated. If the program has not entered the correct data, you can choose one of the entries in the AutoFill Options to tell it what you actually meant it to do. For example, if you choose Copy Cells, you simply get an exact copy of what was in the original cell.
Excel also has the ability to automatically enter arbitrary series of data using a feature called Custom Lists. Certain lists are built into Excel, for example, the months of the year. To use the AutoFill feature, enter the first value in the list, for example, "Jan" or "January". Next drag the AutoFill handle (located in the bottom right of the active cell) in any direction to automatically enter the rest of the custom list.
As well as these built-in lists, Excel allows you to create your own custom lists. For example, suppose you work for a company that has branches in several towns. It's a safe bet that you'll need to list these towns quite frequently in your spreadsheets. You could therefore save yourself considerable time by setting up the towns 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.
This custom list can now be used in any of our worksheets, not just the sheet that contained the original information. Whenever we need out list, we simply type the first value. We then use the AutoFill handle to generate the remaining entries. When using AutoFill, you can drag in any direction and you don't have to start with the first element in the custom list.
You can also create custom lists directly in the "Custom Lists" dialog box. Simply click on the "List Entries" button and enter the elements separated by a carriage return. When you have finished entering your list, click on the Add button.
To delete a custom list, simply highlight its name and click on the "Delete" button. Excel checks to see that you really want to delete it. When you click "OK", the list is permanently deleted.
Whenever you use the AutoFill handle Excel displays the AutoFill Options drop down menu just below the last cell which has been automatically generated. If the program has not entered the correct data, you can choose one of the entries in the AutoFill Options to tell it what you actually meant it to do. For example, if you choose Copy Cells, you simply get an exact copy of what was in the original cell.
Excel also has the ability to automatically enter arbitrary series of data using a feature called Custom Lists. Certain lists are built into Excel, for example, the months of the year. To use the AutoFill feature, enter the first value in the list, for example, "Jan" or "January". Next drag the AutoFill handle (located in the bottom right of the active cell) in any direction to automatically enter the rest of the custom list.
As well as these built-in lists, Excel allows you to create your own custom lists. For example, suppose you work for a company that has branches in several towns. It's a safe bet that you'll need to list these towns quite frequently in your spreadsheets. You could therefore save yourself considerable time by setting up the towns 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.
This custom list can now be used in any of our worksheets, not just the sheet that contained the original information. Whenever we need out list, we simply type the first value. We then use the AutoFill handle to generate the remaining entries. When using AutoFill, you can drag in any direction and you don't have to start with the first element in the custom list.
You can also create custom lists directly in the "Custom Lists" dialog box. Simply click on the "List Entries" button and enter the elements separated by a carriage return. When you have finished entering your list, click on the Add button.
To delete a custom list, simply highlight its name and click on the "Delete" button. Excel checks to see that you really want to delete it. When you click "OK", the list is permanently deleted.
About the Author:
Author is a developer and trainer with OnSiteTrainingCourses.Com, a UK IT training company offering Microsoft Excel training courses at their central London training centre.
0 comments:
Post a Comment