Wednesday, November 04, 2009
Using Microsoft Excel to Create a Schedule
Click Start. ![]()
Click Microsoft Excel.
![]()
Click File.
Click Page Setup.

Click the button next to landscape.

Click Ok.
Go down to cell B2.

Type Monday in cell B2.

Press the Enter Key on your keyboard.
Place your mouse on the bottom right hand corner of cell B2.

When your mouse is right on the square it will turn into a thin cross.
When it is a thin cross click and drag to the right.
Monday through Sunday will show up. If you drag farther than the 6
days it will repeat the pattern of Monday through Sunday.

Did you notice that Wednesday was cut off. We are now going to fit the column width. Make sure that the columns for Monday through Sunday are still selected.
Click Format > Column > Width.

Set the width to 15.

Click Ok.
Type 7:00 in cell A3.

Right click on the time 7:00.
Click Format Cells.

Under "type" click h:mm AM/PM

Back on the cell of 7:00 click and drag down until you have
10:00 PM. 
Select all the cells where you will be typing for your
schedule.

Right click on one of the selected cells. Click Format
Cells. 
Click Alignment.
![]()
Click Wrap Text.

Hold Ctrl on the keyboard and press the A key. This should select all.
Click the borders button. Click All borders.

Now fill in your schedule.