Click on the images for a larger view.
Laying out and printing your schedule is about the most basic function of a spreadsheet. Whether you want to print your busy schedule so your family knows where you’re going to be at any given time or you want to plan out your days to help you develop good habits, Excel makes the task simple, straightforward, fast and easy to accomplish.
Use the top row or two to enter a title/subtitle for your schedule. Only use the first column for this and don’t worry about formatting - we’ll get to that later.
~~~~~~~~~~~
Leaving the next row blank for spacing purposes, the next thing you want to do is determine your start time and the increment that you want to use. In this case, we’re starting at 8:00 and using 15 minute intervals. You only need to enter two time values.
~~~~~~~~~~~
Select both time cells by selecting the first one, holding down the left mouse button and dragging down to the second cell. Make sure when you are selecting the cells that the mouse icon looks like this: 
Notice that when you select one or more cells that there is a small black box in the right-hand bottom corner of the section box.
~~~~~~~~~~~
Float the mouse over the little black box in the bottom right-hand corner. The cursor will turn into a simple cross (+). Click and drag down to fill the cells using the interval established in the first two cells. Notice the tool tip in the little yellow box that comes up as you drag the mouse down that shows the value that will go into the bottom cell. In this case, we’re only filling in for the morning, so we’re stopping at 11:45.
~~~~~~~~~~~
When you let go of the mouse, the times are filled in.
~~~~~~~~~~~
You can fill in different days in the columns even easier. Just enter the first day, hover over the selector in the corner, and drag the mouse across to automatically fill in the days of the week. Now you’re ready to format your sheet!
~~~~~~~~~~~
Related Articles
No user responded in this post