Move on to the next steps now to get more organized data from this dataset. Finally, select columns B:G, and in the name box, write the name of the dataset, Let’s say, Tasklist.The completed list would look something like this. At this point, the formats will be automatically added and copy the lists created by Data Validation for the next rows. Now fill out all the tasks in the dataset.Similarly, add list boxes under the other columns with the help of the other sheet.Consequently, a list box will be added with the categories in the selected cell. ![]() After that click on OK in the Data Validation.Then select the Source field and then select the different values from the Tables.Now go to the Settings tab and select List under Allow. As a result, the Data Validation box will pop up.Then go to the Data tab and select Data Validation from the Data Tools group.Now go back to the AllTaskList sheet and select cell D5.Create different values for categories, urgencies, importances, and the status here.And then create a new one with the name Tables. Let’s name the spreadsheet AllTaskList.After that, select an area where you want to keep the dataset.Now go to the Home tab with the formatted cell selected and select Format Painter.After that click on OK in both the boxes. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |