Google is launching a new and exciting feature that will make your table editing more efficient. Introducing the One-Click Tables on Google Sheets.
With only a click, you can convert selected data on your worksheet into a table. That means, you can apply filters or sorting rules on selected data without having to do it one at a time. Format tables like the expert you are with lesser clicks and more results! It works like how you do it on Excel worksheets.
How to Use Convert to Table to Create One-Click Tables on Google Sheets
Google is rolling out the new tables feature gradually to all its users. It will either appear on your Google Sheet on May 30 or June 6.
When you see it on your account, here’s how you can utilize this very useful function on your spreadsheets.
- First, select the data you want to set apart as a table.
- After highlighting your preferred cells, click Format.
- Select Convert to table.
- A new table will be created with all the selected data in it.
- Now, you can set filters for each column.
- Click the down arrow next to the column title.
- Select how you want to edit your column.
- Once done, the changes will apply automatically.
- You can also add visual separators for each row.
Google Sheets also integrated additional features such as the Create group by view function, where you can group data separately by filters making it easier for setting priorities on each column. There are also table templates such as inventory management, project management, event planning etc.
Closing
With all the enhancements happening on Google Sheets, users will definitely find it easier to manage their worksheets online. Enjoy creating and sorting various filters on your tables with just one click!
