when i use count by color the color method box is greyed out, any ideas?

I want to know how to uninstall Kutools, I cant find out the way to take it off.

Hi I have 2 columns , location and color..

I am looking to split addresses to multiple cells on the same row. I am looking to move data from one cell and split it if it begins with S or N. I want to move the S or N to the previous cell. If the cell has data that does not begin with N or S I want it left alone.

I tried using the split workbook function. It created a the workbook in CSV format as needed but changed the date format to UK format i.e. MM/DD/YYYY? Is there any way to change the default date format?

how do I copy content of notes to adjacent empty cell

I've been trying to get a pop up notification once a certain cell has been modified, but so far I have not succeed.
I have tried the following code but it only works after you manually modified the cell. If that cell changes because it is dependent of another cell, I won't get any pop up. Pleas help me.

Private Sub Worksheet_Change(ByVal Target As Range)

Dim xC As String
Dim xWSName As String
Dim xA As String
xC = "C:C"
xWSName = "Sheet1"
xA = "A1"
If Intersect(Target, Range("C:C")) Is Nothing Then Exit Sub
If IsEmpty(Target) Then Exit Sub
xNum = (Sheets(xWSName).Range(xA).Value)
If (Target.Value) <> "" Then
MsgBox Prompt:="Entry Signal ", Title:="Trading notification"
End If
End Sub

I am trying to copy a range from one tab and paste to another tab with hidden rows using the paste to visible feature but I cannot get it to work. Copying and pasting from the same tab works fine. Please advise.

Hello.

I have a question regarding the Super Filter feature.

If i create a super filter that references columns T(Age) and along the line insert a new column before column T.

The Age column automatically shifts to column U. However, the super filter does not automatically effect this change.

Is there any workaround this?

Thanks.

Bug? When using Distinguish Differences on a column, it does not add a blank row after every change. It does insert the correct number of rows (1 for each change in the column), however, when the changes are one row apart the blank rows are all added at the top of a newly made 'group' of changes.

For example, I have a column with vendor names. It begins with 26 rows that say 3M. It adds one blank row above this name. Following that I have Advanced Affliates in one row, AG Layne in the next, and 9 rows of Amana Tool. Instead of breaking these apart with a row above each it places 3 rows above Advanced Affiliates and 'groups' the rows of these 3 vendors together. This is repeated throughout the sheet. When a vendor name takes up at least 2 rows in the column it seems to properly add a single row at the top of that group, but if that vendor only takes up one row it 'groups' it with the following vendor name(s) until one of the vendors takes up more than 2 rows, then adds multiple blank lines at the top of the 'group.'

Here is an example showing how this looks in my sheet: https://i.imgur.com/WoWinn7.jpg
This function is exactly what I need for my project, but it doesn't seem to be following the intended behavior of the function.

p.s. I tried to register to comment, but never received the verification email. Posting as guest just to submit this potential bug.

I just want to count words in a cell or range of cells, similar to a word count in MS Word. How to please?

can i convert number in indian rupees format in words

How do I turn off the highlighting of the current cell with the corresponding line and column? Thank you

I buy Kutools for excel of my computer. But after my computer broken, i can continue use to kutools on new computer??

I am trying out Kutools for Excel. I'm excited about the Reading Layout feature but it doesn't highlight the correct row. For example, when I click on C5 it highlights column C, and row 7. Additionally, when I tried to enable reading layout the dropdown was grayed out and nonfunctional. I could only use it after saving and closing the worksheet and reopening it. What can I do to correct this problem?

Hi
When I used the Split workbook as .txt on Kutools Plus, it will add unwanted quotas on the exported text. I noticed this happened when the cells in excel contained commas. How can this be fixed?

Hi, is any translation in Arabic language?
thanks.

I'm trying to convert text numbers and I have downloaded Kutoolls 20.00 which does not seem to have this function It sure does not have it in the area that the previous version had it. I'm sure it is still available but I do not know where to look for it. This is the only reason I would pay for this software as this is the only function that I use in excel that does not work for me.

Dear Sir,

Hello, I am using windows 10 and office 2019. I install Kutools on my outlook ,then I started to have winmail to all the senders. If I use a fresh compose mail , it goes well . But if I use reply or forward it comes as winmail. I deleted all the names from my address book but still the same.

I uninstall the Kutools , everything goes well.


Please advise if there is any solution.


Thank you.

Sir, I need to convert multiple sentences into sentence case. Kutools is able to do that, but one problem: if I had intentionally capitalised the first letter of a word (for example, a proper noun such as Delhi), Kutools converts its Upper case into lower case. Delhi becomes delhi. This is not right. How to resolve this? Thank you.

can it work on ipads?

how many computers can i install into if i purchase for one license?

pdf to excel

how to clear cell compare rules or modify the rules

Sir
Just now i have downloaded your tools. but the a no "Compare Cells" the Ktools tab. how can i Use the feature

Greetings,
I'm looking for an Excel encryption solution, among other needs, for my company and Kutools appears to fulfill the requirements [and then some]. The only questions I have is if there is either a) a way to trigger the cell encryption process programmatically or b) the encryption algorithm, keysize, and IV or salt is available for dissemination in order for someone to batch upload encrypted data to a spreadsheet, leaving the Kutools plugin to handle the decryption process.

Thanks for your time,

-Kevin

How do I create a database using Kutools (Checkbox drop list) and make it accessible for others to capture information who do not have Kutools?
Can I lock the worksheet to hold that facility?

how do i put kutools on my excell I downloaded it

What is the easiest way to upgrade to the latest version of kutools if you cannot find your license code? Initially bought the program in 2015.

Hi there, if I buy Kutools, will that be one off payment or is it a subscription and I have to renew it every year?

cerca vert

Ever since I downloaded the program my computer freezes up and then sometimes it stops all together. The problem went away after I uninstalled the program. Is there a fix for this

hI, very very new user. downloaded and executed KUT, but if i open excel and then a file excel quits. Why?

vevy very new user..if I open excel and then a file excel quits? what's wrong?

Can i use kutools on my laptop and desk top with single user purchase?

Issues installing Kuhtools 20 on Windows 10. Trying .exe returned "Installation forbidden by system policy". Trying msi. returned error with data1.cab. and stopped installation. Please review the the installation files published.

Thanks alot

Greetings, How do you enable ku tools plus?

Currency Rates do not update. It gives the following error; An error occurred while attempting to update the currency rates...

I have 1000 csv files in a folder each with the same column format and headers (first Name, last name, title, address, city, state, zip, phone) with exactly 20 rows of information in each csv. Is there a way I can get those 1000 csvs to automatically copy/paste into one Master csv at the same time vs. opening each one individually and copy/paste? I have Kutools and KT Plus and I am not very technical nor a programmer.

i want to repeat kutool utility on selected data. ?

after install this sw , how can i use this /

convert numbers to text selection

I cannot create the file "mals.mail" So I want to change the folder.

Am I able to 'Highlight duplicate cells across a whole workbook. Comparing every worksheet to each other and every permutation

I have just downloaded KuTools trial. However, your software is EXE. Which won't unzip on a Mac. Any ideas? Do you have a Mac version?

Copy a defined range of cells in a row from a Worksheet to next blank row in a table in a subsequent worksheet

any update