In the Data Validation dialog box, under the Settings tab, please choose List from the Allow drop down, and then click button to select the cell values you want to use in the drop down, see screenshot:. Now, the drop down lists have been inserted into the cells.
And then select the cell range you want to create to do list. Note : In the above formula, B2 is the cell which contains the drop down list, and Complete is the text that you want to format. Then click Format button to go to the Format Cells dialog box, in this dialog, click Font tab, and then check Strikethrough from the Effects section, and you can choose one color for the to do list item as you need, see screenshot:.
Now, when you select Complete from the drop down list, the task item will be deleted by a strikethrough, see screenshot:. You can also create to do list by using a checkbox, when checking the checkbox beside the task item, the task item will be formatted as strikethrough as below screenshot shown:. Then drag the mouse to draw a checkbox, and then select the cell with the checkbox, drag the fill handle down to fill the checkboxes as following screenshot shown:. Then you can edit the checkbox to remove the text to get the following screenshot:.
Tips : If you have Kutools for Excel , with its Batch Insert Check Boxes feature, you can insert a list of checkboxes as quickly as possible. Click to download Kutools for Excel!
After inserting and editing the checkboxes, you should link each check box to a separate cell, right click a check box, and then choose Format Control , see screenshot:. Double-click on the Blank Workbook to open a new Excel spreadsheet. In our Excel to-do list, we want to track tasks and keep an eye on the progress by adding the column headers: Date , Task Name , Target , Status , and Comments.
You can enter the column headers across the top row of the spreadsheet. These column headers will let anyone viewing your spreadsheet get the gist of all the information under it. Enter your task details under each column header to organize your information the way you want. You can also fix the alignment of your table by selecting the cells you want and click on the icon for center alignment from the Home tab.
Use the Filter option in Excel to retrieve data that matches particular criteria. You can also quickly uncheck all by clicking on Select All. In our to-do list, we want to view only the Open tasks, so we apply the filter for that data. After you save this Excel file, the filter will be there automatically the next time you open the file.
You can use the Sort option in Excel to quickly visualize and understand your data better. Click on the Data tab and select Sort. A Sort Warning dialog box will appear asking if you want to Expand the selection or Continue with the current selection. Download this template for free Get support for this template. There are several to do list templates that you can find as part of my excel templates. For example in my daily planner template and gantt chart template. But, if you need a more simple and standalone to do list template, you can use this one.
I called it simple because there is no time or date references inside this template. There are only task name and completion status that you have to fill. It is will be more suitable for kind of jobs or tasks that have to be finished without any strict completion time or date or to be finished within one day or short period of time. There are two kind of templates available. The first one is a single to-do list where it is more suitable to be used for single person.
You can also delete one or more of the columns if you do not need it. How to Use Autofilter and Sort in Excel. Learn more about conditional formatting. In version 1. You can customize the items shown in those columns of the To Do List by editing the values in the Lists or Ref worksheet.
Status: You can enter values such as "Completed" or "In Progress" or abbreviations that you define yourself. Priority: You might want to use a 3-, 5-, or point numeric scale for this column, where 1 is the highest priority. Currently, the Priority column uses conditional formatting to highlight "High" red and "Low" blue.
0コメント