Create Custom Autofill Lists in Excel

Поделиться
HTML-код
  • Опубликовано: 3 окт 2024
  • Learn how to create your own custom lists that can be used with the Fill command in Excel. MS-Excel 2010 was used in this demonstration.

Комментарии • 7

  • @DKvilla
    @DKvilla 5 лет назад +1

    How to delete the custom list entries in mass ?

  • @juliaAdams100
    @juliaAdams100 7 лет назад

    thank you very much ^_^

  • @dbmnfinity1
    @dbmnfinity1 6 лет назад

    how would you create a auto-fill cells to enter name and have them automatically alpha ordered?

    • @IQAcctSolutions
      @IQAcctSolutions  6 лет назад

      I'm sorry I didn't see your question sooner. The auto-fill entries will be entered on your worksheet in the order they appear on the custom list. So if you want them alpha ordered, you need to enter them that way when creating the custom list. When editing the list later you can insert new items anywhere within the existing list.

  • @piercem579
    @piercem579 6 лет назад

    followed the steps, added the list but still does not auto populate ???

    • @IQAcctSolutions
      @IQAcctSolutions  6 лет назад

      If you go back to the Edit Custom Lists button, does your list show under Custom Lists? If not, try adding it again.
      Also, go to File > Options > Advanced. In the Editing Options section make sure "Enable fill handle and cell drag-and-drop" is checked.

  • @xotwod4865
    @xotwod4865 4 года назад +1

    Audio too low