Embed Frequently Used Lists into Excel

by David Ringstrom,CPA
 
As you’re most likely aware, it’s easy to instantly create a list of days of the week or months of the year. Just type either the first three letters or the full name of a day or month in a worksheet cell, and then drag the Fill Handle across a row or down a column. What you may not be aware of, is that this is part of the Custom Lists feature in Excel, and that you can add your own lists to use in the same fashion, as I recently noted in our AccountingWEB forum.
Continue reading on www.accountingweb.com.
About the author:

David H. Ringstrom, CPA, heads up Accounting Advisors, Inc., an Atlanta-based software and database consulting firm providing training and consulting services nationwide. Contact David at david@acctadv.com or follow him on Twitter. David speaks at conferences about Microsoft Excel and presents webcasts for several CPE providers, including AccountingWEB partner CPE Link.