How To Insert Table In Google Sheets

How to insert table in google sheets

Google sheets is an online spreadsheet application that allows one to key in data and analyzes just like in Microsoft excel. Its advantage is that your data is automatically saved in google drive hence no risk of losing data even when the power goes off. Besides, it has more simplified formulas to do calculations and perform other activities. Furthermore, one can invite others to work on the spreadsheet with you. Also, it gives you the opportunity to make changes to the file without having to destroy the original document. When you are done making changes, you can simply download it where sheets is going to convert it back to excel files, ready to be used by Microsoft excel once again.

For those who might have been used to Microsoft excel where you only need to select data to be included in the table then click “CTRL+T” for Windows and “Apple +T” for MAC, or the Format as Table option in Excel standard toolbar, must find it challenging to insert Table in Google sheets since there is no direct option for Tables.

I will explain some simple steps to add a table in your google sheets data using the Pivot Tables method.


Steps for inserting a table in Google sheets

1. First, select the data you need to be included in the table.

072420 0757 Howtoinsert2

2. In the menu at the top toolbar, click ‘Data’ then select ‘Pivot Table’.

072420 0757 Howtoinsert3

3. Click create on the pop-up window that appears once you click on ‘Pivot table’.

072420 0757 Howtoinsert4

4. A new sheet opens up at the bottom of the screen as shown.

072420 0757 Howtoinsert5

5. Use the Pivot table editor window which pops up at the right side of the screen to edit your table.

072420 0757 Howtoinsert6

6. Click on rows and select what is to appear on the rows, Click on add Columns then choose what is to appear on the columns. Your table is created as per your editing desires.

072420 0757 Howtoinsert7