AutoFill And Custom Lists In Excel 2007
by: MatthewFletcher |
Total views: 2 |
Word Count: 520 |
View PDF | Print View
Share This Article
Excel's AutoFill feature relies on the program's ability to recognize patterns in the data that you enter. For example, if you type "Week 1" in a cell, you can have the program automatically fill in "Week 2", "Week 3", etc. by using the AutoFill handle. This is located in the bottom right of the cell. As the cursor moves over it, the cursor changes appearance to a plus sign (+). When it does so you simply click, hold, drag in any direction and Excel will pick up the pattern and extrapolate it to create automatic data entries.
Each time you use the AutoFill handle Excel displays the AutoFill Options drop down menu just below the last cell which has been automatically created. If the program has not entered the data you wanted it to, just choose one of the entries in the AutoFill Options to tell it what you wanted it to do. For example, if you choose Copy Cells, Excel will generate 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 Excel's built-in lists, you can also create your own custom lists. For example, let's say we work for a company that has branches in several towns. We would almost certainly need to list these towns quite frequently in our spreadsheets. We could save ourselves a fair amount of time by setting up the towns as a custom list.
Creating a custom list is really easy. First, select the cells in one of your worksheets that contain the necessary information. Second, click on the Office button and choose Excel options. Third, click on "Edit Custom Lists" in the "Popular" category. Excel displays the entries that were in the cells that we highlighted. Finally, to convert the selected data into a custom list, click on the "Import" button.
Once you've created a custom list, it can be used in any of your worksheets, not just the sheet that contained the original information. To generate the entries in the list, simply type the first value. Next, drag the AutoFill handle to conjure up the remaining entries. When using this facility, we can drag in any direction and we don't have to start with the first member of 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 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.
Share This Article
Rating: Not yet rated Next Article - Used Metal Detectors v1.0 - Software and Previous Article - Software Helps Plan, Estimate Improvement Costs
About the Author
The The writer of this article is a trainer and developer with OnSiteTrainingCourses.Com, a UK IT training company offering Microsoft Excel Classes at their central London training centre.
Comments
No comments posted.Add Comment
Popular Articles about: Software
1: Viagra2: Adobe Illustrator: Getting Past The Blank Canvas
3: Enhance Your Web Pages With Dreamweaver's Javascript Behaviors
4: How to use a poker software
5: MyCafeCup.com launched new AIO Internet Cafe Software + WiFi HotSpot Gateway Billing.
6: The Easy Way To Write An E-book
7: How to convert swf to Avi, iPod, iPhone, PSP, Zune
8: Optimize Your PC With Registry Cleaner
9: A new version of contextual German-English and English-German dictionary TranslateIt! for Windows
10: Pre-packaged vs. Custom Software
11: Getting Rid Of The This Nasty Philippine Made Virus
12: DOCUMENT SCANNING STORAGE of RECORDS DIGITIZING ARCHIVING PAPERLESS OFFICE NYC.
13: Using Personal Computers to Solve Humanitarian Problems
14: Find Home Renovation Software
15: Your Reaction to the Idea of Paying Students
16: The Story of Finding Longitude: It Was All a Question of Timing
17: Choosing the Turnkey Software for your Business
18: Tokenless Two Factor Authentication Ensures Secure Remote Access
19: The Way People Communicate Has Changed Over Time
20: Windows Vista Ultimate OEM Software
21: How To Safely Clean Windows Registry
22: Commercial Driver’s License CDL Manual
23: Does iBuzzPro Automatic Recruiter Software Actually Work?
24: How To Use Article Marketing For Free Unlimited Traffic
25: Big Ticket to Wealth Retail Store-- Is It Worth A Visit?
26: Management Software To Drive Your Bottom Line
27: Multiple Streams of Income...Surefire Way to Success
28: How to find an email address easily
29: Don't Buy a Myspace Friend Adder: Compare Consumer Ratings First
30: Cleaning Your Windows Registry Effectively