back to top
Wednesday, June 19, 2024

Trending Stories

Related Posts

- Advertisement -

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 .

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 and functionality, making Google Sheets an increasingly powerful tool for personal and professional use.

Tech Edition has partnerships that involve sponsored content. While this financial support helps us with daily operations, it doesn't affect the integrity of our reviews. We remain committed to delivering honest and insightful content to our readers.

Tech Edition is now on Telegram! Join our channel here and catch all the latest tech news!

Emma Job
Emma Job
Emma is a freelance news editor at Tech Edition. With a decade's experience in content writing, she revels in both crafting and immersing herself in narratives. From tracking down viral trends to delving into the most recent news stories, her goal is to deliver insightful and timely content to her readers.

Featured Content

The evolving role of AI in consumer electronics and enterprise solutions

Explore how AI is transforming both consumer electronics and enterprise solutions, highlighting the symbiotic relationship that drives innovation and efficiency across sectors.

Latest Stories

Related Stories