Creating a daily schedule can help you stay on track and up-to-date with all your appointments and goals, and an Excel spreadsheet is a great medium for creating just such a schedule. While the small cells aren't the best way to display your information, with a little formatting you can create a daily schedule that is both functional and visually appealing.
-
1.
Open a new Microsoft Excel 2010 spreadsheet.
-
2.
Click on cell "A1." Type in "Date" and press "Enter." Then select cell "B1," type in "Schedule," then press "Enter." Select cell "C1" and enter "Complete," then press "Enter." These will serve as the headers for your schedule.
-
3.
Select the entire second column by clicking the "B" above the column. Move your mouse over the right edge of the column until the pointer turns into a line with two arrows coming off of it. Click and hold the mouse button, then drag the mouse to the right until the pop-up box above the column reads "100.00," then release the mouse button.
-
4.
Click and hold the mouse button on cell "A2," then drag the mouse down to cell "A7" and release the button. Select the "Home" tab at the top of the window, then click the "Merge and Center" button. This will turn your selected cells into one large cell. Click the "Middle Align" button, located next to the "Merge and Center" button. Type the first date that you want on your schedule and press "Enter."
-
5.
Click and hold the mouse button on the cell with your date in it. Drag the mouse to cell "C7" and release the button. Press "Ctrl" and "C" to copy your selection. Click on cell "A8" and press "Ctrl" and "V" to paste the information. This will create a second date on your schedule. Click on cell "A14" and press "Ctrl" and "V" again. Continue until you have all the required days on your schedule, then go back and change the dates on the days you added.
