InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
Solve : Can I create an autofill library in Excel?? |
|
Answer» 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?I don't know. How to Create Custom AutoFill Lists in Excel 2013Also: https://www.youtube.com/watch?v=vOOuSe_s6pQ Autocomplete Entries With Excel Drop Down List |
|