I just discovered this feature and it's going to be a game-changer for our team! Now I don't have to switch between google sheets and project management apps just to track things well.
Thank you for the video! Regarding changing data type in a column while filtered, you can see the "Column Menu" selection at the top of the filter pop-up. This will take you back to the pre-filter pop-up and you can change type while still filtered.
Thank you for this video. I've been trying to figure out how to add a new row to a formatted table. The prebuilt templates have the add 1000 rows, but when I create a table from previous data I can't figure out how to get that. In Excel, you just have to tab to get a new row, that is not working on my tables. I did notice for another table that if I just start typing in the new row and hit enter that will add it to the table, however on another table that I have the first cell in the row has a drop down and even if I type in something that is part of the dropdown, it does not recognize it. Any help would be appreciated.
They are rolling out some updates to this right now, actually. I've got options in my tables now (little plus signs) to add a row anywhere in my table as well as to add a column to the right of the table. You're right, though, it's not as smooth yet as Excel's. You can also select a column or row and then right click. You should have options to add columns or rows on either side of your selection from that right click menu.
Thanks for the video (and thank you Google for finally adding this). BUT how do I add new data easily? When I have cursor in bottom of a table (bottom/right - last cell of the table), when I hit Enter or Tab it does not create a new row to the table (as it does in Excel). Is there a shortcut I don't know of?
Yeah, that's an area that Google is still falling way behind with. I'm getting together a more in depth comparison between Excel and Sheets tables. And it looks like with Sheets, you still have to manually add additional rows rather than easily hitting enter like you can do in Excel
Yes, if you sum the values in a table column i.e. =SUM(budget[Cost per person]) in the row below the table, it will automatically become a part of the table.
I wouldn't really. I thought clickup was more of a project management/all-in-one platform. I haven't used it but I don't think it would be data analysis tool
Yes. you can copy it to a doc and even link them. Just select the table and paste it into docs. It'll pop up an option whether or not you want to link it so the Doc version can stay updated or not. I just recorded a short video on it - it'll be out next week
![Microsoft Excel vs Google Sheets Tables [NEW for 2024]](http://i.ytimg.com/vi/vBp5mveYZZ4/mqdefault.jpg)
![Microsoft Excel vs Google Sheets Tables [NEW for 2024]](/img/tr.png)
⭐⭐Grab the FREE demo sheet I used here - www.gotsheet.xyz/c/tables-in-google-sheets-2024
I just discovered this feature and it's going to be a game-changer for our team! Now I don't have to switch between google sheets and project management apps just to track things well.
yay!
Thank you for the video!
Regarding changing data type in a column while filtered, you can see the "Column Menu" selection at the top of the filter pop-up. This will take you back to the pre-filter pop-up and you can change type while still filtered.
Oh nice! This is good to know, thanks!
Thanks, Man. This Video is better than other lenthy Videos. It cleared all my doubts. Love From India❤❤.
Right on! Glad to help out. Have a great one!
I didn't realise they were so new ... I've already sent my suggestions to Google on how to improve them 😂
yeah, lol, def room for improvement
Thank you for this video. I've been trying to figure out how to add a new row to a formatted table. The prebuilt templates have the add 1000 rows, but when I create a table from previous data I can't figure out how to get that. In Excel, you just have to tab to get a new row, that is not working on my tables. I did notice for another table that if I just start typing in the new row and hit enter that will add it to the table, however on another table that I have the first cell in the row has a drop down and even if I type in something that is part of the dropdown, it does not recognize it. Any help would be appreciated.
They are rolling out some updates to this right now, actually. I've got options in my tables now (little plus signs) to add a row anywhere in my table as well as to add a column to the right of the table. You're right, though, it's not as smooth yet as Excel's.
You can also select a column or row and then right click. You should have options to add columns or rows on either side of your selection from that right click menu.
Thanks for the video (and thank you Google for finally adding this). BUT how do I add new data easily? When I have cursor in bottom of a table (bottom/right - last cell of the table), when I hit Enter or Tab it does not create a new row to the table (as it does in Excel). Is there a shortcut I don't know of?
Yeah, that's an area that Google is still falling way behind with. I'm getting together a more in depth comparison between Excel and Sheets tables. And it looks like with Sheets, you still have to manually add additional rows rather than easily hitting enter like you can do in Excel
Is there a way to add a sum row at the bottom of the table?
Yes, if you sum the values in a table column i.e. =SUM(budget[Cost per person]) in the row below the table, it will automatically become a part of the table.
Thank you!...
You're welcome!
can we insert more than 1 table into 1 tab sheet?
Yes!
Hey @eamonncottrell thanks for the video. How would you compare this to clickup?
I wouldn't really. I thought clickup was more of a project management/all-in-one platform. I haven't used it but I don't think it would be data analysis tool
Is there a way to insert a table into a google doc
Yes. you can copy it to a doc and even link them. Just select the table and paste it into docs. It'll pop up an option whether or not you want to link it so the Doc version can stay updated or not. I just recorded a short video on it - it'll be out next week
Hello Do you offer custom sheets that I want to create for my business. If so how much?
shoot me an email - my full name at gmail