Welcome guest. Before posting on our computer help forum, you must register. Click here it's easy and free.

Author Topic: Can I create an autofill library in Excel?  (Read 3240 times)

0 Members and 1 Guest are viewing this topic.

broadfield

    Topic Starter


    Newbie

    • Experience: Familiar
    • OS: Mac OS
    Can I create an autofill library in Excel?
    « 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?

    Geek-9pm


      Mastermind
    • Geek After Dark
    • Thanked: 1026
      • Gekk9pm bnlog
    • Certifications: List
    • Computer: Specs
    • Experience: Expert
    • OS: Windows 10
    Re: Can I create an autofill library in Excel?
    « Reply #1 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