Tables in Google Sheets [2024 update]

Big News! REAL TABLES are now in Google Sheets. No more of this fake alternating colors jazz. We've got the real deal.

This has been a long time coming, and I'll walk you through the basics in a quick overview today.

We receive commission on purchases made through some links on this page
_______________________________________________

🎓Software Recommendations:

_______________________________________________
🎓Data Course Suggestions: (coursera)

_______________________________________________
🎓AI Course Suggestions: (coursera)

_______________________________________________

🖥️ Office items I can't live without:

📲 Find me
_______________________________________________
⌚Chapter Time Markers:
00:00:00 - Tables in Google Sheets!
00:00:35 - Insert Pre-built table
00:02:30 - View Options
00:03:29 - Filtering
00:04:07 - Removing Filters
00:04:34 - Change Column TYpes
00:05:12 - Using Tables Dynamically in Formulas
00:06:29 - Turn Data into Table

=============================
#exceltips #googlesheets #spreadsheets #dataanalytics #excel #productivity #gotsheet #howtousespreadsheets #getgoodatspreadsheets

[Lizi-vd]

Hi is there particular formula to collate data from a drop down column + currency column into a column on a 'List Tab'? thanks

[katdasilva]

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?

[rachelgoettsch]

Is there a way to add a sum row at the bottom of the table?

[EastTactics]

Is there no way to insert colum totals and subtotals into these new tables?

[MelissaWhaley-RTeam]

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.

[coleywoowah]

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

[dwolfram]

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.

[jesperjohansen]

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?

[t.wilson]

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.

[redmediadesigns]

Hello Do you offer custom sheets that I want to create for my business. If so how much?

[luannguyen]

can we insert more than 1 table into 1 tab sheet?

[guapshonen]

Hey @eamonncottrell thanks for the video. How would you compare this to clickup?

[AdamLundquist]

Is there a way to insert a table into a google doc

[sumantadass]

Thanks, Man. This Video is better than other lenthy Videos. It cleared all my doubts. Love From India❤❤.

[Jess-T]

I didn't realise they were so new ... I've already sent my suggestions to Google on how to improve them 😂

[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.

[sheet-chat]

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]

the popup just dont show for me, everything made by google is broken and trash