Workbooks: Merge Multiple Workbooks, Split Workbook.ġ2. Formula: Exact Copy without Changing Reference, Convert Formula Reference in Multiple Cells, Replace Range Names.ġ1. Text: Remove Spaces, Change Case, Remove by Position, Reverse Text Order, Add Text, Delete Characters, Replace Accented Characters (in Custom List).ġ0.
Delete: Blank/Hidden/Visible Rows and Columns, Web Controls, All Macros, Charts/Pictures/Lines/Objects/Shapes/Boxes in Sheets.ĩ. Insert: Title Rows, Blank Columns/Rows, Date Picker, Sequence Number, Range Randomize Utilities.Ĩ. Select: Multiple Ranges Helper, Interval Rows and Columns, Merged/Max/Min/Error Cells, Specific Cells, Cells with Format.ħ. More Range Features: Combine Columns/Rows/Cells without Data Losing, Round Without Formula, Fill Cell with Displayed Value, Compare Ranges, Prevent Duplicate Entries, Copy Multiple Ranges at Once.Ħ. Content Converter: Multiple Date Format Recognizer and Converter, Currency Conversion, Unit Conversion, Spell Out Numbers.ĥ. Range Converter: Merge/Unmerge Same Cells, Flip Horizontal/Vertical Range, Transpose Table Dimentions, Transform/Swap Ranges.Ĥ. View: Navigation Pane (just like in Word), Change Work Area Size, Reading Layout (help to quickly browse huge amounts of data), Toggle Hidden Columns/Worksheets Visibility, Toggle View Setting, and more Show/Hide features.ģ. Snap: Save Snapshots of Current Workbook, Restore Snapshot.Ģ. It frees you from time-consuming operations.ġ. More features please visit the web site of Kutools for Excel.Kutools for Excel includes more than 120 powerful functions and tools for Microsoft Excel. Import/Export: Export a range of data to a new file or as a graphic Filename List allows you to create a new workbook with a list of file names for a directory, and hyperlinks can be added to the file names for easy navigation.ġ1. Delete Tools: Delete Charts, Pictures, Lines, Auto Shapes, Smart Arts, Text Box and Embedded OLE Objects.ġ0. Select Tools: select cells with Max, Min or error value, Select Specific Cells and the cells with format.ĩ. Worksheet Tools: Synchronize worksheets, Sort worksheets, Rename multiple worksheets, Create List of Sheet Names, Copy/New Multiple Worksheets, Create Sequence Worksheets, Perpetual Calendar and Delete Blank Worksheets.Ĩ. Workbook Tools: Merge and split Excel workbooks, Backup current workbook, Open containing folder and Auto open Those Workbooks Next Time.ħ. Text Tools: embodies a lot of handy operations to manipulate the text in cells, like easily change case of the text, add text to a specified character position of the text remove spaces and characters of a particular type from the text.Ħ. Show/Hide: a collection of tools allows you to quickly show or hide the workbooks, worksheets and ranges.ĥ. Toggle Settings: show or hide the Excel Built-in Menus, Grid Lines, Scroll Bar, Sheet Tabs, Formula Bar, Status Bar and Zero Value.Ĥ. Work Area Size: maximize the work area of Excel window to view more Excel data.ģ. User can quickly switch from one sheet to another sheet.Ģ. Navigation Pane: list all workbooks, worksheets, columns and names in a side pane. Kutools for Excel includes more than 100 powerful functions and tools for Microsoft Excel.
0 kommentar(er)
