1
Click cell A1
Click cell A1 in an empty sheet.
How to make a schedule on Google Sheets
Lay out a weekly schedule with time slots down the side and days across the top.
Operations
2
Type the days
Type Time, then the days of the week, pressing Tab between them and Enter at the end.
3
Type the time slots and events
Type a time in column A of each row, then press Tab to reach the day and type the event.
4
Select the header row
Highlight the row with the days.
5
Click Bold
Click B in the toolbar to make the days stand out.
6
Click View
Open the View menu.
7
Click Freeze
Hover over Freeze.
8
Click 1 row
Choose 1 row so the days stay visible as you scroll.
9
Schedule ready
Fill in the rest of the week. Add a fill color to each type of event to read it at a glance.
Make this walkthrough your own
Duplicate this template, swap in your own screens, and share it with your team. Free to start — no credit card.