How to Make a Timetable in Excel (2026 Step-by-Step Tutorial)

Excel is the original spreadsheet timetable tool. If you're building a class schedule, project timetable, or work week, Excel does the job — once you get past the bit where you're trying to make 7 columns the same width while the merged title cell keeps fighting you.

This guide walks through the cleanest way to make a timetable in Excel and the few specific moves that turn a default spreadsheet into something you'd actually print. There's also a free .xlsx download at the end if you want to skip the setup.

Step 1: Plan the grid before you type

A weekly timetable is a 2D grid:

Rows are time slots (08:00, 09:00, 10:00, ...).
Columns are days (Mon, Tue, Wed, Thu, Fri, optionally Sat/Sun).
The top-left cell is usually labeled "Time".

So before you type anything, decide:

What days does your week cover? Mon-Fri only, Mon-Sat, or full Mon-Sun?
What's your time range? Most school timetables are 08:00–16:00. Office: 09:00–18:00. 24-hour: 00:00–23:00.
What's your slot interval? 30 minutes, 1 hour, 2 hours?

For a typical school week: Mon-Fri, 08:00–16:00, hourly = 5 day columns + 1 time column = 6 columns, and 9 rows for hours.

Step 2: Type the structure

Open Excel, start a new workbook. Then:

A1 → Title. Type "Weekly Timetable" and merge A1 across all columns (select A1:F1, click Merge & Center on the Home tab).
A2 → "Time". Type Time in A2.
B2:F2 → Day names. Type Mon, Tue, Wed, Thu, Fri in B2 through F2.
A3:A11 → Hour labels. Type 08:00 in A3, then drag the fill handle (the small square in the bottom-right of the selected cell) down through A11. Excel will auto-increment — but it might not. If it just repeats 08:00, type 08:00 in A3 and 09:00 in A4, select both, then drag the fill handle.

You now have a grid with a title, header row, and time column.

Step 3: Fix the column widths

This is the step everyone misses. Default Excel columns are too narrow for day-of-week labels and too uneven for a timetable to look professional.

Select columns B through F.
Right-click → Column Width → set to 18 (about 130 pixels).
Select column A.
Right-click → Column Width → set to 10.
Select rows 3 through 11.
Right-click → Row Height → set to 25 or 30 (depending on how much content you'll fit).

Equal column widths and equal row heights are what make a grid read as a calendar instead of a list.

Step 4: Style the header and title

Select row 2 (Time + day names). Apply:

Bold (Ctrl+B).
Center alignment (Home tab → Center).
A pale background fill (Home tab → Fill Color → light blue, light grey, or your team color).
A bottom border (Home tab → Borders → Bottom Border).

Select A1 (the title). Apply:

Bold, size 18.
Centered horizontally and vertically.

This single styling pass is what makes Excel timetables go from "raw spreadsheet" to "actual document".

Step 5: Add borders to all cells

Select A2:F11 (the whole grid). Then Home tab → Borders → All Borders. Now every cell has a thin border, which is what makes a timetable look like a timetable.

Step 6: Fill in your activities and color-code

Click any body cell (e.g. B3 for Monday at 08:00) and type. Two specific moves to make the grid actually useful:

Use cell fill colors to color-code by subject or category. Each color is a category — math is blue, English is red, lunch is grey. Color-coding is what makes a timetable scannable.
Merge cells for multi-hour activities. Select two adjacent cells (e.g. B3:B5 for a 3-hour lab), click Merge & Center. The activity name now spans 3 rows visually.

Also useful: Wrap text (Home tab → Wrap Text) so longer activity names don't overflow into the next day's column.

Step 7: Conditional formatting (optional, powerful)

Conditional formatting can flag conflicts automatically:

Select B3:F11 (your activity cells).
Home tab → Conditional Formatting → New Rule → Use a formula → =COUNTIF($B$3:$F$11, B3) > 1.
Set the format to red fill.

Now any activity name that appears in two different cells gets highlighted red. Useful for spotting accidentally-duplicated entries (or genuinely-double-booked time slots).

Step 8: Print on one page

This is where Excel timetables die — the default print spreads across two or three pages. The fix:

Page Layout tab → Orientation → Landscape.
Page Layout tab → Print Area → Set Print Area (after selecting your timetable range).
Page Layout tab → Width → 1 page, Height → 1 page (this is the "fit to page" option).
File → Print to preview.

If the print preview still looks cramped, increase column widths slightly until the grid uses the full page width.

Step 9: Save and share

Save as .xlsx for Excel users.
File → Save As → PDF for print or for sharing with non-Excel users.
Email or upload to OneDrive / Google Drive for collaboration.

The shortcut: download a clean .xlsx

The above takes around 15-20 minutes the first time you do it. Each subsequent timetable takes 5-10 minutes once you have a template saved.

Or you can download our free Excel timetable template right now — it's a clean .xlsx with the structure, styling, and grid already in place. Open it in Excel, type in your activities, save. The setup is already done.

If you want even less friction, our online weekly timetable maker skips Excel entirely — pick days and hours, fill in activities, export as PDF. About 2 minutes total.

FAQ

Why does my Excel timetable print on multiple pages? Set the print area to your grid range, then use Page Layout → Width: 1 page, Height: 1 page. Switch to landscape if your week is wider than tall.

How do I make a daily timetable in Excel? Same setup, but only one day column instead of seven. A simpler structure: hours in column A, activities in column B.

Can I add a multi-week schedule in one Excel file? Yes — use one sheet (tab) per week, or copy the grid down the same sheet with week labels. Tabs are usually cleaner.

What's the difference between making a timetable in Excel vs. Google Sheets? Excel is faster offline and has better formula support. Sheets is better for sharing and live collaboration. The grid setup is nearly identical in both.

Does Excel have built-in timetable templates? Yes — File → New → search "schedule" or "timetable". Quality varies; many are wedding-planning or project-Gantt formats, not weekly schedules.

Built it manually in Excel? Or grabbed our pre-made .xlsx. Both work — pick the one that matches your tolerance for column-width fiddling.

How to Make a Timetable in Excel (2026 Tutorial)