![]() At this time, you can see all the subcategories are created as a dropdown list at every cell of F6:F13 cells. ![]() Last but not least, click on the OK button. Following, refer to the cells E6:E17 from the Income & Expense Categories worksheet at the Source: text box. Subsequently, from the Allow: dropdown list options, choose the List option. Consequently, the Data Validation window will pop up.Subsequently, go to the Data tab > Data Tools group > Data Validation tool > Data Validation… option. Now, for creating the subcategories dropdown list, select the cells F6:F13.You can choose your category of expense from here easily. As a result, you will see all the categories of your expenses are in a dropdown list in the cells E6:E13. ![]() Subsequently, at the Source: text box, refer to the D6:D17 cells from the Income & Expense Categories worksheet. Following, choose List option from the Allow: options. Now, go to the Settings tab from this window.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |