3. Add and Format Column Headers, Set Deadlines, and Add Notes

Playback Speed:

In this video, you will continue adding headers to the columns in your spreadsheet for other important project details, and then you will format the headers.

Then, you will type deadlines for the project’s tasks.

Formatting a spreadsheet by bolding text, freezing rows, and wrapping text helps make it easier to read and use.

To begin, get together with your group, and talk about all of the important aspects of your project.

Consider: Deadlines for each task, The status of each task, Who will be responsible for each task -- this person is called a task owner, And notes your group might want to add to your spreadsheet.

Then, select one person to add each of these items to your spreadsheet as headers.

You will fill in the information below the headers later.

Bold your headers to make them stand out more.

Next, freeze the header row.

Freezing the header row allows you to see your headers even when you scroll down through a very long list of information.

Another way to see all of the important information in your spreadsheet is by wrapping text.

When you wrap text, it stays visible within its cell, rather than being cut off.

If the columns are too narrow, you can resize them.

Now, assign a deadline for each task.

Then, add formatting to the deadline dates to make them look consistent.

This will make your spreadsheet easier to read.

You may want to add some notes about your project tasks.

Notes can help your group: remember an important detail communicate an idea and come up with new strategies to make your project successful.

Write at least five notes that correspond to the different tasks in the Notes column.

Using your spreadsheet in this way helps break down a complicated project into much more manageable steps.

Now it's your turn: Add important aspects of your project as headers, Bold and freeze the header row, Apply text wrapping, Adjust the width of the columns.

And add notes for at least five project tasks.


  1. Add important aspects of your project as headers.
  2. Bold and freeze the header row.
  3. Apply text wrapping.
  4. Adjust the width of the columns.
  5. Add notes for at least five project tasks.