Friday, 4 April 2025
29.3 C
Singapore
34.1 C
Thailand
27 C
Indonesia
27.3 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

Google’s Gemini 2.5 Pro AI model is now available for all users

Google's Gemini 2.5 Pro AI model is now available for all users, offering advanced coding and reasoning abilities with a free trial for Gemini Advanced.

Misconceptions about STEM careers continue to deter young women in Singapore

New research shows stereotypes and lack of support are deterring young women from STEM careers, posing a risk to Singaporeโ€™s innovation goals.

Microsoft removes Windows 11 loophole for skipping account setup

Microsoft is blocking a well-known workaround that lets you set up Windows 11 without a Microsoft account, enforcing stricter installation rules.

Informatica introduces new AI features to boost cloud data integration and management

Informatica adds AI tools to simplify data integration and improve enterprise access to AI-ready data across its cloud platform.

NUS partners with Microsoft Research Asia to advance AI research and nurture future tech talent

NUS and Microsoft Research Asia partner to boost AI research and develop future computing talent through a joint PhD and industry collaboration.

How ByteDance’s AI investment is reshaping the future of technology

ByteDance is investing US$12 billion in AI infrastructure for 2025 to enhance platforms like TikTok and drive innovation across industries, with a focus on acquiring AI chips globally.

Spotify introduces AI-powered ads and programmatic ad buying

Spotify unveils AI-powered ads and the Spotify Ad Exchange, making it easier for advertisers to reach Gen Z listeners with real-time bidding.

YouTube expands shopping affiliate programme in Singapore through Shopee partnership

YouTube teams up with Shopee to launch its Shopping affiliate programme in Singapore, giving creators new ways to monetise their content.

Misconceptions about STEM careers continue to deter young women in Singapore

New research shows stereotypes and lack of support are deterring young women from STEM careers, posing a risk to Singaporeโ€™s innovation goals.

Related Articles