Google is introducing these three new features in Google Sheets that will help you clean up, navigate and work with your data quicker.
These features are:
Compatible spreadsheet shortcuts
1. Remove Duplicates
With this tool, you can easily remove duplicate values from your sheet. According to Google, this is "a highly requested feature".
This will save you time and get rid of manually removing duplicate data or the need to write an app script.
How to remove duplicates from a range of data in Google Sheets?
Select range of data in your sheet.
From the toolbar, select Data > Remove duplicates. In the dialogue box, you’ll see your selected range of data.
Select Remove duplicates. You’ll see an additional dialogue box that details how many duplicates were removed from your dataset.
2. Trim Whitespace
Remove any leading, trailing and excessive whitespace to the data you added to a sheet from a cell or range of data. You can now easily keep your sheet standardised and clean by using trim whitespace feature.
How to trim whitespaces in Google Sheets?
Select a cell or range of data that contains whitespace on your sheet.
From the toolbar, select Data > Trim whitespace.
You’ll then see a dialogue box that details how many cells whitespace was removed from.
3. Compatible Spreadsheet Shortcuts
These popular and familiar keyboard shortcuts will make navigating and working with data in Sheets quicker for users.
You can now use shortcuts from other spreadsheets in Sheets.
How to enable compatible keyboard shortcuts to Google Sheets?
Go to Help > Keyboard shortcuts.
You can see a list of keyboard shortcuts and their corresponding commands. Note that compatible shortcuts will be denoted with an info icon.
At the bottom, you can enable compatible spreadsheet shortcuts.
You can click “View compatible shortcuts” at the bottom right to see a complete list of all newly available shortcuts.
Let us know what you think about these new features on our Socials!
We want to help G Suite users do more with G Suite. We are providing a free resource of updates, quality tips and tricks for the G Suite Business and Education Communities.