Google Sheets gains one-click table formatting feature: How it works
Google has launched a new feature for its Sheets platform, enabling users to create formatted tables with just one click. This user-friendly and efficient feature, which has been a staple in Microsoft Excel for many years, allows for quick conversion of data blocks into self-contained tables with unique filters and sorting rules. According to Google, the rollout of this new feature will be gradual, with some users gaining access by May 30 and all others by June 6.
Steps to use the formatting feature
To use this new feature, users need to select a block of data and click on Format > Convert to table. Google Sheets will then automatically create filters for every column and add visual separators for the rows, eliminating manual selection and formatting. Additionally, a table menu will be added that allows users to create specific combinations of filters or adjust the range of data covered by the table.
Update also includes a new view option
Besides the table formatting feature, Google has also introduced a new view option labeled "Create group by view." This feature allows users to group data based on their column filters. For instance, if you have a priority level filter, you can categorize records into priority one, priority two, priority three, and so on. Additionally, there are table templates tailored for various everyday tasks including project management, inventory management, and event planning.