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.

How to create AutoFill strings in Excel Picture 1

This method has 3 benefits :

  1. You will not have to re-create the list if the first item changes.
  2. A brief, short pepper will help reduce the amount of data you enter from the keyboard.
  3. 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.

4.3 ★ | 3 Vote

May be interested

  • MID and MIDB functions to cut strings in ExcelMID and MIDB functions to cut strings in Excel
    the mid () function returns a string from a text string, with the position to start extracting from the text string and the number of characters returned by the string that is specified. functions used in languages ​​use a single-byte character set (sbcs) and always count each character as 1.
  • SUBSTITUTE function - The function replaces text strings in ExcelSUBSTITUTE function - The function replaces text strings in Excel
    in the course of working you have excel data file need to change a series of data over the years. with a simple operation, you can change all that data. the following article details the substitute function - the function replaces the text string in excel.
  • Why should you turn off the Autofill feature in the password manager?Why should you turn off the Autofill feature in the password manager?
    advertisers have found a new way to track users. according to freedom to tinker, some ad networks are abusing tracking scripts to get the email address that the password manager automatically fills in to websites.
  • How to use MID functions to get strings in ExcelHow to use MID functions to get strings in Excel
    mid function in excel is a function that takes the middle character string corresponding to the value that the user requires to perform.
  • How to draw charts in ExcelHow to draw charts in Excel
    drawing diagrams on excel are basic and often done, when displaying data based on tables or comparing figures together.
  • How to Manipulate Strings in JavaHow to Manipulate Strings in Java
    strings are sequences of characters. for example, 'hello!' is a string because it is made up of the characters 'h', 'e', 'l', 'l', 'o', and '!'. in java, strings are objects, which means that there is a string class that has fields and...
  • How to create a password protection for Excel sheetsHow to create a password protection for Excel sheets
    in addition to creating passwords for excel files, we can proceed to set the password for each sheet in excel data to prevent the ability to edit the sheet content, but can still view the content.
  • How to create bullet list in ExcelHow to create bullet list in Excel
    creating bullet lists (notation lists) in excel is not as simple as in word because there is no bullet button on the ribbon in excel. therefore, this article will show you 7 ways to create bullet list in excel.
  • String (String) in C #String (String) in C #
    in c #, you can use strings (strings) as array of characters. however, it is more common to use string keywords to declare a string variable. the string keyword is an alias for the system.string class in c #.
  • Instructions on how to create diagonal lines in Excel boxInstructions on how to create diagonal lines in Excel box
    manipulating 1 cell into 2 diagonal triangles with a line on excel is a very basic operation and is often performed during the process of creating tables on excel.