Google Sheets finally adds the table formatting that Microsoft Excel had for years

There are also pre-built tables to choose from

2 min. read

Published onMay 16, 2024

published onMay 16, 2024

Share this article

Read our disclosure page to find out how can you help Windows Report sustain the editorial teamRead more

18 years and thousands of requests later, Google has finally added the much-needed table formatting in Sheets, its native spreadsheet application and a freeExcel alternative. It’s surprising that Google took so long to introduce the feature, which had been available in Excel for quite some time.

With table formatting finally available, you can seamlessly structure and format the rather unorganized data within seconds, according to apost by the Google Sheets team.

To convert a set of data into a table, select and highlight the data range > open theFormatmenu > chooseConvert to table.

When converted to a table, the data automatically appears in a more structured form, with separators to easily distinguish between the different rows and columns. And there’s much more to it, including column types, colour coding, filters, and dropdown menus, among other features.

Customizations like changing colours or readjusting row heights are effortless in tables on Sheets. Upon choosing a column type, all the entered data automatically assumes the formatting, and anything that doesn’t fit the formatting throws a warning. Besides, for more macro-level changes, you can directly adjust the table instead of individual rows and columns.

With the newCreate group by viewoption, you can sort the data into different sets based on values in a specific column. Not to forget, there are also pre-built table templates that you can start working on right away.

Table formatting in Google Sheets is being gradually rolled out and is not yet available for everyone. When I checked, it wasn’t there, but Google has confirmed that the feature should be available to all byJune 6, 2024!

If you like to keep up with developments at Google, discover all thenew features and tools announced during Google I/O.

Have you tried the table formatting in Google Sheets? If so, share your review with our readers in the comments section.

With KB5043178 to Release Preview Channel, Microsoft advises Windows 11 users to plug in when the battery is low#

Copilot in Outlook will generate personalized themes for you to customize the app#

Microsoft will raise the price of its 365 Suite to include AI capabilities#

Death Stranding Director’s Cut is now Xbox X|S at a huge discount#

Outlook will let users create custom account icons so they can tell their accounts apart easier#

Google Sheets finally adds the table formatting that Microsoft Excel had for years#

With KB5043178 to Release Preview Channel, Microsoft advises Windows 11 users to plug in when the battery is low

Copilot in Outlook will generate personalized themes for you to customize the app

Microsoft will raise the price of its 365 Suite to include AI capabilities

Death Stranding Director’s Cut is now Xbox X|S at a huge discount

Outlook will let users create custom account icons so they can tell their accounts apart easier

Google Sheets finally adds the table formatting that Microsoft Excel had for years