Web Analytics

Excel: Creating Custom Lists

Excel: Creating Custom Lists

The AutoFill feature in Excel can be used with lists to simplify data entry.

For example, enter “Monday” in a cell:Monday.jpg

 

Then pull the fill handle down to fill in the days of the week:

Days-List.jpg

Excel uses “lists” with the AutoFill feature.  The lists that are built into Excel are the names of days and months, both fully spelled out and the standard 3-letter abbreviations:  Mon, Tue,Wed… for example, or January, February, March.

But if you find yourself repeatedly typing the same list of people, locations, products, accounts, or other items, you can add your own lists to Excel in order to enter this data using the AutoFill function.

For example, if your company has offices in several locations, you can create a list of those locations:

From the File tab, choose Options, then Advanced.  Under General, click the button to “Edit Custom Lists”.

 

editcustomlists.jpg

 

With NEW LIST highlighted at the left, type your items in the “List entries” box and click ‘Add”

 

newlist.jpg  When done, click OK.

 

Now type ‘San Francisco’ in a worksheet cell  and pull the ‘fill handle’ down.SF-box.jpg

CityList.jpg

Excel will AutoFill from the list you created.

 

 

If the entry you type is in the middle of the list then AutoFill will start from there. It will repeat the list as many times as needed to fill the cells that you have indicated by how far you pull the fill handle.

citylisting.jpg

 

Lists that you have created can be modified as needed or even deleted by going back to “Edit Custom Lists”.  The built-in lists – days and months – cannot be modified or deleted.

Share:

Related Posts

Accounting: Cash Flow Tips

Accounting: Cash Flow Tips

Reconcile Bank Accounts

Reconcile Bank Accounts

Tax: Records Retention

Tax: Records Retention

Monthly Close

Monthly Close

Excel: Creating Custom Lists

Excel: Creating Custom Lists

Accounting: Chart of Accounts

Accounting: Chart of Accounts

What Qualifies As A Receipt

What Qualifies As A Receipt

Excel: Hide and Unhide

Excel: Hide and Unhide