Thursday, 24 April 2025
30.6 C
Singapore
35.3 C
Thailand
27.8 C
Indonesia
28.8 C
Philippines

Google Sheets introduces one-click table formatting, delighting Excel switchers

Google Sheets' new feature allows one-click table formatting, streamlining data management, and exciting users familiar with Excel.

Google has unveiled a new formatting feature in Google Sheets that allows users to create neatly formatted tables with a single click—an enhancement long available in Excel. This update is particularly exciting for those who have managed complex spreadsheets over the years and is expected to streamline tasks significantly.

The new feature enables users to convert a block of data into a self-contained table equipped with its own filters and sorting rules. This is a significant improvement for long-time users like myself, who have maintained shared budget spreadsheets for years and previously had to set up filters and sort manually. The update simplifies these processes, allowing for quicker and more efficient data management.

Enhanced features and usability

Upon using this new feature, which can be accessed by selecting a block of data and clicking Format > Convert to Table, Google Sheets will automatically apply filters to each column and add visual separators to the rows. This eliminates the need for manually formatting each row, which is a common chore in spreadsheet management.

Additionally, the update introduces automatically formatted column types and simplifies the creation of drop-down menus. A new table menu also allows users to create specific filter combinations for the entire table or adjust the range of data it covers. Another notable addition is the “Create group by view” option, which organises data into groups based on column filters, such as priority levels.

Ready for rollout

Google has also tailored table templates for common tasks like project management, inventory management, and event planning, adding to the versatility of this feature. While the new tables feature is rolling out gradually, some users will see it by May 30th, with a complete roll-out expected by June 6th.

This update is part of Google’s ongoing efforts to enhance the user experience and functionality, making Google Sheets an increasingly powerful tool for personal and professional use.

Hot this week

Meta’s Oversight Board asks for clarity on new hate speech rules

Meta’s Oversight Board is urging more transparency on hate speech policy changes and urging the company to protect vulnerable users.

AMD’s RX 9070 GRE leak could bring welcome news for gamers

Leaked AMD’s RX 9070 GRE specs suggest a strong mid-range GPU with 12GB memory and fast clocks, perfect for modern gamers.

PlayStation Plus prices rise worldwide, including Singapore

PlayStation Plus subscription prices have increased worldwide, including Singapore, with changes affecting new and existing users.

Intel’s new CEO reshapes leadership, promotes AI chief and plans closer work with engineers

Intel CEO Lip-Bu Tan is reshaping leadership, promoting a new AI chief, and aiming for a leaner, more engineering-driven company.

ChatGPT joins forces with The Washington Post in new content partnership

OpenAI partners with The Washington Post to bring trusted news summaries to ChatGPT, offering better access to reliable information.

POCO launches entry-level C71 smartphone in Singapore with premium features

POCO launches the budget-friendly C71 smartphone in Singapore, offering premium design, enhanced cameras, and smooth performance at S$109.

NVIDIA uses AI to address climate, wildlife and disaster risks

NVIDIA’s AI tools support climate action, wildlife monitoring, and disaster risk mitigation, with uses spanning sea, land, sky and space.

Netflix raises subscription prices in Singapore again

Netflix again raises subscription prices in Singapore, with new rates for all plans and extra member slots.

GameMax unveils Blade Concept ATX case with bold design and powerful features

GameMax launches the Blade Concept ATX case, which features a striking blade design, RGB lighting, and support for high-end liquid-cooled PC builds.

Related Articles

Popular Categories