Computer Hope

Software => Computer software => Topic started by: broadfield on April 30, 2017, 07:28:54 PM

Title: Can I create an autofill library in Excel?
Post by: broadfield on April 30, 2017, 07:28:54 PM

I'm sure there's a simple solution, but I cannot find it.  I use Excel to keep track of expenses and all other bank transactions for my wife's business.  Every month I send the accountant the spreadsheet and it typically has the same payers, payees, descriptions etc for every month.  If I'm working on a spreadsheet and enter "Office supplies" into my description column, then it will autofill "Office supplies" if I start to type it into any subsequent cell in that column.  However, I want it to remember "Office supplies" when I start a new spreadsheet the next month.  Is there any way I can add words or phrases, to a library, where the autofill can pull from every time I make a new document?

Title: Re: Can I create an autofill library in Excel?
Post by: Geek-9pm on April 30, 2017, 09:52:07 PM

I don't know.  :(
But apparently it is said t o be easy. :)
See here:
http://www.dummies.com/software/microsoft-office/excel/how-to-create-custom-autofill-lists-in-excel-2013/

Quote

How to Create Custom AutoFill Lists in Excel 2013

Also:
https://www.youtube.com/watch?v=vOOuSe_s6pQ
Autocomplete Entries With Excel Drop Down List