Skip to content

How to create a table in Google Sheets?

  • by
  • 4 min read

Google Sheets is a cloud-based spreadsheet program by Google, it lets its users create and edit spreadsheets directly on the web browser without the requirement of any special software. It is a part of the web-based free Google Docs Editors suite.

One of the best features of Google Sheets is that multiple users can work on the same spreadsheet at the same time and it also allows its users to share the spreadsheets with others and also manage the access each user has to the document.

In this guide, we have discussed how to create a table in Google Sheets to help you create one in a few simple and easy steps.

Also read: How to create a pie chart in Google Sheets?

Creating a table in Google Sheets

If you want to know how to create a table in your spreadsheet on Google Sheets then follow the steps below.

The spreadsheets in Google Sheets are already in tabular form so what you need to do is format your data in a way which makes the table in your Google Sheets look better. We have mentioned some common formatting tips that will make your data look better and easy to understand.

Edit the Header rows

Make your header rows bold and centre-align the value so that it stands out. It might be possible that the data in the table might exceed the screen view so you have to scroll, make sure that the header row is the first row in the Google sheet and then freeze it which will allow the header row to remain on top even if you scroll down to view the data. To know how to bold the text follow the step below.

Step: Select the header row and then click on the B icon in the toolbar.

Align data in the table

Aligning the data will make it look tidy. Although Google Sheets have default alignment for texts, numbers and dates, you can always change it according to your preferences. Centre aligning your data will make it look clean and easy to read the data. To know how to align the data in Google Sheets follow the step below.

Step: Select the data below the header and click on the Horizontal align icon in the toolbar and select the alignment you want for your data. Please refer to the image below, if you have any doubts.

Colour the text and background in columns and rows

You can use colours to highlight texts in rows and columns, If you want to highlight the text in a particular cell, row, column or whole sheet then you can use colours to make it stand out.


To know how to highlight text in a row or column or whole sheet then follow the step below.

Step: Select the data of the row and/or of the column and then click on the A icon with a bar below it and choose the colour you want to choose for the text.

Also read: How to merge cells in Google Sheets?


Akash Singh

Akash is a law graduate who likes to go for bike rides on the weekends soul-searching for answers to his many existential questions. You can contact him here: [email protected]