|
Compare worksheets and highlight different cells in Excel
|
Written by Amanda Li |
Hits: 4355
|
|
Quickly create an alternative progress bar chart in Excel
|
Written by Amanda Li |
Hits: 3143
|
|
Quickly create a dynamic scrollable line chart in Excel
|
Written by xiaoyang |
Hits: 4161
|
|
Quickly create a dynamic ranked bar chart with scroll bar in Excel
|
Written by xiaoyang |
Hits: 4677
|
|
Easily create a dynamic pie of pie chart in Excel
|
Written by siluvia |
Hits: 4448
|
|
Easily create a dynamic column chart in Excel
|
Written by siluvia |
Hits: 5482
|
|
Synchronize Kutools configuration between devices with an OneDrive Account
|
Written by siluvia |
Hits: 3283
|
|
Create an alternative stacked column chart in Excel
|
Written by sun |
Hits: 3540
|
|
Quickly create a battery chart in Excel
|
Written by sun |
Hits: 4400
|
|
Quickly create a drop-down list with images in Excel
|
Written by xiaoyang |
Hits: 7684
|
|
Quickly create a bar graph with interval labels in Excel
|
Written by xiaoyang |
Hits: 5475
|
|
Easily Vlookup with multiple criteria in Excel
|
Written by xiaoyang |
Hits: 6001
|
|
Easily generate mutiple QR codes in bulk in Excel
|
Written by xiaoyang |
Hits: 23340
|
|
Click cell to filter based on another workbook dynamically
|
Written by xiaoyang |
Hits: 4318
|
|
Extend the range of dependent drop down list with only one click in Excel
|
Written by xiaoyang |
Hits: 6013
|
|
Quickly create searchable or autocomplete drop down list in Excel
|
Written by xiaoyang |
Hits: 15927
|
|
Quickly create a stacked variance column or bar chart in Excel
|
Written by xiaoyang |
Hits: 5868
|
|
Easily unprotect multiple Excel workbooks at once
|
Written by siluvia |
Hits: 4662
|
|
Easily protect multiple Excel workbooks with password at once
|
Written by siluvia |
Hits: 4464
|
|
Easily create an area chart with smooth lines in Excel
|
Written by siluvia |
Hits: 9237
|
|
Quickly highlight multiple keywords within cells
|
Written by kelly |
Hits: 13348
|
|
Quickly enable date picker (drop down calendar) for date cells in Excel
|
Written by kelly |
Hits: 18641
|
|
Quickly create a nightingale rose chart in Excel
|
Written by kelly |
Hits: 14598
|
|
Quickly create a half pie chart in Excel
|
Written by kelly |
Hits: 10263
|
|
Quickly convert dates to quarters and years in Excel
|
Written by kelly |
Hits: 11448
|
|
Quickly convert dates to ordinal date format in Excel
|
Written by kelly |
Hits: 7583
|
|
Easily join cell values with specific delimiter in Excel
|
Written by siluvia |
Hits: 7312
|
|
Quickly sum cell values with text and numbers within one cell
|
Written by xiaoyang |
Hits: 6962
|
|
Check if a cell contains a specific text then return value in another cell in Excel
|
Written by xiaoyang |
Hits: 11241
|
|
Easily abbreviate names or words in Excel
|
Written by siluvia |
Hits: 11024
|
|
Count number of days in year from the given date in Excel
|
Written by sun |
Hits: 6324
|
|
Count total days in month from the given date in Excel
|
Written by sun |
Hits: 6328
|
|
Create a multi-layer column chart in Excel
|
Written by sun |
Hits: 9553
|
|
Create a project status spectrum chart in Excel
|
Written by sun |
Hits: 8038
|
|
Quickly and easily create a rectangular pie chart in Excel
|
Written by sun |
Hits: 9294
|
|
Create a project status bead chart in Excel
|
Written by sun |
Hits: 7540
|
|
Display classic menu in Excel 2007 or later versions
|
Written by sun |
Hits: 8894
|
|
Quickly break link between chart and data with one click in Excel
|
Written by xiaoyang |
Hits: 10565
|
|
Quickly create multiple progress pie charts in one graph
|
Written by xiaoyang |
Hits: 12574
|
|
Create radial bar chart in Excel with only several clicks
|
Written by xiaoyang |
Hits: 9210
|
|
Quickly create an alternative rose chart in Excel
|
Written by xiaoyang |
Hits: 8731
|
|
Easily add poly line to a column chart in Excel
|
Written by siluvia |
Hits: 7855
|
|
Easily create a line chart with multiple series in Excel
|
Written by siluvia |
Hits: 14878
|
|
Easily create a bidirectional histogram chart in Excel
|
Written by siluvia |
Hits: 8527
|
|
Easily create an area chart based on threshold value in Excel
|
Written by siluvia |
Hits: 8619
|
|
Easily create a forecast chart in Excel
|
Written by siluvia |
Hits: 8453
|
|
Quickly create a progress bar with percentage in Excel
|
Written by sun |
Hits: 17208
|
|
Quickly create a data entry form in Excel
|
Written by sun |
Hits: 15341
|
|
One click to add total label to stacked chart in Excel
|
Written by sun |
Hits: 7886
|
|
Easily make a horizontal dumbbell chart in Excel
|
Written by sun |
Hits: 11083
|
|
Create a chart combined with bubble chart and bar chart in Excel
|
Written by sun |
Hits: 10147
|
|
Create a bar chart with percentage difference arrow in Excel
|
Written by sun |
Hits: 15545
|
|
Change chart color based on category in Excel
|
Written by sun |
Hits: 9810
|
|
Quickly set the absolute position of a chart in Excel
|
Written by xiaoyang |
Hits: 8613
|
|
Move x axis labels to bottom of chart with only one click
|
Written by xiaoyang |
Hits: 8935
|
|
Quickly create a percentage ball chart in Excel
|
Written by xiaoyang |
Hits: 10401
|
|
Quickly create a Mosaic or Marimekko chart in Excel
|
Written by xiaoyang |
Hits: 14276
|
|
Create multiple series histogram or bar chart quickly in Excel
|
Written by xiaoyang |
Hits: 25298
|
|
Create a dot plot chart in Excel quickly and easily
|
Written by xiaoyang |
Hits: 19196
|
|
Create a bidirectional bar chart with only several clicks
|
Written by xiaoyang |
Hits: 8937
|
|
Quickly Create A Variable Width Column Chart In Excel
|
Written by kelly |
Hits: 11655
|
|
Quickly Create An Area Chart With Multiple Series In Excel
|
Written by kelly |
Hits: 9317
|
|
Quickly Copy Formatting From One Chart To Others In Excel
|
Written by kelly |
Hits: 9731
|
|
Quickly Create A Doughnut Progress Chart In Excel
|
Written by kelly |
Hits: 10565
|
|
Quickly Create A Lollipop Chart In Excel
|
Written by kelly |
Hits: 8969
|
|
Quickly Add Accumulated Total Line To A Chart In Excel
|
Written by kelly |
Hits: 12904
|
|
Easily extract the nth word from a text string in Excel
|
Written by siluvia |
Hits: 9391
|
|
Easily count unique values in a column in Excel
|
Written by siluvia |
Hits: 11391
|
|
Easily count comma separated values in a single cell in Excel
|
Written by siluvia |
Hits: 11125
|
|
Easily count cells with multiple OR criteria in Excel
|
Written by siluvia |
Hits: 8969
|
|
Easily count cells that match two conditions in Excel
|
Written by siluvia |
Hits: 9774
|
|
Easily count all distinct values in a range in Excel
|
Written by siluvia |
Hits: 21707
|
|
Easily convert seconds to HH:MM:SS time format in Excel
|
Written by siluvia |
Hits: 12218
|
|
Quickly convert days to years, months and days in Excel
|
Written by xiaoyang |
Hits: 58781
|
|
Quickly calculate the days hours and minutes between two datetimes in Excel
|
Written by xiaoyang |
Hits: 11721
|
|
Quickly create a column chart with percentage change in Excel
|
Written by xiaoyang |
Hits: 17565
|
|
Quickly create a chart with different colors based on data grouping
|
Written by xiaoyang |
Hits: 15931
|
|
Quickly add horizontal or vertical average line to a chart in Excel
|
Written by xiaoyang |
Hits: 12191
|
|
Create bullet chart Quickly and easily in Excel
|
Written by xiaoyang |
Hits: 10895
|
|
Create a Gantt chart with several clicks in Excel
|
Written by xiaoyang |
Hits: 15604
|
|
Color the chart bars based on cell value with ease in Excel
|
Written by xiaoyang |
Hits: 15399
|
|
Using SUMPRODUCT function with criteria in Excel
|
Written by sun |
Hits: 12405
|
|
Quickly extract unique values including first duplicate from An Excel column
|
Written by sun |
Hits: 10724
|
|
Quickly extract unique values from a column with formula in Excel
|
Written by sun |
Hits: 13434
|
|
Index a value by matching multiple columns in Excel
|
Written by sun |
Hits: 13710
|
|
Formula to extract substring between two texts in Excel
|
Written by sun |
Hits: 10504
|
|
Find the largest value smaller than a specified number in Excel
|
Written by sun |
Hits: 11646
|
|
Quickly Create A Year Over Year Comparison Bar Chart In Excel
|
Written by kelly |
Hits: 31374
|
|
Quickly Create A Timeline / Milestone Chart In Excel
|
Written by kelly |
Hits: 20431
|
|
Quickly Create A Thermometer Chart In Excel
|
Written by kelly |
Hits: 11058
|
|
Quickly Create A Step Chart In Excel
|
Written by kelly |
Hits: 11296
|
|
Easily Create A Stacked Chart With Showing Percentages In Excel
|
Written by kelly |
Hits: 15007
|
|
Quickly Create An Actual Vs Target Chart In Excel
|
Written by kelly |
Hits: 13815
|
|
Quickly Create A Drop-Down List In Excel
|
Written by kelly |
Hits: 14059
|
|
Excel calculate date and time: Add, subtract date time, time difference, age calculation
|
Written by sun |
Hits: 19782
|
|
Easily vlookup value between two numbers in Excel
|
Written by siluvia |
Hits: 13729
|
|
Quickly vlookup and return matching values from multiple worksheets
|
Written by xiaoyang |
Hits: 18497
|
|
Easily vlookup values from bottom to top in Excel
|
Written by siluvia |
Hits: 15606
|
|
Quickly create drop down lists with checkboxes in Excel
|
Written by xiaoyang |
Hits: 24392
|
|
Easily vlookup values from right and return results in the left column in Excel
|
Written by siluvia |
Hits: 13498
|
|
Easily lookup and sum the first or all matched values in rows or columns
|
Written by xiaoyang |
Hits: 16718
|
|
Manage Excel workbook passwords used to open files for combining and conversion
|
Written by sun |
Hits: 20168
|
|
Replace #N/A or zero in VLOOKUP with blank or specified text in Excel
|
Written by sun |
Hits: 27102
|
|
Quickly Select Multiple Items From Drop-Down Lists In Excel
|
Written by kelly |
Hits: 44911
|
|
Quickly Create Multiple Levels Drop-Down List In Excel
|
Written by kelly |
Hits: 37459
|
|
Quickly Color/Conditional Formatting Drop-Down List In Excel
|
Written by kelly |
Hits: 32414
|
|
Directly print data with circle invalid data in Excel
|
Written by sun |
Hits: 9105
|
|
Easily create a normal distribution chart (bell curve) in Excel
|
Written by sun |
Hits: 64096
|
|
Quickly apply phone number data validation to cells in Excel
|
Written by sun |
Hits: 9335
|
|
Show full contents of cell and enhance editing in Excel
|
Written by sun |
Hits: 53772
|
|
Quickly duplicate rows or columns based on cell value in a specific column or row in Excel
|
Written by siluvia |
Hits: 41066
|
|
Always show comment when a cell is selected in Excel
|
Written by siluvia |
Hits: 12266
|
|
Easily print only the charts in Excel
|
Written by siluvia |
Hits: 12515
|
|
Easily find all combinations that equal a given sum in Excel
|
Written by siluvia |
Hits: 30453
|
|
Quickly format cells or rows when cell value change in Excel
|
Written by kelly |
Hits: 23982
|
|
Quickly group data by fiscal year, half year, week number into Pivot Table in Excel
|
Written by xiaoyang |
Hits: 15400
|
|
Quickly validate Email addresses in a column or a range of cells in Excel
|
Written by xiaoyang |
Hits: 13752
|
|
Quickly set data validation to accept only IP addresses in Excel
|
Written by kelly |
Hits: 22700
|
|
Quickly insert or create barcode into cells based on specific value in Excel
|
Written by xiaoyang |
Hits: 25967
|
|
Quickly create a speedometer chart in Excel
|
Written by kelly |
Hits: 34394
|
|
Quickly create or insert bubble chart in Excel
|
Written by xiaoyang |
Hits: 15962
|
|
Easily insert or display images from URLs or file paths in Excel
|
Written by siluvia |
Hits: 61997
|
|
Batch clear all data validation restrictions from selection in Excel
|
Written by kelly |
Hits: 36732
|
|
Quickly find all cells with specific cell formatting in Excel
|
Written by xiaoyang |
Hits: 23803
|
|
Quickly find and replace the similar records from a list of cell values in Excel
|
Written by xiaoyang |
Hits: 25233
|
|
Quickly search specific text values only in hyperlinks in Excel
|
Written by sun |
Hits: 21640
|
|
Quickly find numbers based on criteria in Excel
|
Written by sun |
Hits: 21699
|
|
Quickly find cells which contain date type values based on criteria in Excel
|
Written by sun |
Hits: 22787
|
|
Quickly find specific text strings only in the comments in Excel
|
Written by siluvia |
Hits: 22125
|
|
Quickly find specific text string only in cell value in Excel
|
Written by siluvia |
Hits: 25086
|
|
Quickly find specific text strings only in the formulas in Excel
|
Written by siluvia |
Hits: 17448
|
|
Easily update or merge tables by matching column from two worksheets/workbooks in Excel
|
Written by siluvia |
Hits: 30956
|
|
Easily filter all cells by italics in Excel
|
Written by siluvia |
Hits: 20090
|
|
Easily filter all cells by bold characters in Excel
|
Written by siluvia |
Hits: 23977
|
|
Quickly filter merged cells in Excel
|
Written by kelly |
Hits: 65770
|
|
Quickly filter cells by uppercase / lowercase in Excel
|
Written by kelly |
Hits: 49373
|
|
Quickly filter cells by text length in Excel
|
Written by kelly |
Hits: 43779
|
|
Quickly filter cells with strikethrough in a specific column with one click
|
Written by xiaoyang |
Hits: 31360
|
|
Quickly filter all cells which containing formula in a specified column
|
Written by xiaoyang |
Hits: 20809
|
|
Filter all cells with comments by using only one click in a selected column
|
Written by xiaoyang |
Hits: 23078
|
|
Quickly filter cells by workday/weekend/specific day of the week in Excel
|
Written by sun |
Hits: 22923
|
|
Quickly filter cells by the font color in Excel
|
Written by sun |
Hits: 23243
|
|
Quickly filter cells by the background color in Excel
|
Written by sun |
Hits: 21933
|
|
Easily create mailing list and send emails in Excel
|
Written by sun |
Hits: 87484
|
|
Quickly remove time from date time format permanently in Excel
|
Written by xiaoyang |
Hits: 38281
|
|
Quickly insert bullets or numberings in multiple cells in Excel
|
Written by sun |
Hits: 35024
|
|
Kutools for Excel 16.00 - Release notes
|
Written by ZhouMandy |
Hits: 27182
|
|
Quickly remove leading zeros from text string in Excel
|
Written by sun |
Hits: 22047
|
|
Easily print only specific, even or odd pages in Excel
|
Written by siluvia |
Hits: 29246
|
|
Quickly convert between different number systems without using formula in Excel
|
Written by siluvia |
Hits: 28295
|
|
Easily compare two ranges of cells if they are equal or different in Excel
|
Written by siluvia |
Hits: 121430
|
|
Easily prevent special or certain characters from being typed in cells
|
Written by sun |
Hits: 22474
|
|
Quickly only allow specific characters to be entered in a range of cells
|
Written by xiaoyang |
Hits: 19561
|
|
Quickly add and print border around each page in Excel
|
Written by sun |
Hits: 25158
|
|
Kutools for Excel 15.00 - Release notes
|
Written by ZhouMandy |
Hits: 20257
|
|
Kutools for Excel 13.00 - Release notes
|
Written by ZhouMandy |
Hits: 21508
|
|
Kutools for Excel 14.00 - Release notes
|
Written by ZhouMandy |
Hits: 18713
|
|
Quickly insert and remove watermarks in Excel
|
Written by xiaoyang |
Hits: 33941
|
|
Easily hide or unhide named range in Excel
|
Written by siluvia |
Hits: 19599
|
|
Quickly trace all dependents or precedents in Excel
|
Written by sun |
Hits: 28100
|
|
Easily sum/count/average visible cells, rows, or columns only in Excel
|
Written by kelly |
Hits: 45807
|
|
Easily find the most common/frequently used value (word or number) in a list in Excel
|
Written by siluvia |
Hits: 21569
|
|
Subscript all numbers in chemical equations correctly in Excel
|
Written by xiaoyang |
Hits: 21890
|
|
Easily unblock (access to) unsafe attachment types in Outlook
|
Written by kelly |
Hits: 32719
|
|
Quickly count the number of words in a cell or a range in Excel
|
Written by sun |
Hits: 27059
|
|
Quickly sum bold values / numbers only in Excel
|
Written by xiaoyang |
Hits: 32255
|
|
Easily find position of nth occurrence of a character in text string in Excel
|
Written by siluvia |
Hits: 24515
|
|
Quickly count numbers of weekends/weekdays/specific day of week between two dates in Excel
|
Written by kelly |
Hits: 38395
|
|
Easily count the number of only bold cells in a range in Excel
|
Written by kelly |
Hits: 38845
|
|
Quickly delete all sheets except current / active one from workbook
|
Written by xiaoyang |
Hits: 23252
|
|
Kutools for Excel 12.50 - Release notes
|
Written by ZhouMandy |
Hits: 20899
|
|
Kutools for Excel 12.00 - Release notes
|
Written by ZhouMandy |
Hits: 24118
|
|
Quickly split cell contents by space / newline / comma / period or other delimiters in Excel
|
Written by xiaoyang |
Hits: 84942
|
|
Quickly lookup a value and return a different cell from the table
|
Written by xiaoyang |
Hits: 39221
|
|
Easily sum absolute values in a range in Excel
|
Written by siluvia |
Hits: 31016
|
|
Quickly insert page break every x rows in Excel worksheet
|
Written by xiaoyang |
Hits: 29987
|
|
Easily select non-blank or non-empty cells in a range in Excel
|
Written by siluvia |
Hits: 23793
|
|
Easily add hours/minutes/seconds to a datetime in Excel
|
Written by siluvia |
Hits: 26173
|
|
Quickly reset all comment positions in Excel
|
Written by sun |
Hits: 19098
|
|
Quickly convert numbers to ordinal numeral in Excel
|
Written by xiaoyang |
Hits: 27443
|
|
Automatically resize comment boxes to fit the contents in Excel
|
Written by siluvia |
Hits: 22967
|
|
Quickly add / subtract years / months / days / weeks to date in Excel
|
Written by xiaoyang |
Hits: 39088
|
|
Quickly find and fill missing numbers in sequence in Excel
|
Written by sun |
Hits: 45627
|
|
Quickly count the times a word appears in a cell or a range
|
Written by sun |
Hits: 20791
|
|
Easily and quickly print first page of each worksheet in Excel
|
Written by sun |
Hits: 21651
|
|
Quickly generate/list all possible combinations of certain lists in Excel
|
Written by kelly |
Hits: 78665
|
|
Quickly calculate age by date of birth in Excel
|
Written by kelly |
Hits: 51245
|
|
Quickly sum all digits/numbers in a cell in Excel
|
Written by kelly |
Hits: 53305
|
|
Easily print pages in reverse order in Excel
|
Written by kelly |
Hits: 52567
|
|
Easily find and replace in multiple worksheets and workbooks
|
Written by kelly |
Hits: 82249
|
|
Kutools for Excel 11.00 - Release notes
|
Written by ZhouMandy |
Hits: 29922
|
|
Quickly insert multiple pictures into cells based on cell value in Excel
|
Written by xiaoyang |
Hits: 40361
|
|
Quickly batch remove or delete all macros from workbooks in Excel
|
Written by siluvia |
Hits: 25688
|
|
Quickly convert time to seconds/minutes/hours in Excel
|
Written by kelly |
Hits: 167739
|
|
Kutools for Excel 10.00 - Release notes
|
Written by ZhouMandy |
Hits: 21030
|
|
Kutools for Excel 9.00 - Release notes
|
Written by ZhouMandy |
Hits: 20277
|
|
Quickly combine / merge multiple worksheets / workbooks in Excel
|
Written by ZhouMandy |
Hits: 21144
|
|
Quickly highlight all formula cells with color in Excel
|
Written by xiaoyang |
Hits: 21845
|
|
Quickly hide and show column and row headers in current worksheet
|
Written by xiaoyang |
Hits: 17519
|
|
Quickly copy data and paste to visible cells only in Excel
|
Written by xiaoyang |
Hits: 79931
|
|
Quickly highlight all named ranges with one click in Excel
|
Written by kelly |
Hits: 20307
|
|
Quickly extract numbers from mixed text string with function in Excel
|
Written by kelly |
Hits: 81757
|
|
Quickly convert between roman numerals and numbers in Excel
|
Written by kelly |
Hits: 69653
|
|
Easily configure cells to be locked or unlocked when protecting worksheet
|
Written by xiaoyang |
Hits: 23848
|
|
Quickly highlight/color all unlocked cells with one click in Excel
|
Written by kelly |
Hits: 47190
|
|
Easily reverse order of characters in a cell with functions in Excel
|
Written by kelly |
Hits: 80373
|
|
Using a function to count / sum cells by fill or font color in Excel
|
Written by xiaoyang |
Hits: 74948
|
|
Batch delete option buttons with one click in Excel
|
Written by kelly |
Hits: 76910
|
|
Quickly remove / delete multiple checkboxes at once in Excel
|
Written by xiaoyang |
Hits: 23549
|
|
Quickly count the occurrences of a character in a string in Excel
|
Written by xiaoyang |
Hits: 27596
|
|
Easily create and insert Auto Text entry in Excel
|
Written by siluvia |
Hits: 80553
|
|
Easily show or display all cell formulas in Excel
|
Written by siluvia |
Hits: 27986
|
|
Quickly highlight cells with hidden formulas in Excel
|
Written by siluvia |
Hits: 19277
|
|
Quickly split or separate first, middle and last names of full name in Excel
|
Written by siluvia |
Hits: 44768
|
|
Quickly unfreeze panes on multiple worksheets in Excel
|
Written by siluvia |
Hits: 23333
|
|
Quickly show or hide zero values in Excel
|
Written by sun |
Hits: 37799
|
|
Quickly select last cell of used range or last cell with data of last row or column in Excel
|
Written by sun |
Hits: 62632
|
|
Quickly hide or unhide formulas when protecting a worksheet
|
Written by sun |
Hits: 49881
|
|
Quickly freeze panes across multiple worksheets in Excel
|
Written by sun |
Hits: 33486
|
|
Quickly extract email address from text string in Excel
|
Written by sun |
Hits: 44906
|
|
Kutools for Excel 8.10 – Release notes
|
Written by ZhouMandy |
Hits: 22636
|
|
Get Further Support for Excel
|
Written by Sale Support |
Hits: 22090
|
|
Make Excel Easy, Save Two Hours Every Day!
|
Written by Sale Support |
Hits: 25617
|
|
Kutools for Excel 7.80 – Release notes
|
Written by ZhouMandy |
Hits: 29520
|
|
Quickly format all comments based on a comment in Excel
|
Written by sun |
Hits: 25609
|
|
Quickly find and replace text in comments in Excel
|
Written by sun |
Hits: 29075
|
|
Quickly extract certain text from cells in Excel
|
Written by sun |
Hits: 61543
|
|
Quickly select all unlocked cells in Excel
|
Written by xiaoyang |
Hits: 23511
|
|
Quickly extract and list all comments to new worksheet/workbook
|
Written by sun |
Hits: 25193
|
|
Quickly convert between cell contents and comments in Excel
|
Written by sun |
Hits: 34030
|
|
Quickly insert multiple option buttons at once in Excel
|
Written by xiaoyang |
Hits: 32154
|
|
Quickly insert multiple checkboxes at once in Excel
|
Written by xiaoyang |
Hits: 36350
|
|
Quickly convert text string to formula in Excel
|
Written by xiaoyang |
Hits: 35896
|
|
Quickly change/remove/add author name in comments in Excel
|
Written by sun |
Hits: 32375
|
|
Quickly convert cell formulas to text strings in Excel
|
Written by xiaoyang |
Hits: 57421
|
|
Easily sort data by last name / month / frequency / text length in Excel
|
Written by xiaoyang |
Hits: 51791
|
|
Kutools for Excel 7.55 – Release notes
|
Written by ZhouMandy |
Hits: 19672
|
|
Kutools for Excel 7.00 – Release notes
|
Written by ZhouMandy |
Hits: 16984
|
|
Quickly convert multiple XLSX files to XLS or PDF files from local disk or OneDrive
|
Written by xiaoyang |
Hits: 53171
|
|
Quickly fill cell references from multiple worksheets in Excel
|
Written by xiaoyang |
Hits: 37072
|
|
Quickly find duplicate or unique cells/rows in a range in Excel
|
Written by xiaoyang |
Hits: 56602
|
|
Quickly create custom lists and fill cells with them in Excel
|
Written by xiaoyang |
Hits: 28743
|
|
Quickly combine same values / same data or duplicate rows in Excel
|
Written by xiaoyang |
Hits: 110704
|
|
Kutools for Excel 6.50 – Release notes
|
Written by ZhouMandy |
Hits: 21391
|
|
Quickly summarize / calculate data from multiple worksheets into one worksheet
|
Written by ZhouMandy |
Hits: 48854
|
|
Quickly combine multiple worksheets / ranges from workbooks into one worksheet
|
Written by ZhouMandy |
Hits: 67307
|
|
Quickly merge / combine all worksheets of same name across workbooks into one worksheet
|
Written by ZhouMandy |
Hits: 32581
|
|
Kutools for Excel 6.00 – So easy to combine worksheets!
|
Written by ZhouMandy |
Hits: 30056
|
|
Kutools for Excel: Powerful Excel Toolbox
|
Written by siluvia |
Hits: 1181577
|
|
Quickly sort or select cells, rows and columns randomly in Excel
|
Written by ZhouMandy |
Hits: 42318
|
|
Kutools for Excel 5.51 – for Office 2013 and more stable!
|
Written by ZhouMandy |
Hits: 46193
|
|
Quickly insert multiple pictures into cells and arrange them neatly
|
Written by xiaoyang |
Hits: 118774
|
|
Quickly extract url links from hyperlinks or to convert plain text links to hyperlinks
|
Written by xiaoyang |
Hits: 86852
|
|
Quickly remove all html objects (such as checkbox) in Excel
|
Written by xiaoyang |
Hits: 52831
|
|
Quickly remove numeric, alphabetic, non-printable or alphanumeric characters from cells
|
Written by xiaoyang |
Hits: 87300
|
|
Quickly print current printed page of active cell in Excel
|
Written by xiaoyang |
Hits: 58563
|
|
Quickly calculate cells value based on font，background or conditional color in Excel
|
Written by xiaoyang |
Hits: 111371
|
|
Quickly add the same text or characters in a range of cells in Excel
|
Written by xiaoyang |
Hits: 119787
|
|
Quickly remove or delete characters from beginning / end of text strings in Excel
|
Written by xiaoyang |
Hits: 78917
|
|
Quickly remove spaces before / after text or remove extra spaces from text in Excel
|
Written by xiaoyang |
Hits: 88800
|
|
Quickly change case of text to all caps, lower and proper in Excel
|
Written by xiaoyang |
Hits: 91990
|
|
Quickly filter data based on cell value with multiple criteria in Excel
|
Written by xiaoyang |
Hits: 71607
|
|
Save and export charts graphs (pictures or shapes) as JPEG image files in Excel
|
Written by xiaoyang |
Hits: 71942
|
|
Quickly inserting and printing subtotals on each page in Excel
|
Written by xiaoyang |
Hits: 86980
|
|
Easily encrypt and decrypt selected cell values or contents in Excel
|
Written by xiaoyang |
Hits: 116625
|
|
Quickly insert title rows into a range in Excel
|
Written by xiaoyang |
Hits: 37245
|
|
Quickly Find And Break Links (External References) In Excel
|
Written by xiaoyang |
Hits: 90437
|
|
Easily reading / viewing a large number of rows and columns in Excel
|
Written by xiaoyang |
Hits: 837424
|
|
Easily protect multiple sheets / worksheets at a time in Excel
|
Written by xiaoyang |
Hits: 117414
|
|
Quickly unprotect multiple worksheets / sheets at once
|
Written by xiaoyang |
Hits: 57725
|
|
Printing a list into multiple columns to fit on each printed page in Excel
|
Written by xiaoyang |
Hits: 85871
|
|
Kutools for Excel 5.10 – features improved and enhanced!
|
Written by ZhouMandy |
Hits: 31584
|
|
Quickly insert file name and file path into cell, header or footer in Excel
|
Written by xiaoyang |
Hits: 67099
|
|
Quickly change the shape of comment box in Excel
|
Written by xiaoyang |
Hits: 57374
|
|
Quickly reverse text string or words order in Excel
|
Written by xiaoyang |
Hits: 83847
|
|
Copy a cell formatting from one cell to other cells in Excel
|
Written by xiaoyang |
Hits: 88055
|
|
Quickly split data into multiple worksheets based on selected column in Excel
|
Written by xiaoyang |
Hits: 241402
|
|
Completely clear all formatting of a range in Excel
|
Written by xiaoyang |
Hits: 83618
|
|
Quickly prevent duplicate entries in a column in Excel
|
Written by xiaoyang |
Hits: 79892
|
|
Quickly merge adjacent cells in columns with same data/value in Excel
|
Written by xiaoyang |
Hits: 80551
|
|
Find and select merged cells in Excel with one click
|
Written by xiaoyang |
Hits: 52691
|
|
Quickly round cell values without formula in Excel
|
Written by xiaoyang |
Hits: 94411
|
|
Quickly flip (reverse) data order of columns or rows in Excel
|
Written by xiaoyang |
Hits: 143489
|
|
Quickly delete blank or hidden rows (columns) in Excel
|
Written by xiaoyang |
Hits: 144799
|
|
Quickly identify and convert date format in Excel
|
Written by xiaoyang |
Hits: 102655
|
|
Quickly toggle all hidden columns to be visible or invisible in Excel
|
Written by xiaoyang |
Hits: 56583
|
|
Quickly toggle all hidden sheets to be visible or invisible in Excel
|
Written by xiaoyang |
Hits: 56079
|
|
Quickly unmerge cells and fill down values in Excel
|
Written by xiaoyang |
Hits: 76169
|
|
Quickly convert or spell out a number into English words in Excel
|
Written by xiaoyang |
Hits: 229373
|
|
Kutools for Excel 5.00: more Excel tools and features!
|
Written by ZhouMandy |
Hits: 34240
|
|
Quickly insert a monthly or a yearly calendar in Excel
|
Written by xiaoyang |
Hits: 148484
|
|
Quickly import or insert data from another worksheet or text files in Excel
|
Written by xiaoyang |
Hits: 97686
|
|
Quickly create and insert unique sequential numbers in Excel
|
Written by kelly |
Hits: 60683
|
|
Quickly change date format in Excel
|
Written by xiaoyang |
Hits: 76279
|
|
Quickly insert a date or a formatted date in Excel
|
Written by xiaoyang |
Hits: 67665
|
|
Quickly delete all hidden worksheets with one click in Excel
|
Written by xiaoyang |
Hits: 66199
|
|
Select interval (every other) rows or columns in Excel
|
Written by xiaoyang |
Hits: 120484
|
|
Quickly compare two ranges to select / shade duplicate or unique values in Excel
|
Written by xiaoyang |
Hits: 101230
|
|
Quickly set row height or column width in inches, pounds, centimeters or pixels
|
Written by xiaoyang |
Hits: 75766
|
|
Quickly create folders based on cell values in Excel
|
Written by xiaoyang |
Hits: 38619
|
|
Quickly copy multiple selections in Excel
|
Written by xiaoyang |
Hits: 76076
|
|
Fill blank cells with value above or 0 in Excel
|
Written by kelly |
Hits: 71514
|
|
Alternately insert blank rows or columns every other rows / columns in Excel
|
Written by kelly |
Hits: 166763
|
|
Quickly select specific cells, entire rows or entire columns based on criteria in Excel
|
Written by kelly |
Hits: 164805
|
|
Quickly select, deselect, and reverse multiple ranges in Excel
|
Written by kelly |
Hits: 71948
|
|
Quickly fetches values from cells for calculation and insert result into cells
|
Written by kelly |
Hits: 55752
|
|
Easily replace formulas with calculated values/results in cells in Excel
|
Written by kelly |
Hits: 83020
|
|
Quickly convert 2-dimensional/cross table to list in Excel
|
Written by kelly |
Hits: 86139
|
|
Quickly convert / force text to number or number to text in Excel
|
Written by kelly |
Hits: 90243
|
|
Quickly replace multiple accented characters with regular chars in Excel
|
Written by kelly |
Hits: 60741
|
|
Quickly select cells with error values in Excel
|
Written by kelly |
Hits: 48956
|
|
Kutools for Excel 4.00: More features and faster!
|
Written by ZhouMandy |
Hits: 35259
|
|
Quickly remove all Macros within worksheet or workbook in Excel
|
Written by siluvia |
Hits: 35776
|
|
Quickly delete all Charts, text boxes and embedded OLE objects in Excel
|
Written by siluvia |
Hits: 41878
|
|
07 February 2012 Kutools for Excel 3.50
|
Written by ZhouMandy |
Hits: 36661
|
|
Quickly modify and manager multiple cell comments in Excel
|
Written by siluvia |
Hits: 53783
|
|
Transpose (convert) a single column or row to ranges or vise versa in Excel
|
Written by ZhouMandy |
Hits: 72118
|
|
Quickly Select Cells Based on color or formatting in Excel
|
Written by siluvia |
Hits: 42586
|
|
Quickly replace or change names in formulas with cell reference in Excel
|
Written by siluvia |
Hits: 77528
|
|
Quickly copy page setup from one worksheet to others or entire workbook in Excel
|
Written by ZhouMandy |
Hits: 37357
|
|
Print multiple ranges / selections into one page in Excel
|
Written by ZhouMandy |
Hits: 64703
|
|
Quickly copy exact formulas without changing cell references in Excel
|
Written by siluvia |
Hits: 49316
|
|
Quickly list all files and sub-directories of a folder or directory in Excel
|
Written by siluvia |
Hits: 72276
|
|
Quickly export range as image file (Jpg, Png or Gif) in Excel
|
Written by siluvia |
Hits: 50720
|
|
Quickly show all hidden worksheets with one click in Excel
|
Written by ZhouMandy |
Hits: 47937
|
|
Quickly shade or color every other row / column in Excel
|
Written by ZhouMandy |
Hits: 43846
|
|
Quickly create worksheets from a list of worksheet names in Excel
|
Written by siluvia |
Hits: 90464
|
|
Quickly combine (merge) multiple columns or rows in Excel
|
Written by kelly |
Hits: 238394
|
|
Quickly export or save a range as CSV, HTML, PDF or Workbook in Excel
|
Written by sun |
Hits: 61244
|
|
Quickly list all worksheet names with hyperlinks as table of contents of workbook
|
Written by ZhouMandy |
Hits: 62569
|
|
Easily Swap Cells, Rows, Columns or Ranges in Excel
|
Written by sun |
Hits: 78508
|
|
Quickly change sign of numbers in Excel
|
Written by sun |
Hits: 100555
|
|
Synchronous select same cells in all worksheets of Excel
|
Written by sun |
Hits: 66697
|
|
Convert cell reference to relative / absolute reference in Excel
|
Written by ZhouMandy |
Hits: 107690
|
|
Unhide all hidden workbook windows with one click in Excel
|
Written by sun |
Hits: 45950
|
|
Quickly apply mathematical operations without using formula in Excel
|
Written by sun |
Hits: 82292
|
|
Quickly convert between various measurement units without using formula in Excel
|
Written by sun |
Hits: 80475
|
|
Quickly Convert Currency (USD to EURO / USD to GBP) in Excel
|
Written by ZhouMandy |
Hits: 90792
|
|
Quickly print multiple workbooks or worksheets from directories in Excel
|
Written by sun |
Hits: 32892
|
|
Quickly replace formulas error messages with zero, blank cells, or text
|
Written by sun |
Hits: 47012
|
|
Using random generator to insert random numbers, dates and passwords in Excel
|
Written by ZhouMandy |
Hits: 74426
|
|
Quickly format text or characters as superscript or subscript in Excel
|
Written by ZhouMandy |
Hits: 65427
|
|
15 November 2011 Kutools for Excel 3.00
|
Written by ZhouMandy |
Hits: 63297
|
|
Quickly hide or unhide workbooks and sheets (worksheets) in Excel
|
Written by ZhouMandy |
Hits: 42088
|
|
Quickly set scroll area (hide unselected columns and rows at once) in Excel
|
Written by ZhouMandy |
Hits: 73049
|
|
Quickly change case, add text, remove characters and spaces in Excel
|
Written by ZhouMandy |
Hits: 32709
|
|
Quickly toggle workbook and worksheet settings in Excel
|
Written by ZhouMandy |
Hits: 45358
|
|
Quickly open multiple last files or workbooks on startup in Excel
|
Written by siluvia |
Hits: 38891
|
|
Quickly copy and insert the workbook file path into cell in Excel
|
Written by sun |
Hits: 46102
|
|
Quickly open containing folder or directory of current workbook in Excel
|
Written by sun |
Hits: 29191
|
|
Take a snapshot (backup) of current workbook at any time in Excel
|
Written by ZhouMandy |
Hits: 55566
|
|
Quickly unhide all rows and columns in Excel
|
Written by ZhouMandy |
Hits: 129784
|
|
Delete all hyperlinks from range, worksheets or whole workbook
|
Written by ZhouMandy |
Hits: 37089
|
|
Quickly hide other workbooks (all inactive windows) in Excel
|
Written by sun |
Hits: 28903
|
|
Navigation Pane – List Sheets, Workbooks, Columns, Names and insert auto text in Excel
|
Written by ZhouMandy |
Hits: 110000
|
|
Quickly hide all inactive (all not-selected) worksheets in Excel
|
Written by sun |
Hits: 32370
|
|
Change working area size: show or hide ribbon, formula bar, and status bar in Excel
|
Written by ZhouMandy |
Hits: 91469
|
|
Quickly delete all blank or empty worksheets in Excel
|
Written by siluvia |
Hits: 80232
|
|
Quickly remove or delete all blank rows from bottom / a range in Excel
|
Written by siluvia |
Hits: 123063
|
|
Quickly copy multiple sheets (worksheets) multiple times in Excel
|
Written by sun |
Hits: 89046
|
|
Quickly rename multiple worksheets in Excel
|
Written by sun |
Hits: 90974
|
|
Select max or min (smallest or greatest) value cell in Excel
|
Written by siluvia |
Hits: 76707
|
|
Quickly sort or arrange sheets / worksheets alphabetically in Excel
|
Written by siluvia |
Hits: 105067
|
|
Quickly merge / combine worksheets / workbooks or csv files into one workbook in Excel
|
Written by siluvia |
Hits: 184320
|
|
Quickly split or save each worksheet of one workbook as separate excel / txt / csv / pdf files
|
Written by ZhouMandy |
Hits: 121247
|
