Create a timetable with Excel - how it works

You do not have to use special timetable programs to create timetables. Using Excel to create a timetable is quick and easy.

Use Excel tables for the timetable

1. In Excel, number the first column with your number of hours. Remember to leave the first line blank for the inscription (Monday, ...).
2. Then enter the hour, time and days of the week in the first line (see picture).
3. Depending on the content, you can reduce the first two columns (number of hours and time). To do this, move the dividing lines at the headings (A and B).
4. Now mark the columns of the weekdays and click on the tab "Start"> "Format".
5. Change the "row height" and "column width" there.
6. Then select the entire table and choose "Start"> "Format as table". There you can choose a suitable design and thus visually differentiate the timetable from the excelesque sadness.
7. Tip: Before you now fill the individual columns with your lessons, you should save the empty schedule as a template for further schedules.