Kick off the new school year with lessons from our Back to School 2022 collection to help students express themselves, build relationships, and stay organized.

Format Your Spreadsheet

Playback Speed:

In this video, you will learn how to use formatting tools to make the information in your spreadsheet clearer and easier to understand. Formatting can help highlight important data, making it easier to locate what you’re looking for.

In this extension, you will: Add borders to your table, Add shading to cells, Change the text color in cells, And freeze a row.

Borders in a spreadsheet can serve a variety of purposes. They can be used to represent the outer edge of a table, separate sections within a table from each other, or separate individual cells from one another. Select the cells you want to place a border around. Then choose the type of border you want and the line thickness.

Include more than one type of border in a spreadsheet to further organize the information.

Shading and text color can also be used to highlight important information or differentiate types of data from one another. To begin, select cells that contain important information and shade them. You might choose to shade a row of headers to make them stand out, for example.

Shade the rows in between data sets for different careers to help visually separate the information.

Now change the color of any text you’d like to emphasize. You might use a different text color for totals or important labels to call the reader’s attention to them, for example.

You can also bold text to highlight it further.

Freeze rows to make your headers visible even when you scroll down through the spreadsheet.

This is useful if you want to add multiple sets of career research to your spreadsheet.

Use formatting tools in your spreadsheet to make it easier for you to organize and highlight important information, both for yourself and for others.

Now, it’s your turn: Add borders to your table, Add shading to cells, Change the text color in cells, And freeze a row.

Choose an Extension
Format Your Spreadsheet

Use formatting tools such as borders, shading, and text color to further organize the information in your spreadsheet.

Create a Chart to Compare Job Outlooks

Create a chart to compare the projected growth rates of one of the careers you researched.

Add a Table to Summarize Research Results

Add a table to summarize the data you researched about different careers.