Table of Contents
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.
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:
