Skip to main content

Transcript

In this video, you will add column headings to your spreadsheet for other important details.

Then, you will format the headers and add details for the documents you'll need to gather or request from others.

To begin, add column headings to your spreadsheet to help you organize the documents you will need to collect for the FAFSA.

Next to the documents column, create a new column for who you will contact for each document.

Then, create a column label for the status of your documents.

And create a column label for links to your documents.

In a later video, you will insert a link to a document you have uploaded to Google Drive.

Format your spreadsheet to make certain information stand out.

Bold your headers like you did to your first column label.

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.

Then, select the entire sheet, and wrap the text.

Wrapping the text makes it stay visible within its cell, rather than being clipped or cut off.

Now, in the Contact column, write the name of the person you will need to request the document from.

For some of your documents, you might need to ask a parent or guardian for them, while for others, you might be responsible for providing the document.

You might also have to get information from elsewhere, like the bank or an employer.

Now, it's your turn: add headers to organize your documents, bold the headers freeze the header row, apply text wrapping, and write the name of the person you will request each document from in the Contact column.


Instructions

  1. Add headers to organize your documents.
  2. Bold the headers.
  3. Freeze the header row.
  4. Apply text wrapping.
  5. Write the name of the person you will request each document from, in the Contact column.