Subsequently, go to the Data Tools group > Data Validation tool > Data Validation… option. To do this, select the E6:E13 cell and go to the Data tab. Now, after filling the income categories properly, the next thing is to create a drop-down list similarly to the expenses category.You can select your income category from here with a single click rather than writing it every time individually. Consequently, you will see there is a dropdown list at C6:C13 cells where the income categories are listed.Subsequently, at the Source: text box, refer to the B5:B9 cells from the Income & Expense Categories worksheet. Now, at the Settings tab, choose the List option from the Allow: dropdown list. As a result, the Data Validation window will appear.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |