Tuesday, 16 September 2025
27.3 C
Singapore
26.9 C
Thailand
19 C
Indonesia
27.1 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

Sony showcases connected media ecosystem at IBC 2025

Sony highlights advanced media production tools and sustainable innovation at IBC 2025, showcasing AI, cloud, and virtual production.

OpenAI set to develop its own AI chips in 2025

OpenAI is reportedly set to develop its own AI chips with Broadcom in 2025, aiming to reduce reliance on NVIDIA and expand capacity.

Cisco unveils agentic AI-powered Splunk Observability for real-time insights

Cisco introduces agentic AI-powered Splunk Observability, providing enterprises with real-time insights and stronger digital resilience.

Young Singapore inventor wins James Dyson Award for diabetes innovation

NUS graduate Zoey Chan wins James Dyson Award 2025 in Singapore for nido, a tool designed to simplify daily insulin injections.

NVIDIA Blackwell Ultra sets new benchmark in MLPerf inference tests

NVIDIA’s Blackwell Ultra architecture sets new records in MLPerf Inference v5.1, boosting AI performance and reducing costs for enterprises.

Biwin unveils Mini SSD, a tiny storage device that could replace microSD cards

Biwin launches Mini SSD, a tiny yet powerful storage device that could replace microSD cards if industry standards are adopted.

Apple brings major upgrades to Powerbeats Pro 2 with iOS 26

Apple adds heart rate, fitness, and smart usability upgrades to Powerbeats Pro 2 with iOS 26, launching on 15 September.

UltraGreen.ai secures US$188 million anchor investment at US$1.3 billion valuation

UltraGreen.ai secures US$188 million anchor investment led by 65EP, Vitruvian, and August, valuing the firm at US$1.3 billion.

ConnectingDNA launches AI-powered DNA wellness marketplace in Singapore

ConnectingDNA launches the world’s first AI-powered DNA wellness marketplace in Singapore, offering personalised health insights and secure data protection.

Related Articles

Popular Categories