In this article:

How to Make a Table in Google Sheets [Easiest Way 2024]

May 8, 2024

In this article we will show you how to make a table in google sheets in just a few simple steps from your spreadsheet data.

For the purpose of this demonstration an example data set has been created, access and follow along by clicking this link.

How to Create a Table in Google Sheets

In this example we will show you how to create a table in just a few simple steps. We will use the example data set containing numbers, months, active status and financial values below to demonstrate this.

How to make a table in Google Sheets

1. Highlight the Header Row for the Table

Click on the first cell of the header row and then drag the cursor over the rest of the required cells to highlight them.

In this example we will highlight cells A3 to D3. 

How to create a table in Google Sheets

2. Apply Bold Formatting to the Table Header

Make the text in the header row bold by selecting it and clicking the B icon in the toolbar. 

Other options that can be applied to text include changing the color, italic or strike through.

create table in Google Sheets

3. Apply Text Wrapping to the Header Text

Text wrapping keeps the values of a cell contained in a tidy and uniform way, while displaying all of the information within. 

With the header cells still highlighted, wrap the contents of the cell values to remove overflow by first clicking the Text wrapping icon then from the dropdown the Wrap option. 

How to make table in Google Sheets

The cells have been resized to accommodate the values within, but only the text in cell D3 is long enough to wrap.

Google Sheets table format

4. Center the Values of the Header Cells using the Toolbar 

Highlight the required text to center. click the Horizontal align icon in the toolbar and then click the Center icon.

How to make a table on Google Sheets

The values in the highlighted cells have now been centered. 

How to make table in Google Sheets

5. Apply Alternating Colors by Clicking “Format” followed by “Alternating colors”

Select and highlight the whole data set. In the toolbar click Format and in the dropdown select Alternating colors 

Format as table Google Sheets

The alternating colors have been applied and the header has automatically been assigned a bold color to stand out from the rest of the data set. 

The sidebar can be used to select custom colors that can be applied to the entire data set, including headers and footers. 

Create a table in Google Sheets

6. Formatting Data as a Currency 

You can now apply additional formatting to your dataset. For our example we will format the data in column D as a currency.

In our example we have highlighted the cells D4 to D11, omitting The header cell of D3. With the data highlighted, in the toolbar click the dollar symbol $.

Format as table Google Sheets

The currency format has now been applied to the values of column D. 

The currency section of the toolbar offers many options to customize your data. Decimal points can be moved and further options can be found in the 123 icon including the option to change the currency type.

Format as table Google Sheets

7. Center the Values of Cells using the Toolbar 

Highlight the range of cells you want to center and click the Horizontal align icon from the toolbar followed by clicking the Center icon from the drop down. 

In our example below we have highlighted the cell range A4:C11.

Format as table Google Sheets

The data has now been aligned to the center of each cell.

Create a table in Google Sheets

8. Create a Border around the Table by Clicking Borders in the Toolbar 

Highlight the entire dataset and Click the Borders Icon in the toolbar. From the drop down menu select Outer Borders.

How to make table in Google Sheets

The table now has a border surrounding it.

Google Sheets create table

To distinguish the header from the rest of the data set, highlight the header row and from the toolbar click Borders. In the dropdown options click Bottom border

Format as table Google Sheets

9. Your Table has Now Been Created and Formatted 

The data set is now contained in a complete table.

Create table in Google Sheets

We hope this article has helped you and given you a better understanding of how to make a table in Google Sheets. You might also like our articles on how to add error bars in Google Sheets and how to share Google Sheets.

To optimize your workflow, we recommend reading our guide on how to use data validation for email address in Google Sheets.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->