Skip to content

Format Titles and Tables with Google Sheets

Playback Speed:

In this extension, you will format titles and tables in your spreadsheet using Google Sheets formatting tools.

Formatting makes your spreadsheet more interesting for your viewers and helps show your data more clearly.

To start, open your probability spreadsheet and make a copy.

Title it.

Then, create a title for the table you made.

Insert two rows above the table to make room for your title.

Type a title.

Merge the cells above your table.

Merging combines two or more cells into a single cell.

Next, center your title.

Make your title stand out by changing the font and size...

and making it bold.

Next, choose a font style.

Experiment with different fonts to pick your favorite.

Be as formal or as fun as you want.

Then, select a text color... and a fill color for your background.

Finally, put a border around the table.

Borders, just like text, may have different colors, sizes and designs.

Nice job!

You’ve added a lot of visual interest to your table.

Now you can clearly see the table of dice combinations -- and your data looks more interesting as well.

Continue experimenting with fill and text colors to emphasize different parts of your data.

Now, it’s your turn: Try out formatting options on the data in your spreadsheet, Then, create and format a title for the data in your sheet by merging cells; adding a title; and changing the font style, size, and color.

Choose an Extension
Illustrate Probability with Conditional Formatting
In this extension lesson, students illustrate probability data using conditional formatting in Google Sheets.
Create an Event Based on the Weather Forecast
Students use Google Search to find the weather forecast and then they create an event in Google Calendar.
Make a Table to Visualize Probability
Students visualize and solve a probability problem using a table in Google Sheets.
Learn the Law of Large Numbers
Students learn the law of large numbers and demonstrate the law using Google Sheets.
Format Titles and Tables with Google Sheets
Students learn how to enhance a spreadsheet by formatting titles and tables in Google Sheets.
Create a Batting Order Using Probability
Students create a batting order by analyzing and sorting probability data in Google Sheets.
See more extensions
Next Lessons Dashboard
Choose an extension from the list to continue learning ways to use Google Sheets to perform calculations.
Shared work attachment
URL not accepted. Please paste a link to a Scratch project. URL not accepted. Please paste a link from (such as a Google Doc). You don't appear to be signed in. Please refresh the page and try again. Something went wrong. Please refresh the page and try again.

This project will be shared with your teachers

Students can submit their work on this page. View their submitted work on the student progress page of My Classes.

Students can submit their work on this page.

Students: sign in to submit your work.
Teachers: sign in to view submitted work.