How to create AutoFill strings in Excel
Random AutoFill string is a list of values that you enter frequently. This list may include employee names, department names . The problem is that you have to re-enter. You can save time by creating an AutoFill string in Excel 2003 following these instructions:
1. Enter the values and then select the list of values.
2. Select Options from the Tools menu.
3. Click the Custom Lists tab.
4. Click Import .
5. Click OK to return to the Excel editor page.
6. Select an empty box, enter the first item in the list and then hover your mouse in the lower right corner of the newly entered cell, drag the input formula until the list is complete.
If you create a list on Office 2007, you need to do some more things like this:
1. Enter a value and then select the list of values.
2. Click the Microsoft Office button
3. Click Excel Options (in the lower right corner).
4. Click Popular .
5. In the Top Options For Working With Excel section , select Edit Custom Lists .
6. Click Import .
7. Click OK twice.
8. Select an empty box, enter the first item in the list and then hover your mouse in the lower right corner of the newly entered cell, drag the input formula until the list is complete.
In every version, everything is very simple until you see the first item in the list too long or unbalanced. But you really don't want to enter the same in the rest of the list! Or suppose you delete the employee name at the top of the list, the only option for you is to re-create the list.
You can avoid these potential pitfalls by creating a title for the list with a generic and brief title, such as "Employee" and using that title as the first item. Let's take an example using Excel 2003:
1. In cell A1, enter ' Employee '
2. In cell A2.A4 enter a number of names.
3. Select A1.A4.
4. Select Options from the Tools menu, select the Custom Lists tab, click Import then click OK .
5. In cell C1, enter Employee .
6. Drag the input formula down to cell C4.
This method has 3 benefits :
- You will not have to re-create the list if the first item changes.
- A brief, short pepper will help reduce the amount of data you enter from the keyboard.
- You will not have to remember the exact value entered or how it was entered (name format, full name .).
Avoid using this time-saving method on repeating strings because Excel will include the subject line in the list.
You should read it
May be interested
- Convert data from Word to Access databasealthough access is a database application that has strong interface objects, users are not familiar with this application. in this article tipsmake.com will guide you how to use word application to collect user data and then transfer to & agrav
- Microsoft Office 2008 for Macafter a series of delays, microsoft plans to release office 2008 for mac to officially announce on january 15, this is the first upgrade in the last 4 years. microsoft tested the non
- Excel data entry fasteryou can completely enter data without re-entering the same information you entered from other sheets or files in excel. there are many ways to make importing data in excel faster and smarter without even touching the keyboard.
- Advanced Gmail technologygmail mail service gives you a lot of useful features, from sending and receiving to retrieving messages when needed. although in webmail mode as well as being used through microsoft outlook mail management program, you can arrange messages for easy-to-read purposes, making the work quickly resolved. here are some good use experiences
- MS PowerPoint - Lesson 4: PowerPoint design templatepowerpoint designs are available designs including color schemes, slides and main titles with custom font styles and formats, all designed for a specific purpose. after applying a powerpont design template, every time you add a slide show & igr
- MS PowerPoint: Tips or making rich slide showspowerpoint is a program to build the most popular slide shows available today. the following article will guide you to some good tricks in using powerpoint. with powerpoint, you can easily present your ideas through images, texts and sounds. the tips below, hopefully help