Power Tools add-on for Google Sheets, 12-month subscription - 0 views
-
tech writer on 15 May 19Power Tools add-on cuts the clicks on repeated tasks and brings features for organizing and unifying data in Google Sheets. Extra spaces, formulas and data in the wrong format are among many of the issues the add-on deals with: - Take advantage of the new smart toolbar with handy assistants: insert or delete cells and shift adjacent data, change case, or swap values. - Click once to AutoSum numbers in every row or column; sum and count cells by color. - Search all selected sheets for certain values, formulas, notes, and hyperlinks; see a list of found entries, export or replace them in a click. - Get "Text to columns" feature: split values in a column by any delimiter, string, or by position. - Automate some routine tasks: add or remove text by position, transform formulas, change formula reference type, export range to XML or JSON. - Bring order to your sheet: delete unwanted characters, types of data, and clean up formatting. - Get every needed data tool in one place: remove duplicates or bring them to one row, compare and merge sheets, randomize data, and much more. The add-on keeps history of the recent operations at hand so that you can quickly re-apply a set of actions to a different range. You can also star the most frequent features to have access to your favorites at any time. When you import data from different sources or share the same spreadsheet with colleagues, it becomes critical to bring it in order in the shortest time possible. Even such simple tasks as deleting all notes from your sheet can waste a lot of time. Power Tools helps you do this in a click.