You can quickly navigate to each precedent cell, including those on other worksheets and in other workbooks. Smart Precedents Checker: Opens a dialog box that contains links to all precedent cells relied upon to calculate the active cell. Good news! We’ve updated the free excel add-in with a powerful formula audit tool! Delete unused, empty rows and comments on all sheets.Delete empty and hidden sheets in the actual workbook.Workbook Cleaner: Clean current workbook of unnecessary data, formats, images, macros, etc.Split Sheets to Files: Save sheets in separate files using user-friendly interface.Perform various operations (adding, sorting, protecting, etc.) on sheets in the current workbook. Screenshot Manager: Create screenshot of selected range and export it into various formats.Clean Ranges: Delete text, formats, notes, hyperlinks, conditional formatting, etc.Compare Ranges: Compare two columns or ranges and the output or highlighting of coincidences / differences between them.Split Ranges: Split one data table into several different sheets based on the values of the specified column or other criteria.Data Collector: Consolidate Multiple Worksheets into one Workbook.Spreadsheet Tools – Effective management for Ranges Drop-down list creator: Create drop-down list in selected cells in seconds.Insert text starting at nth position and much more….Insert text before first, after last character.Remove spaces, non-printable characters, all line breaks, initial apostrophes.Delete or extract characters starting at the nth position.Delete first or last character from a selected string.Convert text to uppercase, apply Excel lowercase to your data or convert your text values to proper / title case.Learn how to install an Excel add-in quickly.
In addition, we will help you to clean your raw data! Text processing and string manipulations in Excel are not easy tasks, but we’ll help you simplify string-related functions using our add-in. We proudly present our improved tool! Text Tools and Smart Utilities If you want to speed up your work, read more on building a stunning org chart asap with Free Organizational Chart add-in. Free Organizational Chart Maker for Excel
0 kommentar(er)
