How to Create a Table in Google Sheets?

The ability to build tables in Google Sheets is a popular feature that gives the data an organized framework and makes analysis easier. Understanding how to create a table in Google Sheets is a useful skill that can improve productivity and streamline the workflow, whether you are a student, professional, or small company owner.

To help in organizing the data more effectively, we will walk you through the process of making tables in Google Sheets in this post.

How to Create a Table in Google Sheets?

To create the table, we will consider an example of the “Students Record” in the form of the table by following the below-mentioned steps. 

Step 1: Define the Header Row

First, define the header row for the data of the “Students Record” in the first row of the sheet:

Create a Table in Google Sheets 1

Now customize the header row by changing the font size, alignment, making it bold, and filling the cells with some color:

Create a Table in Google Sheets 2

Step 2: Insert the Data Following the Header Row

Insert the data following the header row to complete the information:

Create a Table in Google Sheets 4

Again format the data by setting the “Font Size”, “Align the data”, and “Filling the cells with color”:

Create a Table in Google Sheets 6

Step 3: Select the Data from the Table

Now with the help of the mouse, select all the data which is supposed to include in the table:

Create a Table in Google Sheets 5

Step 4: Make the Borders of the Tables

Choose the color of the border by clicking on the icon of the “Borders” and then click on the “Border Outline Color”

Create a Table in Google Sheets 7

Now choose the Borders for the selected data:

Create a Table in Google Sheets 8

The table has been created:

Create a Table in Google Sheets 9

How to Add the Formulas in the Table in Google Sheets?

To add the formula in the table in Google Sheets, define the formula in the first cell of the column:

Create a Table in Google Sheets 10

Press the ENTER key to apply the formula:

Create a Table in Google Sheets 11

Now select the cell and drag by holding it from the right bottom to the last cell for auto-filling the data:

Create a Table in Google Sheets 12

The formula is applied to all the selected cells in Google Sheets. 

How to Insert the CheckBox in the Table?

To insert the checkboxes in the table, select the column in which checkboxes are supposed to insert:

Create a Table in Google Sheets 13

Choose the “Tick box” from the dropdown menu that appears by clicking on the “Insert”:

Create a Table in Google Sheets 14

The checkboxes are inserted in the selected cells:

Create a Table in Google Sheets 16

Conclusion

To make a table in Google Sheets, select the cells and define the borders of the selected cells. Then define the header row in the first row of the table and insert data. Making the table in the Google Sheets is very easy as explained in this blog.