\n<\/p>\n
Google has now added a way to create easily formatted tables in Sheets with one click, something Excel has had for years<\/a>. Now, if you have a block of data that you\u2019d like to quickly turn into its own little island of filters and sorting rules, that\u2019s fully possible (or will be soon, depending on where you are in Google\u2019s rollout queue). Hooray!<\/p>\n<\/div>\n As a person who\u2019s maintained a shared budget spreadsheet in Google Sheets for about a decade and who would have loved not to have to create all of my filters and sort piece by piece, I\u2019m excited. And judging by a little cursory searching, I\u2019m not alone \u2014 people<\/a> have<\/a> been<\/a> asking<\/a> for self-contained tables like this for years. <\/p>\n<\/div>\n What Google has created here looks a little bit like the AI-generated tables<\/a> from its I\/O developer conference this week but perhaps a little more power user-focused, and you don\u2019t need its Gemini integration<\/a>. If the new feature has hit your account already, you can try it by selecting a block of data and clicking Format > Convert to table<\/strong>. <\/em><\/p>\n<\/div>\n Once you\u2019ve done that, Sheets will automatically create filters for each column and add visual separators for your rows, so you don\u2019t have to manually select every other row and turn it gray. The change also comes with automatically formatted column types, filters, and easier drop-down menu creation. <\/p>\n<\/div>\n It\u2019ll also add a table menu so you can create specific combinations of filters for the whole table or adjust the range of data it covers. Google says this update also includes a new kind of view option labeled \u201cCreate group by view\u201d that lets you put data in groups separated by their column filters \u2014 so if you have a filter for priority level, you can group records by priority one, priority two, priority three, and so on. There are also table templates tuned for \u201ceveryday tasks like project management, inventory management, event planning and more.\u201d <\/p>\n<\/div>\n