Creating a Class Schedule Using Excel


1.                Open Microsoft Excel.


2.                In cell A1 and type in “Class Schedule.”


3.                Select all of column A by clicking on the gray “A” box at the top of the worksheet.


Go up to “Format,” “Cells.”

Under the “Number” tab, click on “Time”, and then under “Type,” click on “1:30 PM.”



















Click “OK.”


3.      Begin your table by creating time intervals in column A.  I usually use 15-minute intervals.  Type in at least three different times.



4.      Once you have three times entered, you can let the computer do the rest of the work.  Select the three times, and move your arrow to the small box in the lower right-hand corner of the box.  Click and drag until you have reached the end of the day.


5.      Now click on cell B2.  Type in “Monday.”



Click on the lower right-hand box and drag until you have all the days of the week.



6.                Center your title by selecting cells A1-F1.  Click on the “Merge and Center” button.



7.      Now you can create the lines on your schedule.  Select all of the cells that you wish to divide with borders.  Click on the “Borders” button and select “All Borders.”



8.      Now, select columns B-F by clicking and dragging on the gray boxes above the chart.



Go up to “Format,” “Column,” “Width.”



Key in “15,” and click “OK.”





9.      Now you can enter your class schedule.  Be sure to type in the cell in which the class starts.



10.    Next, select two cells that you want to combine into one class.


Click on the “Merge and Center” button.



Continue doing this for all of your classes.



11.    Now, select the all of the cells that contain the days and classes.





Click the “center” button.


Now click “Format,” “Cells.”  Choose the “Alignment” tab and under vertical, select “Top.”  Also make sure to check the box next to “Wrap text.”



12.    Now you can make the schedule easier to read by color coding some of the classes.  (Recess, lunch, and specials)  Select the cells that you want to change the color of and click on the arrow next to the “Fill Color” button.  Choose your color and continue doing this with any classes you wish.