How to Make a Block Schedule in Google Sheets Step by Step

To make a block schedule in Google Sheets, set up a grid with days across the top and time slots down the side, then label and format the cells for each activity. Start with a plan for your week and choose a time interval, such as 30 minutes. This guide is for Google Sheets in a web browser; Excel has similar spreadsheet tools, but its menu paths and some formatting options differ.

What You’ll Need

A Google account and access to Google Sheets in a web browser.
A rough list of activities, their durations, and the days and times they usually happen.
A preferred scheduling interval. Thirty-minute slots suit most routines; use 15-minute slots for more detailed planning or 60-minute slots for broad blocks.

You do not need a special template or add-on. A blank sheet is enough, and you can adjust the schedule later as your routine changes.

Step-by-Step

Create a new sheet and name it. Go to sheets.google.com, open a blank spreadsheet, and click the title at the top left to give it a useful name, such as Weekly Block Schedule. If you already have a spreadsheet open, use File > New > Spreadsheet. Keeping the schedule in a separate tab or file makes it easier to find and revise.
Choose the schedule period and layout. For a weekly routine, use one column for the time and one column per day. In A1, enter Time; in B1 through F1, enter Monday through Friday. Add Saturday and Sunday in G1 and H1 if you want a full week. If you only need to plan one day, use one activity column instead. Use a weekly view for recurring commitments and consider creating a separate tab for a different week or project, rather than squeezing unrelated plans into the same grid.
Set the time range and interval. Decide when the day begins and ends before filling the grid. For example, a weekday schedule from 8:00 AM to 6:00 PM in 30-minute intervals needs 20 time rows. Enter 8:00 AM in A2 and 8:30 AM in A3, then continue the pattern down column A until you reach the final start time, 5:30 PM. The last slot then represents 5:30–6:00 PM. To generate the next time from the previous one, with A2 containing 8:00 AM, enter =A2+TIME(0,30,0) in A3 and fill it down. A3 should display 8:30 AM; format the cells as times using Format > Number > Time if they appear as decimals or dates. For 15-minute slots, replace 30 with 15 in the formula.
Make the grid easy to read. Select row 1 and use the toolbar’s bold button and fill color to distinguish the headings. Widen column A enough to show the times, then make the day columns wide enough for short activity labels. You can drag the boundary between column letters to resize a column. Select the schedule area and use the borders button on the toolbar to add light grid lines. Keep the time column visually distinct from the activity columns so a reader can scan from a time to a day without losing their place.
Freeze the headings and time column. Keep labels visible while scrolling. To freeze the first row, choose View > Freeze > 1 row. To freeze the time column as well, choose View > Freeze > 1 column. Check that the horizontal and vertical frozen areas meet at the top-left of the schedule. This is especially useful when you have many time slots or include a weekend. If you later add title rows above the day headings, revisit the freeze setting so it locks the row that actually contains your headings.
Enter activities in the appropriate slots. Put the activity name in the cell where that block begins. For example, if Monday planning runs from 9:00 to 10:30, locate the Monday column and the row starting at 9:00, and enter Planning. If you use 30-minute rows, the block covers three slots. Add specific labels such as Focus work, Lunch, or Commute rather than vague entries such as Busy. If an activity is flexible, mark it as a buffer or movable block so you do not mistake it for a fixed appointment.
Show each block’s duration clearly. One option is to enter the activity name in the first slot and leave the following slots blank, applying the same background color across all the slots in that block. Another option is to select the adjoining cells for one activity and use Format > Merge cells > Merge vertically. Use merging sparingly: merge only cells within one day column, and never merge cells that contain separate information you need to keep. If the activity changes duration often, colored unmerged slots are easier to edit. For merged blocks, leave the text in the top cell before merging so the label remains visible.
Use color consistently and add helpful details. Apply fill colors with the toolbar, assigning one color to each category, such as work, personal time, meals, and appointments. Use the same category colors throughout the week and add a small legend below or beside the schedule. Keep text readable against the fill; avoid combining a dark background with dark text. If you want a note about a particular commitment, select its cell and use Insert > Comment or Insert > Note, depending on whether you need a discussion thread or a simple reminder.
Review the schedule and test a change. Check that every activity starts on the correct row, that the final time slot ends when intended, and that overlapping commitments are not hidden in the same cell. Try changing one activity’s duration or moving it to another day. If you used merged cells, unmerge and reapply the formatting as needed. Finally, check the sheet at a normal zoom level and confirm labels are not clipped. Google Sheets saves changes automatically while you are online, but make sure the file name and account are correct before sharing it.

Common Mistakes

Mixing interval lengths. A grid with mostly 30-minute rows and a few 60-minute rows is difficult to scan. Choose one interval for the whole schedule, or make the different length obvious with a label and consistent visual treatment.
Using too many colors. If every activity has a different shade, the colors stop communicating useful categories. Start with a small set and include a legend. Use text labels too, so the schedule remains understandable if printed in grayscale or viewed by someone who cannot distinguish the colors.
Merging cells before entering details. Merging can discard content from all but the upper-left cell of a selected range. Enter the label first, confirm the selection contains only one activity, and merge only after checking the range. If you need to sort or reuse the data, avoid merging entirely.
Forgetting transition time. Scheduling one meeting directly after another can leave no time to walk, reset, or prepare. Add explicit buffer slots where transitions matter instead of assuming activities will end exactly on time.
Making the schedule too rigid. A block schedule is a plan, not a record of every minute. Leaving unscheduled capacity for urgent tasks, breaks, and overruns makes the plan more usable than filling every cell.

Tips

Keep the schedule focused on decisions you need to make. A weekly overview usually needs activity labels and times, not lengthy explanations inside every cell. Put extra context in a note or a separate details tab. If you share the sheet with other people, agree on what the colors mean and whether they can edit the schedule or should only view it.

Consider giving the schedule a clear title in a row above the grid, such as Week of November 9, and recording the date range. If you add a title row, adjust the frozen rows so the day headings remain visible. For a recurring schedule, duplicate the tab using the small arrow on its tab and choose Duplicate, then update the copy rather than rebuilding the layout. Keep one version as a clean template if you expect to make a new schedule regularly.

Use text that fits the cell, such as Deep work or School pickup, and avoid relying on color alone. For a printout, select the relevant cells and use File > Print to review the layout. In the print settings, check orientation, scale, and margins so the whole week is legible. You can also use conditional formatting for rules-based highlighting through Format > Conditional formatting, but ordinary fill colors are simpler when you are assigning categories manually.

When a block changes, update both its label and its occupied slots. For example, if a two-hour work session becomes a one-hour session, clear the unused hour and remove its fill color. Otherwise the old formatting can make an empty cell look reserved. If you want to retain a record of changes, add a separate notes tab rather than cluttering the current week.

Troubleshooting

The time formula shows a number instead of a time. Select the time cells and choose Format > Number > Time. If the result is still unexpected, check that the starting cell contains a time value, not text typed with an extra apostrophe or unusual spacing.
The times skip or repeat. Check that you filled the formula down from the correct starting cell and that the increment matches your chosen interval. For 30-minute slots, the formula should add 30 minutes each row. If you typed times manually, compare several consecutive rows and correct the first incorrect entry before continuing.
A merged block hides a label or cannot be edited as expected. Select the merged range and choose Format > Merge cells > Unmerge. Put the label in the top cell, clear any unwanted values in the other cells, and merge again only if the range belongs to one activity. To keep separate labels, leave the cells unmerged.
Headings disappear when you scroll. Reapply the freeze options under View > Freeze. Freeze the row containing the day names and the column containing the times; if your layout has title rows, choose the appropriate number of rows rather than assuming the headings are in row 1.
Colors or borders appear inconsistent. Select the affected range and use the toolbar to reapply the fill or border. If pasted content brought unwanted styling, use Edit > Paste special > Values only when copying data, or use the toolbar’s fill color to reset the appearance. Check that you selected the entire block, not just its first slot.
You cannot edit or share the file. Confirm you are signed in to the account that owns the sheet and that you have edit access. If someone else shared it with you, ask the owner to change your permission. Avoid publishing a personal schedule publicly; share it only with the people who need access.

Frequently Asked Questions

What is a block schedule?
A block schedule divides a day or week into time periods and assigns each period to an activity or category. Unlike a simple to-do list, it shows when you plan to do each task and how long you have allocated.

Should I use 15-, 30-, or 60-minute blocks?
Choose the shortest interval you genuinely need. Thirty minutes is a practical starting point for a general weekly plan. Use 15-minute slots for closely timed commitments and 60-minute slots when broad categories are enough; shorter slots create more rows to maintain.

Can Google Sheets calculate the time slots automatically?
Yes. If A2 contains the first time, enter =A2+TIME(0,30,0) in A3 and fill the formula down to create 30-minute steps. Format the results as time using Format > Number > Time. Change the minutes in the formula to match your chosen interval.

Do I have to merge cells to show a long activity?
No. You can fill several adjacent cells with the same color and put the activity label in the first one. This is often easier to edit and keeps the grid structured. Merge cells only when you prefer one continuous label area and do not need separate cell values.

Can I make one schedule for several people?
Yes. Add a separate tab for each person, or add a row or column that identifies the person if the group is small. Agree on shared color meanings and edit permissions, and avoid putting private details in a sheet that has broad access.

Will this schedule work in Excel too?
The basic grid and time-slot idea works in Excel, but the menu labels and some actions differ. This guide gives Google Sheets browser paths, such as Format > Merge cells; use the corresponding Excel commands if you recreate the schedule in Excel.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.