Wednesday, 19 February 2025
25.7 C
Singapore
24.4 C
Thailand
20.4 C
Indonesia
26.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

Crystalline Resonance: Final Fantasyโ€™s official piano concert returns to Singapore

Final Fantasyโ€™s official piano concert, Crystalline Resonance, returns to Singapore on February 19. Donโ€™t miss this magical night of live music!

Wacom unveils redesigned Intuos Pro drawing tablet

Wacom has redesigned its Intuos Pro drawing tablet, adding mechanical dials, a slimmer build, and a more compact layout for creative professionals.

DJI launches new Osmo Mobile 7 series with enhanced tracking and built-in tripod stands

Discover the new DJI Osmo Mobile 7 series, featuring improved tracking, stability, and gesture controls for smoother smartphone filming.

Western Digital outlines future strategy and AI growth at Investor Day 2025

Western Digital unveils its future strategy at Investor Day 2025, highlighting AI-driven storage demand and accelerating HAMR technology development.

WhatsApp is working on a feature to let you add social media profile links

WhatsApp is testing a feature that lets you add social media profile links to your account, improving integration with Instagram and other platforms.

Google updates Family Link to help kids stay focused

Google updates Family Link with improved screen time controls, school time features, and contact supervision, helping parents manage digital habits.

DJI launches new Osmo Mobile 7 series with enhanced tracking and built-in tripod stands

Discover the new DJI Osmo Mobile 7 series, featuring improved tracking, stability, and gesture controls for smoother smartphone filming.

Malaysia benefits as global chip supply shifts

Malaysiaโ€™s semiconductor industry benefits from US-China trade tensions, attracting investment due to its neutrality and strong government support.

Hong Kong hosts major Web3 event as it pushes to become a virtual asset hub

Consensus Hong Kong tests the city's ambitions as a crypto hub while global interest in virtual assets grows. Industry leaders discuss key trends.

Related Articles