CREATE YOUR OWN TO-DO LIST USING MICROSOFT EXCEL

Generate your own to-do list by entering the hours of the day in column A and your daily tasks in column B.

To generate your own to-to list:

1. Select cell B1 and type =TODAY().
2. Select cell A3 and type 7:00.
3. Select cell A4 and type the following formula: =A3+(1/24).
4. Select cells A4:A14.
5. From the Edit menu, select Fill and Down.

CREATE YOUR OWN TO-DO LIST USING MICROSOFT EXCEL

Note: To get increments of half an hour, use the formula =A3+(1/48). To display column A as shown in Figure 1-9, select Cells from the Format menu, click the Number tab, select Time from the Category list, select 1:30 PM, and click OK.

Watch the Video Tutorial

Formulas in Excel, Microsoft Excel Tutorials, Today Formula in Microsoft Excel, Excel Video Tutorials, Macros Usages