Create a timetable in Excel

instagram viewer

Create a timetable with Excel? First of all, it should be said that this does not necessarily require Excel, even in a word processing program such as Word, such a timetable can be quickly created with the help of an inserted table.

You can quickly create a timetable with Excel.
You can quickly create a timetable with Excel.

What you need:

  • Excel
  • keyboard
  • mouse
  • desire

The first steps for the timetable

  • The terms and buttons are titled as they are available in all Excel versions. However, the places in the menu where they can be found differ, as the menu bars are sometimes very different in the different versions. These instructions apply to the 2007 version of Excel.
  • Now start creating the timetable or the table.
  • To do this, open your Excel application and go to the "Page setup -> Page layout" menu. Under "Orientation" set the format to "Landscape". Under "Margins" select 2 for the right and left pages, 0 for header and footer and 3 for bottom and top (length in cm, this should work automatically).
  • Now go to the "View" menu and select "Page layout".
  • Thus the preparations have been made and you can see the document or Your timetable as it will look in the printout.
    • Compile F1 results clearly in an Excel table - Instructions

    Whether you run a prediction game or are just interested in F1. To see the results ...

The design of the schedule in Excel

  • Now mark the first ten complete lines in your timetable (left-click on 1 of line 1 and, while holding down the button, go down to 10).
  • Now click with the right in the document and with the left in the context menu on "Line height". Write "1,2" in the field and confirm with "OK".
  • Now mark the first seven complete columns in your timetable (left-click on the A of column 1 and, while holding down the button, go right to the G).
  • Now click with the right in the document and with the left in the context menu on "Column Width". Write "3,7" in the field and confirm with "OK".
  • Now select all cells on sheet one of the timetable (left-click on top of cell 1A and, while holding down the button, drag it down to cell 13G and release).
  • Now right-click in the selection, click on "Format cells" and switch to the "Frame" tab. Now click once on "inside" and on "outside".
  • Now start writing the days of the week in the timetable in row 1 from column 2 onwards.
  • This completes the basic structure of creating the timetable with Excel. With Excel you can also insert backgrounds, change colors, choose fonts, etc. - However, the explanation here would go beyond the scope.
  • While you are working on the timetable, do not forget to save it at regular intervals.
  • Have fun with your schedule created in Excel.

How helpful do you find this article?

click fraud protection