Tables in Google Sheets [2024 update]

  Рет қаралды 12,542

Eamonn Cottrell

Eamonn Cottrell

Күн бұрын

Пікірлер: 47
@EamonnCottrell
@EamonnCottrell 7 ай бұрын
⭐⭐Grab the FREE demo sheet I used here - www.gotsheet.xyz/c/tables-in-google-sheets-2024
@MelissaWhaley-RTeam
@MelissaWhaley-RTeam 7 ай бұрын
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.
@EamonnCottrell
@EamonnCottrell 7 ай бұрын
yay!
@Lizi-v9d
@Lizi-v9d Ай бұрын
Hi is there particular formula to collate data from a drop down column + currency column into a column on a 'List Tab'? thanks
@EamonnCottrell
@EamonnCottrell Ай бұрын
Do you just need to concatenate the data from two columns? The simplest way would be to use the & operator and type out =col1&col2. You could add a space or any other manually added item like this: =col1&" "&col2. Share your sheet with me if this is not what you're talking about and you need me to take a look (my full name at gmail)
@albertyanezii3509
@albertyanezii3509 Ай бұрын
How to I add rows under to table that arent actually included within the table. For example if I wanted maybe another table under, or just blank cells with no formatting? I can't seem to figure it out without adding more of the original table itself
@EamonnCottrell
@EamonnCottrell Ай бұрын
Oh yeah, it's a little quirky. If you type anything in the next row, it will automatically think you want it to be in the table. Skip one row and leave a blank row between where you're typing and the end of the table above. Alternatively, you can manually adjust the table range by clicking the little dropdown arrow in the top left next to the table's name. That way if you did accidentally add a bunch of rows, you can just adjust the table range and make those rows normal rows.
@albertyanezii3509
@albertyanezii3509 Ай бұрын
Thank you! Appreciate it so much!
@NaftuliSinger
@NaftuliSinger 4 ай бұрын
Finally Google!
@t.wilson
@t.wilson 7 ай бұрын
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.
@EamonnCottrell
@EamonnCottrell 7 ай бұрын
Oh nice! This is good to know, thanks!
@EastTactics
@EastTactics 3 ай бұрын
Is there no way to insert colum totals and subtotals into these new tables?
@EamonnCottrell
@EamonnCottrell 3 ай бұрын
Surprisingly, no, there doesn't seem to be a way to automatically add this. Weird. If you use the sum or subtotal formula in the bottom row, it will automatically recognize that you want a total row and format a double thin line above that. I imagine this will be patched in in the future.
@katdasilva1599
@katdasilva1599 3 ай бұрын
I see a tab at the top left of the table - does this mean I can add another tab to this table? On the same sheets tab?
@EamonnCottrell
@EamonnCottrell 3 ай бұрын
Good question. I wondered about that too. But no, it’s just for appearance as far as I can tell.
@katdasilva1599
@katdasilva1599 2 ай бұрын
@@EamonnCottrell thanks for the reply! very helpful when questions are actually answered. And yes, I've googled this many times - didn't find anything that worked. Actually found misleading information. Thanks again!
@EamonnCottrell
@EamonnCottrell 2 ай бұрын
@@katdasilva1599 Sure thing!
@rachelgoettsch5175
@rachelgoettsch5175 7 ай бұрын
Is there a way to add a sum row at the bottom of the table?
@EamonnCottrell
@EamonnCottrell 7 ай бұрын
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.
@jesperjohansen6265
@jesperjohansen6265 7 ай бұрын
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?
@EamonnCottrell
@EamonnCottrell 7 ай бұрын
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
@coleywoowah2008
@coleywoowah2008 3 ай бұрын
Im trying to turn my data into a table and it says "You cannot convert an alternating colour range without a header format into a table please specify one and try again" and i cant figure out how to fix it please help me if you know what is happening
@EamonnCottrell
@EamonnCottrell 3 ай бұрын
That is weird. Apparently, you have to do one of two things: either check the "header" box in the alternating colors sidebar for that range OR remove the alternating colors before selecting convert to a table. Not sure why it throws an error in the first place when there's not a header row defined in the alternate colors format, but I tested it and got it resolved in both of those ways.
@coleywoowah2008
@coleywoowah2008 3 ай бұрын
@@EamonnCottrell managed to figure it out after a while yesterday turns out I had changes the colours back but it still had the alternating colours in that area just didn't look like it but thank you
@EamonnCottrell
@EamonnCottrell 3 ай бұрын
@@coleywoowah2008 Awesome; glad you're in business 👍👍
@dwolfram2866
@dwolfram2866 5 ай бұрын
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.
@EamonnCottrell
@EamonnCottrell 5 ай бұрын
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.
@redmediadesigns3769
@redmediadesigns3769 6 ай бұрын
Hello Do you offer custom sheets that I want to create for my business. If so how much?
@EamonnCottrell
@EamonnCottrell 6 ай бұрын
shoot me an email - my full name at gmail
@luannguyen2203
@luannguyen2203 6 ай бұрын
can we insert more than 1 table into 1 tab sheet?
@EamonnCottrell
@EamonnCottrell 6 ай бұрын
Yes!
@AdamLundquist
@AdamLundquist 7 ай бұрын
Is there a way to insert a table into a google doc
@EamonnCottrell
@EamonnCottrell 7 ай бұрын
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
@guapshonen
@guapshonen 6 ай бұрын
Hey @eamonncottrell thanks for the video. How would you compare this to clickup?
@EamonnCottrell
@EamonnCottrell 6 ай бұрын
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
@Jess-T
@Jess-T 6 ай бұрын
I didn't realise they were so new ... I've already sent my suggestions to Google on how to improve them 😂
@EamonnCottrell
@EamonnCottrell 6 ай бұрын
yeah, lol, def room for improvement
@sumantadass
@sumantadass 5 ай бұрын
Thanks, Man. This Video is better than other lenthy Videos. It cleared all my doubts. Love From India❤❤.
@EamonnCottrell
@EamonnCottrell 5 ай бұрын
Right on! Glad to help out. Have a great one!
@MattTemes
@MattTemes Ай бұрын
Worst update ever. Forms forces this feature on every response sheet and doesn't allow edits unless you re-link the sheet. and re-linking deletes and resets all responses. They need to include a way to opt out of this mess altogether before forcing it on us, absolute mess.
@EamonnCottrell
@EamonnCottrell Ай бұрын
I haven’t had issues with the linked form sheets yet. What’s it doing for you? Not letting you edit the sheet at all?
@silvestrecamposano6317
@silvestrecamposano6317 7 ай бұрын
Thank you!...
@EamonnCottrell
@EamonnCottrell 7 ай бұрын
You're welcome!
@sheet-chat
@sheet-chat 4 ай бұрын
Thank you for your video; it is excellent. I have developed an AI assistant that can support both Google and Microsoft platforms. I look forward to further collaboration with you. 🎥✨
@imjustprism
@imjustprism Ай бұрын
the popup just dont show for me, everything made by google is broken and trash
@EamonnCottrell
@EamonnCottrell Ай бұрын
If it goes away, you can find it under Insert - Tables
10 INCREDIBLE things Google Sheets can do Right Now!
13:27
Jeff Su
Рет қаралды 89 М.
Google Sheets Tables & Formulas
16:22
Learn Google Sheets & Excel Spreadsheets
Рет қаралды 19 М.
Andro, ELMAN, TONI, MONA - Зари (Official Music Video)
2:50
RAAVA MUSIC
Рет қаралды 2 МЛН
$1 vs $500,000 Plane Ticket!
12:20
MrBeast
Рет қаралды 122 МЛН
Microsoft Excel vs Google Sheets Tables [NEW for 2024]
21:03
Eamonn Cottrell
Рет қаралды 3,5 М.
Is Google Sheets' New Structured Tables Feature Any Good?
8:38
This Simple File Management System Changed My Life!
9:27
Jeff Su
Рет қаралды 1,6 МЛН
Structured tables for Google Sheets
18:44
David Benaim
Рет қаралды 10 М.
Try The DGET Function Instead of INDEXMATCH & XLOOKUP
12:29
Kenji Explains
Рет қаралды 134 М.
How to Make a Project Task Manager in Google Sheets
14:43
Spreadsheet Life
Рет қаралды 2 М.
✨ Google Sheets Introduces Tables
7:27
Dan Leeman
Рет қаралды 57 М.
Google sheets have some killer hidden features
9:18
Bog
Рет қаралды 21 М.
Top 5 Features in Google Sheets for Advanced Users
9:29
Learn Google Sheets & Excel Spreadsheets
Рет қаралды 95 М.
Your Simple Guide to Using NEW Tables in Google Sheets 2024!
16:26
Sharon's Tutorials
Рет қаралды 6 М.