Making Tables in Google Sheets is Easy

Making Tables in Google Sheets is Easy

Tables make things easier, more readable, more manageable. In short, they’re a way to quickly organize your data in a spreadsheet.

No alt text provided for this image


In Google Sheets, unlike Excel, there is not a command to “make a table”. Instead, we can use a bit of formatting to do the same thing.

Let’s say we’ve got a table of movies like in the screenshot below.

No alt text provided for this image
screenshot of movie dataset

By selecting all the data and then clicking Format → Alternating Colors from the toolbar, we can create a more visually appealing table format.

No alt text provided for this image
screenshot of selecting alternating colors

There are several options to select from → you can elect to have a header row or not and then change the styling of the alternating row colors.

No alt text provided for this image
screenshot of setting up a table

Then by selecting the header row, we can choose the filter option from the toolbar to enable us to sort the data in the table however we wish.

No alt text provided for this image
screenshot of setting up a filter

Suppose we need to add some data. When we type the next line, it will automatically apply the table alternating color format to subsequent lines.

No alt text provided for this image
screenshot of adding data to table

Now, any time we need to reorganize the data, we can click the filter selectors in the headers and sort it however we need.

No alt text provided for this image
screenshot of filtering data

This won’t make you feel better about the state of popular cinema, but it will let you see your data more clearly and use it more effectively!

No alt text provided for this image
gif of boy saying he understands completely

Hope this is helpful for you! If you know someone who’d benefit from this newsletter, please forward them a copy.

Here's a video walkthrough of the whole process with a bigger movie dataset:


Find me over on YouTube here: https://www.youtube.com/@eamonncottrell

And of course, follow me on LinkedIn here: https://www.dhirubhai.net/in/eamonncottrell/

Have a great one!

要查看或添加评论,请登录

Eamonn Cottrell的更多文章

  • How to Use VBA

    How to Use VBA

    Create a Workbook Table of Contents I put off learning VBA for a long time. Like 10 years long.

    2 条评论
  • How to Use the IF function

    How to Use the IF function

    Don't let your spreadsheet intimidate you. We’re all familiar with the logic behind IF().

  • Apps Script Form Submission to Google Calendar

    Apps Script Form Submission to Google Calendar

    Since last we spoke I’ve… Set a new personal marathon record (3:14:30) Played some old school Zelda with my kids (SNES)…

    4 条评论
  • 6 Ways to Number in Excel

    6 Ways to Number in Excel

    Since last we spoke I’ve been recording several new long and short form videos. Check out the YouTube Channel if you…

  • Sort in a Cell

    Sort in a Cell

    Get these handy tips in your email by subscribing to my free newsletter at https://got-sheet.beehiiv.

    2 条评论
  • Apps Script All Day Events

    Apps Script All Day Events

    Since last we spoke I’ve made some short videos… Microsoft table breaks mobile view Combine Excel Data onto New Lines…

    2 条评论
  • Name Those Ranges

    Name Those Ranges

    Since last we spoke… It’s snowed 7+ inches at our house! The kids are in heaven. I’ve driven to Mississippi and back…

  • Double XLOOKUP

    Double XLOOKUP

    Since last we spoke I’ve… Run my first 5K in over a decade Run a 50K Started writing a book… Now to the sheets… Double…

  • Time Zones in Google Sheets

    Time Zones in Google Sheets

    Since last we spoke I’ve… Run 40 miles up and down Boring Road Built an open source memory verse website Hung Christmas…

  • Deck the Halls With QUERIES

    Deck the Halls With QUERIES

    Hi there! Since we last spoke I've Run a couple half marathons (of my own making) Analyzed a collectible card game that…

社区洞察

其他会员也浏览了