In this article:

How to Make a Table in Google Sheets [Easiest Way 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 and trying our software for bill approvals.

Schedule a free automation consult
Learn more

Automate repetitive tasks with Lido

Save hours on repetitive and tedious work. Lido is a new spreadsheet that connects your spreadsheets, forms, PDFs, and email inbox.

Trigger
Action
Select trigger
When a cell value in Google Sheets changes
Check Google Sheets for today's date
When a new row is added to Google Sheets
On new Google Form submission
Send me a daily reminder
On new Typeform submission
When a cell value in database changes
Check database for today's date
When a new row is added in database
When a new HubSpot customer is created
Select action
ADDCALENDAREVENT
Creates a one- or multiple-day calendar event with optional attendees
ADDHUBSPOT
Adds an object to Hubspot
ADDSLACKCHANNEL
Create a Slack channel, and optionally add a topic or members
CALLURL
Makes any HTTP request
CREATEGOOGLEDOC
Replaces [@column_name] values in a Google Doc with the corresponding table row's values
CREATEPDF
Replaces [@column_name] values in a Google Doc with the corresponding table row's values, then export it as a PDF
FETCH
Makes any HTTP request and returns the response
INSERTROWS
Inserts given array below defined values in given worksheet
SENDGMAIL
Sends an email using your Google account
SENDOUTLOOK
Sends an email using your Microsoft Outlook account
SENDSLACK
Sends a Slack message
SENDSMS
Sends an SMS message using your Twilio account
UPDATECELL
Updates cells with given values
UPDATEHUBSPOT
Updates a property of a Hubspot object
Trigger is required
Action is required
Get started