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:
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