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.
#KUTOOLS FOR EXCEL 12.00 PDF#
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.
#KUTOOLS FOR EXCEL 12.00 WINDOWS#
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.Ģ.
0 kommentar(er)
