Creating a table in Google Sheets is a fundamental skill for organising and analysing data efficiently. Whether you’re a student, a professional, or someone who loves data, mastering this skill can greatly enhance your productivity. Google Sheets introduced a new tables feature in May 2024, aiming to streamline data organisation and management. This update particularly benefits those who frequently work with spreadsheets.
This article will guide you through creating a table in Google Sheets in a few simple and easy steps. You can watch the video below or continue reading the article.
Also read: How to lock cells in Google Sheets?
Creating a Blank table
To create a blank table in Google Sheets follow the steps below:
Step 1: Open the Google Sheets and click on the Insert tab.
Step 2: In the dropdown menu click on the Tables option.
Step 3: Now, on the right side of the screen you’ll see the pre-built tables offered by Google Sheets. Choose the type of table you want.
Step 4: To edit the table, click on the Down arrowhead beside the Event tasks at the top left corner of the table. Keep in mind this editing option might change its place depending on the type of table you choose.
Step 5: In the dropdown menu there are various options available, you can rename the table, adjust the table range, you can turn off alternating colours, customise table colours and you can also revert to unformatted data and also delete the table from here.
Step 6: If you want to edit the particular columns, click on the Down arrowhead in the column header.
Step 7: In the dropdown menu there are various options available; you can edit the column type, sort the column, filter the column, insert a new column and also you can delete the column from here.
Step 8: If you want to add more rows to the table enter the number of rows you want in the box at the bottom left of the table and click on the Add button.
Step 9: The number of rows you entered in the box will be added to your table.
Converting the data into a table
To convert the data into a table in Google Sheets follow the steps below:
Step 1: Open the worksheet in Google Sheet, select the data and click on the Format tab.
Step 2: In the dropdown menu, click on the Convert to table option.
Alternate step: Select the data, right-click and then in the dropdown menu click on the Convert to table option.
Step 3: Your data will be converted to a table.
You can effectively organise, analyse, and present your data by mastering tables in Google Sheets. With the new features, creating and managing tables has become even more streamlined, making Google Sheets an even more powerful tool for your data needs.
Also read: How to use Vlookup in Google Sheets?
