How To Make A Table In Google Sheets

To create a table in Google Sheets, select the desired range of cells, click on the “Insert” tab, and choose the “Table” option.

Google Sheets is a powerful spreadsheet software that offers an array of features to help you organize and analyze your data effectively. One of the key functions that Google Sheets provides is the ability to create and edit tables. Tables are an excellent tool for structuring and visualizing data, making it easier to understand and work with. Whether you are a beginner or an experienced user, this blog post will guide you step-by-step on how to make a table in Google Sheets. So, let’s dive in and discover the wonders of creating tables in Google Sheets!

How To Make A Table In Google Sheets: Step-by-Step


Step 1: Open Google Sheets

To access Google Sheets, open your Google browser, go to the Google Sheets homepage, and either search for it or click on the 9-dot matrix on your Google home page and select “Sheets.”

Next Step

Step 2: Create a New Sheet

Once you’re on the Google Sheets homepage, simply locate and click on the “+”, green-colored button situated on the bottom right-hand corner of the page. This will initiate the creation of a new sheet for you to work on.

Next Step

Step 3: Highlight Cells

Start by determining the desired number of columns and rows for your table. Once decided, simply click and drag to select the corresponding number of cells on your newly created sheet.

Next Step

Step 4: Insert Table

This action will open a dialog box where you can specify the desired number of rows and columns for the table. Once entered, click “OK” to insert the table into the spreadsheet.

Next Step

Step 5: Customize the Table

A default table will be created for you. To customize the width and height of cells, simply click and drag the column headers. Input your data as needed and utilize the top toolbars to modify styles, formats, colors, and more.

Next Step

Step 6: Save Your Work

Google Sheets saves changes automatically, but to rename the file, click on “Untitled spreadsheet” at the top left, then enter your desired name.


In conclusion, Google Sheets provides a user-friendly and efficient platform for creating tables and organizing data. By following the steps mentioned in this guide, you can easily create a table in Google Sheets and make the most out of its powerful features. Whether you need to analyze data, collaborate with others, or simply organize information, Google Sheets has got you covered. So go ahead and start creating tables in Google Sheets to simplify your data management tasks and boost your productivity.

Table of Contents