recruitmentpax.blogg.se - Extendoffice kutools for excel v12

Select Duplicate or Unique Rows Select Blank Rows (all cells are empty) Super Find and Fuzzy Find in Many Workbooks Random Select.

Merge Cells/Rows/Columns without losing Data Split Cells Content Combine Duplicate Rows/Columns.

Super Formula Bar (easily edit multiple lines of text and formula) Reading Layout (easily read and edit large numbers of cells) Paste to Filtered Range.

Reuse: Quickly insert complex formulas, charts and anything that you have used before Encrypt Cells with password Create Mailing List and send emails.

The Best Office Productivity Tools Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%

Fixed: Some errors of the interface language.

Fixed: Cell A1 is selected when no nonblank cells existing in selected range.ģ. See screenshot:ĭisplaying the total number of all nonblank cells in selected range. And you can also assign shortcuts Ctrl + F in the Navigation Options to access the Advanced Find and Replace pane of Kutools for Excel.Ħ.2 The Advanced Find and Replace pane of Kutools for Excel is floatable.ħ.1 There is a checkbox before each combination entry ħ.2 Pressing shortcuts Alt + A will directly add text to the Combination list. See screenshot:Ħ.1 Pressing shortcuts Ctrl + Shift + F will directly access the Advanced Find and Replace pane of Kutools for Excel. You can split cells into multiple rows now. The Advanced Sort feature supports case sensitive now. The Match Import Pictures feature supports case sensitive now.

See screenshot:Ģ.1 Support splitting current workbook and saving each selected worksheet as a separated PDF file.Ģ.2 It will display dialog box for you to process when the destination has files with the same names during splitting period. See screenshot:ġ.1 All opening Excel windows will be displayed in the Workbook pane of Navigation Pane.ġ.2 Adding status bar for the numbers of all sheets, visible sheets and hidden sheets of current workbook at the bottom of Navigation Pane. This utility can easily delete all inactive sheets except current one with clicks. More commonly-used formulas are available now, which including: Find nth occurrence of a character, Count words in range, Count weekends between two dates, Count weekdays between two dates and Count the number of specific weekday. Adding new commonly-used built-in formulas Kutools for Excel adds a couple of useful functions for easily calculations without remembering formulas.Ģ.