Skip to main content

This new Google Sheets feature is going to save so much time

Google Sheets is open in the Safari browser on a MacBook Air.
Digital Trends

After Google I/O 2024, Google continues to roll out features that bolster its productivity apps — this time, specifically with Google Sheets. As picked up by The Verge, Google has announced a much simpler way to generate easily formatted tables in the Sheets app. This new Sheets feature has been around for many years in Excel and has recently reached Google. Better late than never.

The option is called Convert to table, and you can use it by opening a Sheets document and clicking Format > Convert to table when the option reaches you later this month or early next. With this new option, Google aims for a more Excel-type experience by adding filters for each column. The rows also get visual separators, saving you time by not having to select the rows manually to turn them gray. The Convert to table feature also brings filters and column types and makes the drop-down menu creation easier.

Google

You can also add table menus, allowing you to design certain combinations of filters for the entire table or adapt the area it covers. A new view option, Create group by view, will let you add data in groups separated by their column filters. This means if you have a priority-level filter, you can put it in different groups for better organization, such as group one, group two, and so on.

Recommended Videos

Furthermore, you can also count on table templates for things such as event planning, project management, and other options Google threw in there.

Before you try to use the new feature, there is a chance it’s not there since some users will have it by May 30, but it should be available worldwide by June 6.

Judy Sanhz
Judy Sanhz is a Digital Trends computing writer covering all computing news. Loves all operating systems and devices.
Google gives Gemini a boost in Sheets and a cool trick in NotebookLM
Working with Google Gemini in Sheets.

Google is expanding Gemini integration within its Workspace suite and has announced a couple of new tricks for its underrated NotebookLM tool. The first in line is the ability to create structured tables in Google Sheets with text prompts.

So far, all tables created by the AI were served in plain text with only bold highlights for the headers. Needless to say, they looked drab and boring, lacking any character at all. There was no text formatting or stylistic edits to the cell contents.

Read more
This new Android phone could give the Google Pixel 8a a run for its money
Infinix Zero 40 5G.

Here in the United States, we have access to a lot of different phones -- but we're missing out on many of the best bang-for-your-buck budget devices available in other parts of the world. The launch of the Infinix Zero 40 5G is yet another reminder of low- or midrange phones that never see a Western release, especially since it would be a solid competitor to the Google Pixel 8a.

The Infinix Zero 40 5G has a lot going for it, especially considering it costs around $335 to $370 depending on your configuration (versus the current sale price of $399 for the Pixel 8a.) It even has a feature I've never seen in another phone: a GoPro mode. Just look at how travelers can use it to control their cameras.

Read more
Google Search has a new way of preserving internet history
Google logo at the company's campus in California.

After retiring cached results at the start of the year, Google is now, as reported by The Verge, adding embedded Internet Archive links to search results so we can still view older versions of websites.

You'll find the new Wayback Machine links right where the cached links used to be by clicking the three dots next to a link in the results and selecting "More about this page." The option to "See previous versions on Internet Archive" should be at the bottom of the page. Changes to the search engine can take a while to consistently show up for everyone, so keep checking back if you can't see it yet.

Read more