How to Create a Table in Google Sheets (Step-by-Step)


This tutorial provides a step-by-step example of how to create beautiful tables in Google Sheets.

Step 1: Enter the Raw Data

First, let’s enter the raw values for some dataset:

Step 2: Format the Header

First, let’s make the header text bold and centered:

Step 3: Format the Columns

Next, we’ll format the values in the columns. As a rule of thumb, use the following formats:

Text: Align text values left.

Numbers: Align numbers center.

Our text columns are already left-aligned, so we’ll simply center-align the values in the points column:

Step 4: Use Alternating Colors

Next, we can format the table to use alternating colors.

Simply highlight all of our data, then click Format along the top ribbon, then click Alternating colors.

In the new window that appears, click any style that you’d like. We’ll choose the teal style:

Step 5: Add a Border

Lastly, we’ll add a border to every cell in our table.

Simply highlight all of our data, then click the Border button and click All borders:

Our table is complete:

How to create a table in Google Sheets

Additional Resources

How to Make a Box Plot in Google Sheets
How to Make a Bubble Chart in Google Sheets
How to Make a Pareto Chart in Google Sheets

Leave a Reply

Your email address will not be published.