Create your own Autofill List to Quickly fill Series!!

image_pdf

Custom list is useful when you have to use some data repeatedly in your work. With the help of Custom list you can easily fill the range of data. There is no need to type the whole list again and again. It also helps reduce errors.

We already have some default list in Excel like January, February, March and so on…

Example:

Type January in A1 cell, drag the cell.

Custom List

Custom List1

To create this kind of custom list follow the below steps:

Steps:

1. Click on the File tab – options.

Custom List2

2.  Select the Advance option and click on Edit Custom Lists under General group.

Custom List3

3. Type your custom list – Click on ADD button to add the list and press OK.

Custom List4

4. Now, whenever you type Ahmedabad and drag the cell the whole list will appear.

Custom List5

5. Even you can import the custom list from the worksheet also.

Custom List6

Explore more, It's Amazing…

3 most useful Lookup function to easily fetch data

100 Most Useful Keyboard Shortcuts of MS Excel

Quickly remove all blank rows from large data tables

 

 

2,135 total views, 1 views today

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>