May 14, 2013

Custom Lists in Microsoft Excel 2010

In excel we use lists all the time, and it is nice that you can auto fill your list when you are using a common one such as Jan, Feb, Mar ect.  But there are other lists that your company may frequently use in Excel as well.  Instead of retyping that list every time you use it here is a way you can set it up so Excel will auto fill that information, like it does with other common lists. First Click on the File tab, then Click Options, in the new pop up window Click on Advanced. Then in the same window scroll down almost all the way to the bottom of the page and you will see a button that says Edit Custom Lists. Once you click on it will show all the lists that will auto fill in Excel.  Lastly Click New List and add your list of custom words.

No comments:

Post a Comment