Wednesday, 3 September 2025
29 C
Singapore
32.9 C
Thailand
19.1 C
Indonesia
28.2 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

Volvo unveils new XC70 plug-in hybrid with 124-mile electric range

Volvo unveils the XC70 plug-in hybrid, boasting a 124-mile electric range that offers long-distance capability and flexibility for everyday driving.

Bangkok Bank expands partnership with New Relic to boost mobile banking reliability

Bangkok Bank expands its New Relic partnership to enhance mobile banking reliability, achieving 90% uptime gains and faster recovery.

Hackers exploit hidden malware in images processed by AI chatbots

Researchers warn that hackers can conceal malicious prompts in AI-processed images, posing a significant security risk to multimodal systems.

Yooka-Replaylee remaster launches on consoles and PC on 9 October

Yooka-Replaylee launches on 9 October with digital and physical editions, Switch 2 full cartridge, enhancements, and a 30% upgrade discount.

ASUS introduces NUC 15 Performance mini PC in Singapore

ASUS launches the NUC 15 Performance mini PC in Singapore, offering Intel Core Ultra processors, RTX graphics, and Wi-Fi 7.

Amazon launches new AWS region in New Zealand

Amazon launches its first AWS infrastructure region in New Zealand, investing NZ$7.5b to boost jobs, cloud services, and sustainability.

Global Anti-Scam Summit Asia 2025 launches major initiatives to fight online fraud

Global Anti-Scam Summit Asia 2025 in Singapore unveils new initiatives to fight scams with technology, funding, and cross-border collaboration.

Google Play Games to introduce new profiles with stats and social features

Google is introducing new Play Games profiles on Android, featuring gaming stats, achievements, and social tools, rolling out from 23 September.

China enforces mandatory AI content labels on major social media platforms

China’s major social media platforms are now required to label AI-generated content under a new law aimed at curbing misinformation and enhancing oversight.

Related Articles

Popular Categories