Note: The other languages of the website are Google-translated. Back to English
Vpiši se  \/ 
x
or
x
Registracija  \/ 
x

or

Kutools za Excel: Zmogljiva zbirka orodij Excel

Kutools za Excel je zmogljiva zbirka orodij Excel, ki vas osvobodi dolgotrajnih operacij v Excelu. V orodjarni je več kot 300 zmogljivih funkcij za Excel 2019, 2016, 2013, 2010, 2007 in Office 365.

Najnovejša posodobitev:  Kutools za Excel 25.00
Datum: junij 08, 2021
Pozdravljamo vsa vprašanja, povratne informacije in poročila o napakah. Običajno potrebujemo naslednje informacije: Kontaktiraj nas
  • Kratek opis težave in način njene ponovitve (če je primerno).
  • Vaš operacijski sistem (Windows 10, 8, Windows 7 itd.) In informacije o različici vašega Microsoft Officea.
  • Posnetki zaslona, ​​ki ponazarjajo težavo - Kako naredim posnetek zaslona? http://www.take-a-screenshot.org

Naročite se na glasilo:


Vadnice za Kutools za Excel:


Do vadnic za funkcije lahko hitro dostopate tako, da v naslednje ime vnesete ime funkcije. Na primer, če želite vedeti, kako uporabljati Branje pogleda postavitve, samo vtipkati morate reading v iskalno polje.

Ogled skupine:

Track Snap (varnostno kopiranje trenutnega delovnega zvezka): Kadar koli začasno varnostno kopirajte trenutno delovno knjigo
Podokno za krmarjenje: Naštejte vse liste, delovne zvezke, stolpce in imena
Napredno iskanje in zamenjava: Preprosto poiščite in zamenjajte več delovnih listov in delovnih zvezkov
Velikost delovnega območja: Hitro spremenite velikost delovnega območja
Pogled postavitve branja: Preprosto branje / ogled večjega števila vrstic in stolpcev
Pokaži stolpce: Preklopi med vsemi skritimi stolpci, da bodo vidni ali nevidni
Prikaži liste: Preklopi vse skrite liste, da bodo vidni ali nevidni
Skrij / razkrij delovne zvezke in liste: Skrivanje ali razkrivanje delovnih zvezkov in delovnih listov
Možnosti ogleda: Preklopi nastavitve delovnega zvezka in delovnega lista
Nastavite območje drsenja: Nastavite območje drsenja (naenkrat skrijte neizbrane stolpce in vrstice)
Skrij neizbrane liste: Skrij vse neaktivne (ali vse neizbrane) delovne liste
Skrij neaktivni sistem Windows: Skrij druge delovne zvezke (vsa neaktivna okna)
Razkrij vse ponudbe: Razkrij vse vrstice in stolpce
Razkrij vse delovne liste: Pokaži vse skrite delovne liste
Razkrij vse Windows: Razkrij vsa skrita okna delovnega zvezka

Skupina obsega in celic:

Prilagodite velikost celice: Nastavite višino vrstice ali širino stolpca v palcih, funtih, centimetrih ali slikovnih pikah
Združi iste celice: Spoji sosednje celice v stolpec z enakimi podatki / vrednostjo
Odstrani celico: Odklopite celice in izpolnite vrednosti
Obrni vodoravni razpon: Obrni (obratni) vrstni red podatkov stolpcev ali vrstic
Navpični razpon: Obrni (obratni) vrstni red podatkov stolpcev ali vrstic
Prenesi dimenzije tabele: Pretvorite dvodimenzionalno / navzkrižno tabelo v seznam
Obseg preoblikovanja: Prenesite (pretvorite) en stolpec ali vrstico v obsege
Swap območji: Zamenjajte vrstice, stolpce ali obsege
Razvrsti obseg naključno: Naključno razvrstite ali izberite celice, vrstice in stolpce
Primerjaj celice: Preprosto primerjajte dva obsega celic, če sta enaka ali različna
Izberite enake in različne celice: Primerjava dveh obsegov za izbiro podvojenih ali enoličnih vrednosti
Prepreči podvojitev: Preprečite podvojene vnose v stolpcu
Prepreči tipkanje: Preprosto preprečite vnašanje posebnih ali določenih znakov v celice
Dovoli samo vnos določenih znakov v obseg celic
Obsegi kopiranja: Kopirajte več izbir ali obsegov
Pretvori med besedilo in številko: Pretvori / prisili besedilo v številko ali število v besedilo
Pretvori med rimsko in številsko: Pretvori med rimske številke in številke
Pretvori formulo v besedilo: Hitro pretvorite celične formule v besedilne nize
Pretvori besedilo v formulo: Hitro pretvorite besedilni niz v formulo
Pretvori v datum: Ugotovite in pretvorite obliko datuma
Pretvori čas: Pretvorite čas v sekunde / minute / ure
Pretvorba valut: Pretvori valuto (USD v EURO / USD v GBP)
Pretvorba enote: Pretvori merske enote
Pretvorba številskih sistemov: Pretvarjanje med različnimi številskimi sistemi brez uporabe formule
Črkujte številke: Pretvorite ali črkujte številko v angleške besede
Spremeni znak vrednosti: Spremeni znake števil (Popravi negativne znake, ki sledijo / Vse negativne vrednosti spremeni v pozitivne)
Napredne kombinirane vrstice: Hitro združite vrstice na podlagi enake vrednosti
Pretvori številko v redno: Hitro pretvorite številke v redne številke
Dejansko: Formule zamenjajte z izračunanimi vrednostmi / rezultati v celicah
Krog (brez formule): Vrednosti okrogle celice brez formule
Kombiniraj (vrstice in stolpci): Združite (združite) več stolpcev ali vrstic

Skupina za urejanje:

Super najdi:
Poiščite določene besedilne nize samo v komentarjih
Poiščite določen besedilni niz samo v vrednosti celice
Poiščite določene besedilne nize samo v formulah
Poiščite celice, ki vsebujejo vrednosti tipa datuma na podlagi meril
Poiščite številke na podlagi meril
Iščite določene besedilne vrednosti samo v hiperpovezavah
Poiščite vse celice z določenim oblikovanjem celic
Nejasno iskanje: Poiščite in zamenjajte podobne zapise s seznama vrednosti celic
Izberite pomočnik dosega: Izberite, prekličite izbiro in obrnite več obsegov
Izberite intervalske vrstice in stolpce: Izberite intervale (vse druge) vrstice ali stolpce
Izberite združene celice: Poiščite in izberite združene celice
Izberite Zadnje celice: Če želite izbrati zadnjo celico uporabljenega obsega ali zadnjo celico s podatki zadnje vrstice ali stolpca
Izberite celice z največjo ali najmanjšo vrednostjo: Izberite celico z največjo ali najmanjšo (najmanjšo ali največjo) vrednostjo
Izberite celice z vrednostjo napake: Izberite celice z vrednostmi napak
Izberite določene celice: Izberite določene celice, vrstice in stolpce
Izberite celice z obliko: Izberite celice glede na oblikovanje
Izberite odklenjene celice: Hitro izberite vse odklenjene celice
Izberite Neprazne celice: Preprosto izberite celice, ki niso prazne ali prazne
Izberite podvojene in edinstvene celice: Poiščite podvojene ali edinstvene celice / vrstice v obsegu
Vstavi vrstice naslovov: V obseg vstavite naslovne vrstice
Vstavi prazne vrstice in stolpce: Vstavite prazne vrstice ali stolpce v vse druge vrstice / stolpce
Vstavi datum: Vstavite datum z oblikovanjem datuma
Potrditveno polje za serijsko vstavljanje: Hitro vstavite več potrditvenih polj hkrati
Gumb za vstavljanje serijskega vnosa: Hitro vstavite več gumbov hkrati
Vstavi vodni žig: Hitro vstavite in odstranite vodne žige
Samodejno besedilo: Preprosto ustvarite in vstavite samodejni vnos besedila
Vstavi zaporedne številke: Ustvarite in vstavite enolične zaporedne številke
Poiščite manjkajočo zaporedno številko: Hitro poiščite in zapolnite manjkajoče številke
Izpolnite sezname po meri: Ustvarite sezname po meri in z njimi zapolnite celice
Seznam vseh kombinacij: Hitro ustvari / naštej vse možne kombinacije določenih seznamov
Vstavi oznako ali oštevilčenje: Hitro vstavite oznake ali oštevilčenja v več celic v Excelu
Vstavi naključne podatke: Uporaba generatorja naključnih števil za ustvarjanje številk in gesla
Izpolnite prazne celice: Izpolnite prazne celice z vrednostjo nad ali 0
Izbriši prazne vrstice: Odstranite ali izbrišite vse prazne vrstice od spodaj / obsega
Izbriši vrstice in stolpce: Brisanje praznih ali skritih vrstic (stolpcev)
Izbriši orodja: Izbrišite vse grafikone, besedilna polja in vdelane predmete OLE
Brisanje spletnih kontrolnikov: Odstranite vse html predmete, na primer potrditveno polje
Potrditveno polje Batch Delete: Odstrani / izbriši več potrditvenih polj
Gumb za serijsko brisanje možnosti: Gumbi za paketno brisanje
Odstrani vse makre: Odstranite vse makre v delovnem listu ali delovnem zvezku
Paketno odstranjevanje vseh makrov: Skupinsko odstranite ali izbrišite vse makre iz delovnih zvezkov
Odstrani presledke: Odstranite presledke pred / za besedilom ali odstranite odvečne presledke iz besedila
Spremeni velikost: Spremeni velike črke besedila v velike in male črke
Številke indeksa v kemijskih formulah: Pravilno podpiši vse številke v kemijskih enačbah
Odstrani po položaju: Odstranite ali izbrišite znake z začetka / konca besedilnih nizov
Povratni vrstni red besedila: Obrni besedilni niz ali vrstni red besed
Zamenjaj poudarjene znake: Več naglašenih znakov zamenjajte z običajnimi znaki
Izvleček besedila: Hitro izvlecite določeno besedilo iz celic
Izvleček e-poštnega naslova: Izvlecite e-poštni naslov iz besedilnega niza
Dodaj besedilo: Dodajte isto besedilo v vrsto celic
Razdeljena imena: Razdelite imena, imena in priimke
Razdeljene celice: Vsebino celic hitro razdelite po vesolju ali drugih ločevalcih
Izbriši znake: Iz celic odstranite številske, abecedne, ne natisljive ali alfanumerične znake
Nadomestno zasenčenje vrstic / stolpcev: Osenčite vsako drugo vrstico / stolpec
Nadpis / Podpis (oblikovanje): Oblikujte besedilo kot nadpis ali podpis
Uporabi oblikovanje datuma: Uporabite oblikovanje datuma za obseg datumov
Kopiraj oblikovanje celic: Kopirajte oblikovanje celic iz ene celice v druge celice
Počisti oblikovanje vseh celic: Popolnoma počistite vse oblikovanje celic obsega
Pretvori hiperpovezave: Izvlecite url povezave iz hiperpovezav ali pretvorite golo besedilno povezavo v hiperpovezave
Poiščite in prekinite prekinjene povezave: Iskanje in lomljenje prekinjenih povezav (zunanje reference)
Izbriši hiperpovezave: Odstranite vse hiperpovezave obsegov, listov in delovnega zvezka
Kutools Kalkulator: Pride vrednosti iz celic za operacije in rezultate prilepi v celice
Operacijska orodja: Uporabi matematične operacije za obseg brez formule
Spremeni obliko komentarja: Spremenite obliko polja za komentar
Orodja za komentarje celic: Spremenite komentarje več celic
Ustvari seznam komentarjev: Hitro izvlecite in dodajte vse komentarje na nov delovni list ali delovni zvezek
Oblika komentarja: Vse komentarje hitro oblikujte na podlagi komentarja
Poišči / zamenjaj besedilo komentarja: Hitro poiščite in zamenjajte besedilo v komentarjih
Odstrani / dodaj uporabniško ime v komentar: Hitro spremenite / odstranite / dodajte ime avtorja v komentarjih
Pretvori komentar in celico: Hitro pretvorite med vsebino celice in komentarje
Komentar AutoFit: Samodejno prilagodi velikost komentarjev tako, da ustreza vsebini

Formula skupina:

   Funkcije:

Štetje po barvi celice: Uporaba funkcije za štetje / seštevanje celic po barvi polnila ali pisave
Grof Char: Štejte pojavitve znakov v nizu
Izvleček številk: Izvleči številke iz mešanega besedilnega niza s funkcijo
Povratno besedilo: Preprosto obrnite vrstni red znakov v celici s funkcijami
Vsota s krepko pisavo: Hitro seštejte samo krepke vrednosti / številke
Štetje s krepko pisavo: Preprosto preštejte število samo krepkih celic v obsegu
KONČNO: Preprosto samo seštevanje / štetje / povprečenje vidnih celic, vrstic ali stolpcev

   Formule:

Dodajte ure / minute / sekunde do datuma: Preprosto dodajte ure / minute / sekunde datumu in času
Dodajte leta / mesece / dni / tedne do danes: Dodajte leta / mesece / dni / tedne do danes
Izračunajte starost glede na rojstni dan: Izračunajte starost glede na datum rojstva
Seštevek števil v celici: Seštejte vse številke / številke v celici
Vsota absolutnih vrednosti: Preprosto seštejte absolutne vrednosti v območju
Poiščite vrednost na seznamu: Hitro poiščite vrednost in vrnite drugo celico iz tabele
Štejte vikende med dvema datumoma: Hitro preštejte število vikendov / delavnikov / določenih dni v tednu med dvema datumoma
Poiščite n-ti pojav znaka: Preprosto poiščite položaj n-tega pojavljanja znaka v besedilnem nizu
Štetje besed v obsegu: Hitro preštejte število besed
Poiščite najpogostejšo vrednost: Hitro preštejte število besed
Odstrani čas z datuma: Hitro trajno odstrani čas iz datuma

Natančna kopija formule: Kopirajte natančne formule brez spreminjanja sklicev na celice
Pretvori reference: Pretvori sklic na celico v relativni / absolutni sklic
Zamenjaj imena obsegov: Ime v formulah zamenjajte s sklicem na celico
Skrij / razkrij ime obsega: Preprosto skrijete ali razkrijete imenovani obseg
Čarovnik za napake: Sporočila o napakah formul zamenjajte z nič, prazne celice ali prilagodite besedilo
Dinamično glej delovne liste: Hitro napolnite sklice na celice z več delovnih listov
Precedenti sledenja in odvisni: Hitro izsledite vse vzdrževane osebe ali precedente

Skupina delovnih zvezkov in listov:

Orodja za delovne zvezke

Razdeljeni delovni zvezek: Vsak list / delovni list razdelite ali shranite iz delovnega zvezka kot eno samo datoteko Excel
Pretvornik oblike datoteke: Pretvorite več datotek XLSX v datoteke XLS ali PDF
Vstavite podatke o delovnem zvezku: Vstavite ime datoteke ali pot v celico / glavo ali nogo
Odprta mapa, ki vsebuje: Odprite trenutni imenik / mapo aktivnega delovnega zvezka
Kopiraj celotno pot: Kopirajte in vstavite ime in pot aktivne datoteke delovnega zvezka
Naslednjič samodejno odprite te delovne zvezke: Samodejno odpri določene delovne zvezke, ko se zažene Excel
Združite delovne liste:


Združite več delovnih listov / obsegov iz delovnih zvezkov v en delovni list
Združite / združite vse istoimenske delovne liste v delovnih zvezkih v en delovni list
Združite / združite delovne liste ali delovne zvezke v en delovni zvezek
Povzemite in izračunajte podatke iz več delovnih listov v en delovni list

Orodja za delovne liste

Sinhronizacija delovnih listov: Sinhrono izberite iste celice na vseh delovnih listih
Razvrsti liste: Razvrščajte ali razvrščajte liste / delovne liste po abecedi
Zamrzni podokna več delovnih listov: Zamrzni podokna na več delovnih listih
Odmrznite več delovnih listov podoken: Odmrznite podokna na več delovnih listih
Preimenuj več delovnih listov: Preimenujte več delovnih listov
Ustvari seznam imen listov: Ustvarite kazalo listov v aktivnem delovnem zvezku
Kopiranje več delovnih listov: Kopirajte ali vstavite več delovnih listov
Ustvari delovne liste zaporedja: Ustvarite nov delovni zvezek s prilagojenimi imeni delovnih listov
Večni koledar: V Excel vstavite mesečni ali letni koledar
Razdeljeni podatki: Razdelite podatke na več listov
Izbriši prazne delovne liste: Z enim klikom izbrišite vse prazne delovne liste
Izbriši vse skrite liste: Z enim klikom izbrišite vse skrite delovne liste
Izbriši vse neaktivne liste: Iz delovnega zvezka izbrišite vse liste, razen trenutnega / aktivnega
Združite delovne liste: Združi več delovnih listov ali delovnih zvezkov v en delovni zvezek
Spajanje tabel: Posodobite ali združite tabele z ujemanjem stolpca iz dveh delovnih listov / delovnih zvezkov
Izvozi obseg v datoteko: Izvozite ali shranite obseg kot CSV, HTML in delovni zvezek
Obseg izvoza v obliki grafike: Izvozi obseg kot slikovno datoteko
Izvozi grafiko: Shranite in izvozite grafikone grafikonov (slike ali oblike) kot slikovne datoteke JPEG
Vstavi datoteko v kazalec: Vstavite vsebino datotek CSV, Excel, Text ali PRN na položaj kazalca
Seznam imen datotek: Pridobite in ustvarite seznam imen datotek v mapi ali imeniku
Ustvari mape na podlagi vsebine celic: Ustvarite mape na podlagi vrednosti celic
Čarovnik za tiskanje več delovnih zvezkov: Natisnite več delovnih zvezkov iz imenika
Čarovnik za tiskanje večkratnega izbora: Natisnite več obsegov / izbir na eno stran
Natisni strani v obratnem vrstnem redu: Preprosto tiskajte strani v obratnem vrstnem redu
Vstavi prelom strani v vsako vrstico: Hitro vstavite prelom strani vsakih x vrstic na Excelovem delovnem listu
Dodaj obrobo na vsako stran: Hitro dodajte in natisnite obrobo okoli vsake strani
Kopiraj nastavitev strani: Kopirajte in uporabite nastavitve za nastavitev strani z enega delovnega lista na druge
Stranski vmesni seštevek: Vstavljanje in tiskanje vmesnih seštevkov na vsako natisnjeno stran
Natisnite prvo stran vsakega delovnega lista: Hitro natisnite prvo stran vsakega delovnega lista
Uvozi slike: V celice vstavite več slik in jih lepo razporedite
Uvoz slik ujemanja: Uvozite slike v celice na podlagi vrednosti celice
Natisni več stolpcev: Tiskanje seznama v več stolpcev, ki ustreza vsaki natisnjeni strani
Natisni trenutno stran: Natisni trenutno natisnjeno stran aktivne celice

Varnostna skupina:

Šifriraj celice: Šifriraj in dešifriraj izbrane vrednosti celic ali vsebino
Dešifriraj celice: Šifriraj in dešifriraj izbrane vrednosti celic ali vsebino
Zaščita delovnega lista: Zaščitite več listov / delovnih listov hkrati
Odstranite zaščito delovnega lista: Odstranite zaščito več delovnih listov / listov hkrati
Ustvari poštni seznam: Preprosto ustvarite poštni seznam v Excelu
Pošlji e-pošto: Pošiljanje e-pošte na podlagi poštnega seznama v Excelu

Skupina za pošiljanje:

Ustvari poštni seznam: Hitro ustvarite seznam prejemnikov v Excelovi tabeli
Pošlji e-pošto: V večjem obsegu pošiljajte prilagojena e-poštna sporočila več prejemnikom

Skupina filtrov in statistik:

Štetje po barvi: Izračunajte vrednost celic na podlagi ozadja celice ali barve senčenja
Stranski vmesni seštevek: Vstavljanje in tiskanje vmesnih seštevkov na vsako natisnjeno stran
Napredno razvrščanje: Preprosto razvrstite podatke po priimku / mesecu / pogostosti / dolžini besedila
Super filter: Filtrirajte podatke na podlagi vrednosti celice z več merili
Filtriraj krepko: Filtriraj vse celice po krepkih znakih
Filtriraj ležeče: Filtriraj vse celice po ležečem tisku
Filtriraj prečrtano: Filtriraj celice s prečrtanjem
Filtriraj komentar: Filtriraj vse celice s komentarji
Formula filtra: Filtrirajte vse celice, ki vsebujejo formulo
Združeni filter: Filtrirajte združene celice
Poseben filter:
Filtriraj celice z velikimi / malimi črkami
Filtriraj celice po dolžini besedila
Filtrirajte celice po delovnem dnevu / vikendu / določenem dnevu v tednu
Filtriraj celice po barvi pisave
Filtriraj celice po barvi ozadja
Prilepite v vidno območje: Kopirajte podatke in jih prilepite v samo vidne celice / filtriran seznam
Izbirna ključavnica: Preprosto konfigurirajte celice za zaklepanje ali odklepanje
Odklepanje izbire: Preprosto konfigurirajte celice za zaklepanje ali odklepanje
Označeno Odklenjeno: Hitro označite / obarvajte vse odklenjene celice
Skrij formule: Hitro skrijete ali razkrijete formule
Razkrivanje formul: Hitro skrijete ali razkrijete formule
Označi skrito: Hitro označite celice s skritimi formulami
Formule za poudarjanje: Hitro označite vse celice formule
Označite imena: Hitro označite vse imenovane obsege
Prikaži glave: Hitro skrijete in prikažete glave stolpcev in vrstic
Pokaži formule: Preprosto prikažite ali prikažite vse formule celic
Say something here...
symbols left.
You are guest
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    frnaill · 3 years ago
    Can you select a range of worksheets or specific worksheets from the navigation pane?
  • To post as a guest, your comment is unpublished.
    jerome · 3 years ago
    Hello.
    Please is there a way to remove duplicates only if they are subsequent? And making it to count from 1 again once there is a break.
    I tried the select duplicates feature but it does not start to count again after a break. It recognizes if the value was counted before. Please help. Thanks
  • To post as a guest, your comment is unpublished.
    atieghi · 3 years ago
    Kutools do not start when excel starup
    • To post as a guest, your comment is unpublished.
      qiuhongkun · 3 years ago
      Hello,
      Please go to check your Excel add-ins manager. Please go to download and install the software with the EXE installation package.
      BTW, Please don'r post such question here. We will not answer you quickly. Please contact us with the email.
  • To post as a guest, your comment is unpublished.
    Simon Greenwood · 3 years ago
    Every time I try to use the Kutools plugin for Excel, it crashes. Excel simply closes down. Is this a known issue? Is there a solution? Thanks. Si
  • To post as a guest, your comment is unpublished.
    Damodar · 3 years ago
    Is there an issue of using the Right Mouse Button with Kutools Add-in in Office 365
  • To post as a guest, your comment is unpublished.
    Nadin · 3 years ago
    Please advise how to add-in the Kutools in excel. I add in the add-ins, however, it does not appear. Please help.
  • To post as a guest, your comment is unpublished.
    Martin Dijk · 3 years ago
    I just got Kutools Yesterday and saved me a lot of time using "Dynamically refer to worksheets...". I also need to do exact to opposite. So:
    - value cell B3 of sheet 1 should go to cell D4 of sheet 2;
    - Value cell B4 of sheet 1 should go to cell D4 of sheet 3
    - value cell B5 of sheet 1 should go to cell D4 of sheet 4
    etc.

    Does Kutools facilitate this and if so feature should I use or is VBA the only option?


  • To post as a guest, your comment is unpublished.
    paula hegarty · 3 years ago
    add 0 to beginning of numbers in a column. I have exported a csv file of over 3000 names and numbers and had to format the column so as the number shows correctly by changing the decimal place to 0 but this has removed all the 0 off the beginning of the numbers. How can i get the 0's back
  • To post as a guest, your comment is unpublished.
    pratap singh · 3 years ago
    Please help to convert the 22.1.2018 to 22-jan-2018
  • To post as a guest, your comment is unpublished.
    qiuhongkun · 3 years ago
    Please don't post any comments after this article. We will not answer it. Please use the forum
    https://www.extendoffice.com/forum/kutools-for-excel.html or contact us with email.
  • To post as a guest, your comment is unpublished.
    blueoaks · 3 years ago
    I am trying out your Excel plugin. To test, I deliberately copied data in 2 cells from 1 range and pasted them exactly into another range on a sheet in the same workbook, then used your 'compare cells' tool and it does not find a match. Repeated test many times. Not sure if its working for others, but definitely not for me. Will not be purchasing. Excel 2010 on Windows 10 PC.
    • To post as a guest, your comment is unpublished.
      qiuhongkun · 3 years ago
      Hello,
      Once again, please don't post any comments after this article. We will not answer it. Please use the forum or contact us with email.
      BTW, it work, please take a look at https://www.extendoffice.com/product/kutools-for-excel/excel-compare-ranges,-rows-and-columns.html
  • To post as a guest, your comment is unpublished.
    pdn.update@gmail.com · 3 years ago
    Hello
    when I downloaded Kutools for excel I saw that it can be usable for 45 days trial But when I installed it a window with license and purchase appeared please give me the answer I want to try some issues and buy the license later.

    Thanks
  • To post as a guest, your comment is unpublished.
    Jeffrey Stitt · 3 years ago
    I am trying out your software in excel and using the To Actual button.

    i don't know if there is a limit to the amount of cells it can change at one time but i was trying it out on 13755 cells and i get most of them converted but about 1200 to 1500 of them convert to #Ref.

    Let me know what you think.
  • To post as a guest, your comment is unpublished.
    sureshkumar · 3 years ago
    how to use excel files with this software
  • To post as a guest, your comment is unpublished.
    Nigel Attwood · 3 years ago
    I am using the reading layout and cannot edit comments in this mode, I can delete them and create them just not edit which is a pain having to rewrite the whole comment. It is a large spreadsheet W columns and 5800 rows so far with the W column holding extensive comments on each record.
  • To post as a guest, your comment is unpublished.
    Ekta · 3 years ago
    In Excel, I have business names list in one sheet and its outwit export contact data(sheet2)(address, Page title,business url,Source url...) but it does not contain business name. So, I want to add business name column to its businessurl in sheet2. I have large no of records in excel sheet.

    For ex:
    In sheet1: In sheet2:
    abc www.wh.com
    xyz www.xy.com
    White House www.abc.com

    1) how I will get business urls name to its adjecent column.
    2) how can I check business name from its url.
  • To post as a guest, your comment is unpublished.
    Guest · 3 years ago
    How to Activate License to the KU Tool
  • To post as a guest, your comment is unpublished.
    sanket dayama · 3 years ago
    Can anyone guide me how to buy this?

    https://www.extendoffice.com/order/kutools-for-excel.html
  • To post as a guest, your comment is unpublished.
    George · 4 years ago
    Hi. installed free version to test and evaluate before purchasing. Problem is KUTOOLS don't show on my ribbon, no idea why. After installation I was prompted to start Excel, which I did, then, closed it and now KUTOOLS doesn't show. Any idea why?
    • To post as a guest, your comment is unpublished.
      qiuhongkun · 4 years ago
      Hello,
      Please don't post such issue after this article.
      Please contact us via jaychivo@extendoffice.com with the detailed information.
      Please go to check your Excel add-ins manager. Can you see the Kutools for Excel in your Excel add-ins manager?
      Please try to enable both Kutools for Excel add-ins in your Excel add-ins manager.
      Thanks in advance.
  • To post as a guest, your comment is unpublished.
    Esther · 4 years ago
    I've been receiving a circular reference message every time I open an excel workbook regardless if it is blank or has data on it. How do I make this go away?
  • To post as a guest, your comment is unpublished.
    Andrew · 4 years ago
    How do I do a weighted random selection in an excel list? For example, I am running a competition where you get more chances to win for every $5 you save.
  • To post as a guest, your comment is unpublished.
    Erin · 4 years ago
    Good Morning: I have purchased a license for Kutools for all MS products after successfully using the free version for excel. I loved the addin; however, since purchase NONE of the plugins work- in fact, if I attempt to use any function of the add-in my program, anyone that I'm using, crashes. This was a considerable investment and yet I have less access than I did when I was using a free version for excel.
    • To post as a guest, your comment is unpublished.
      qiuhongkun · 4 years ago
      Hello,
      Please don't post such topic here. If you want to get the support quickly, please contact us via jaychivo@extendoffice.com or post the topic in the forum section.
  • To post as a guest, your comment is unpublished.
    zaidoon · 4 years ago
    Hi, I have multi Excel file with data like

    YES
    YES
    YES
    YES
    NO
    NO
    NO
    NO
    NO
    NO
    NO
    NO
    NO
    NO
    NO
    NO
    NO
    NO
    NO

    can I change like 50% of NO to YES using VBA? How? thanks
    • To post as a guest, your comment is unpublished.
      qiuhongkun · 4 years ago
      Hello,
      Please use the forum for help.
      • To post as a guest, your comment is unpublished.
        Jay · 3 years ago
        I ordered it with PayPal how do I get the installation information?
  • To post as a guest, your comment is unpublished.
    vml · 4 years ago
    hi

    can i transfer the purchased kutools from my office computer to personal
  • To post as a guest, your comment is unpublished.
    Ryan · 4 years ago
    I have emailed twice to receive my registration information but have not received anything can you please assist me?
  • To post as a guest, your comment is unpublished.
    Deepak Kumar · 4 years ago
    Hi can i get freeware version of Kutool (may be limited options) for long term?
    • To post as a guest, your comment is unpublished.
      Excelfans · 4 years ago
      Sorry, we don't have such version.
  • To post as a guest, your comment is unpublished.
    wtw1326@gmail.com · 4 years ago
    Can my license name and code be emailed to me?
    • To post as a guest, your comment is unpublished.
      qiuhongkun · 4 years ago
      Hello,
      Please try to contact us via jaychivo@extendoffice.com with your order information.
  • To post as a guest, your comment is unpublished.
    yorm · 4 years ago
    my free trial has expired and i am trying to purchase but i am being told my details cannot be be verified, i need help
  • To post as a guest, your comment is unpublished.
    Simon W · 4 years ago
    I am looking for previous versions of Kutools for excel but all links lead to V16.5. My licence expired in July. Please assist...
    • To post as a guest, your comment is unpublished.
      qiuhongkun · 4 years ago
      Hello,
      You can install the old version from https://www.extendoffice.com/downloads/History-Kutools-for-Excel/16.00/KutoolsforExcelSetup.exe
      You can contact us with your order information via jaychivo@extendoffice.com.
  • To post as a guest, your comment is unpublished.
    carlo.vaiani@gmail.com · 4 years ago
    I have a problem with Work Area utility.
    When I use it at work with two displays attached to my laptop, the pop up panel with the 4 profile buttons shows up correctly
    Instead, when I use the same at home on the same laptop without additional screen, the pop up does not show up correctly (see attachment).
    I already tried changing scaling and resolution settings, but nothing changed.
    • To post as a guest, your comment is unpublished.
      qiuhongkun · 4 years ago
      Hello All,
      Please try to use the forum to post your issue or feedback https://www.extendoffice.com/forum/kutools-for-excel.html
      Or please send an email to jaychivo@extendoffice.com.
      Please don't post your issue after this article.
      1. Please make sure you have installed the latest version.
      2. Please tell me the version informaiton of your Office and computer system.
      Thanks in advance.
  • To post as a guest, your comment is unpublished.
    MDodin · 4 years ago
    Hi,
    I just purchased the Kutools for excel. How do I activate it ?
    • To post as a guest, your comment is unpublished.
      qiuhongkun · 4 years ago
      You can go to register the software in the Setting Center or go to register as shown in the attached screenshot.
  • To post as a guest, your comment is unpublished.
    Jotham Wadongo · 4 years ago
    Hi I am Jotham. I have purchased a single license user software but when I try to update it refuses to work. What would be the issue?
  • To post as a guest, your comment is unpublished.
    Joe · 4 years ago
    Will this product work on Excel 2016 64bit Office 2016?
    • To post as a guest, your comment is unpublished.
      qiuhongkun · 4 years ago
      Yes, this software is compatible with the Microsoft Office 2007 / 2010 / 2013 / 2016 / Office 365, 32 bit or 64 bit of all series. (ok)
      Please go to have a 60-day free trial from https://www.extendoffice.com/downloads/KutoolsforExcelSetup.exe.
  • To post as a guest, your comment is unpublished.
    Winnie · 4 years ago
    Hi, I am trying the trial version of Kutools to insert multiple pictures matching with their names. I followed every step described in the website, but the image still comes out from the image sequences instead of matched names image. Any idea what goes wrong?
    • To post as a guest, your comment is unpublished.
      qiuhongkun · 4 years ago
      Please try to contact me via jaychivo@extendoffice.com.
      Please try to show how to replicate your operation.
      Thanks in advance.
  • To post as a guest, your comment is unpublished.
    Lauren · 4 years ago
    I emailed as I ordered this and my computer got messed up and when I went to reload it I couldnt
    • To post as a guest, your comment is unpublished.
      qiuhongkun · 4 years ago
      Hello,

      Please try to contact me with your order informaiton via jaychivo@extendoffice.com.

      Please be more specific about your issue.
      Thanks in advance.
  • To post as a guest, your comment is unpublished.
    Ashley · 4 years ago
    When I try to combine worksheets it either doesn't combine in the file when I open it or says that I have exceeded the size (in which case, I do not have that much data)
    • To post as a guest, your comment is unpublished.
      qiuhongkun · 4 years ago
      Please try to create some sample data in a new workbook and try it again.
      If the problem persists with the sample workbook, pleas send the workbook to us via jaychivo@extendoffice.com.
      Please be more specific about your operations.
  • To post as a guest, your comment is unpublished.
    Melissa · 4 years ago
    HI,
    I downloaded the trial version to see if we should purchase. I used the advanced combine rows but after my data refreshes, they go back to uncombined. Is there a way to make them stay combined (or recombine)? Others will be using this workbook and they don't have the add-in.
    Thanks
    • To post as a guest, your comment is unpublished.
      qiuhongkun · 4 years ago
      Please try to create some sample data in a new workbook and try it again.
      If the problem persists with the sample workbook, pleas send the workbook to us via jaychivo@extendoffice.com.
      Please be more specific about your operations.
  • To post as a guest, your comment is unpublished.
    Kanokwan · 4 years ago
    Hi, I was sent email to Jay Chivo but he not reply my email for more than 20 hours.
    I have problem to use Kutool Excel after purchase and when in open excel and try to use Kutool and Enterprise but excel shut down after click. Even I create new excel file but it's also the same. Delete, Download and install it's still same.
    • To post as a guest, your comment is unpublished.
      Andrew · 4 years ago
      I too am having the exact same issue? is there a fix for this as yet?
      • To post as a guest, your comment is unpublished.
        jaychivo · 4 years ago
        Please try to contact me with your order information via jaychivo@extendoffice.com. We will help you solve it immediately.
    • To post as a guest, your comment is unpublished.
      ehtesham · 4 years ago
      I am having the same problem too. I am using Excel 2013... :( Did you get any fix for this?
      • To post as a guest, your comment is unpublished.
        jaychivo · 4 years ago
        Please try to contact me with your order information via jaychivo@extendoffice.com. We will help you solve it immediately.
  • To post as a guest, your comment is unpublished.
    Tracy Colegrove · 4 years ago
    Hi,

    We just started a trial version yesterday & heavily used the 'Advanced Combine option' yesterday without issue. Today I'm having to submit the combine request twice before the function works.

    Windows 10 running Excel 2016

    Thank you
    • To post as a guest, your comment is unpublished.
      Admin_jay · 4 years ago
      [quote name="Tracy Colegrove"]Hi,

      We just started a trial version yesterday & heavily used the 'Advanced Combine option' yesterday without issue. Today I'm having to submit the combine request twice before the function works.

      Windows 10 running Excel 2016

      Thank you[/quote]

      Can you get it done? If no, please try to contact us with the detailed information via jaychivo@extendoffice.com
  • To post as a guest, your comment is unpublished.
    steve smith · 4 years ago
    Hi,
    I love this product. Do you have a portable version that i could use at work?
    Thank You,
    Steve :-)
    • To post as a guest, your comment is unpublished.
      Admin_jay · 4 years ago
      [quote name="steve smith"]Hi,
      I love this product. Do you have a portable version that i could use at work?
      Thank You,
      Steve :-)[/quote]
      Sorry, we don't have a portable version. :)
  • To post as a guest, your comment is unpublished.
    Garima · 4 years ago
    Hi,

    I have a pivot table with multiple row fields wherein i have to look for a specific value. Is it possible to use Kutools and get data for these multiple row fields. I have mentioned an example below-

    Status Count
    Closed --- 2
    Dev ---- 1
    Live ----- 1
    Open ----- 5
    Test ---- 3
    Live ----- 1
    Dev ----- 1

    In this case if we want to count total number of defects that were raised in Dev Environment then ideally the count should be 2 [ Closed-1+Open-1]. So can you please confirm if it is possible to calculate the total count using Lookup formula of Kutools. If yes, can you please assist on how this can be done ?
  • To post as a guest, your comment is unpublished.
    Andrew · 4 years ago
    Hello, I accidentally moved the Kutools folders when I was trying to clean up my documents on the computer and now whenever I open excel I get the error message that reads "Access violation at address 07ED2750 in module 'PANEFO~1.DLL', Read of address 000000000" and when excel opens, the words in the navigation pane are not in English. How do I resolve?
    • To post as a guest, your comment is unpublished.
      Admin_jay · 4 years ago
      [quote name="Andrew"]Hello, I accidentally moved the Kutools folders when I was trying to clean up my documents on the computer and now whenever I open excel I get the error message that reads "Access violation at address 07ED2750 in module 'PANEFO~1.DLL', Read of address 000000000" and when excel opens, the words in the navigation pane are not in English. How do I resolve?[/quote]

      Please try to reinstall the software. If the problem persists after installation, please contact me via jaychivo@extendoffice.com.
  • To post as a guest, your comment is unpublished.
    tom · 4 years ago
    Hi Admin

    i use your kutools a lot but currently we only use your very old version 5. We tried 6 but you changed the way photos are imported therefore you kindly helped us revert back to the old version.

    My new laptop will not open up the user interface big enough for me to actually select the option the photos and the sizes therefore can no longer continue to use this version. I have seen the newest version is 16 so it has come a long way over the past few years. the newer version isn't as good as the older one with regards to the importing of the photos. but it is useable :)

    please can someone contact me via my email address so i can call someone to explain what it is i am trying to do to see if i have missed the function. I end up getting duplicate photos at the end.

    Thank you for your help.
    • To post as a guest, your comment is unpublished.
      Admin_jay · 4 years ago
      [quote name="tom"]Hi Admin

      i use your kutools a lot but currently we only use your very old version 5. We tried 6 but you changed the way photos are imported therefore you kindly helped us revert back to the old version.

      My new laptop will not open up the user interface big enough for me to actually select the option the photos and the sizes therefore can no longer continue to use this version. I have seen the newest version is 16 so it has come a long way over the past few years. the newer version isn't as good as the older one with regards to the importing of the photos. but it is useable :)

      please can someone contact me via my email address so i can call someone to explain what it is i am trying to do to see if i have missed the function. I end up getting duplicate photos at the end.

      Thank you for your help.[/quote]

      Please contact us via jaychivo@extendoffice.com
  • To post as a guest, your comment is unpublished.
    Leasha Riggs · 4 years ago
    Hello
    I just installed the software and used your free trial and loved it.
    Im trying to split the data into multiple worksheets and im only getting the new tabs and the header.. no data
    didnt have this problem in the free trial version.

    How do I resolve?
    big project due Monday.. please help
    • To post as a guest, your comment is unpublished.
      Admin_jay · 4 years ago
      [quote name="Leasha Riggs"]Hello
      I just installed the software and used your free trial and loved it.
      Im trying to split the data into multiple worksheets and im only getting the new tabs and the header.. no data
      didnt have this problem in the free trial version.

      How do I resolve?
      big project due Monday.. please help[/quote]

      Please try to create some sample data in new workbook and try it again.

      If the problem persists with the sample workbook, please contact me via jaychivo@extendoffice.com.

      Please attach the sample workbook in your email.
  • To post as a guest, your comment is unpublished.
    Sean Tarantino · 4 years ago
    Fantastic plugin!
    I am having one odd issue that maybe you could help with.
    I have a sheet with data out to column w and almost 12,000 rows. I am splitting the data by a value of one of the columns and naming the sheets after the name of the data in those columns and it ALMOST works perfectly. Its splitting out all the data as it should into the properly named new sheets, but what is happening is I am getting about 30 sheets not named properly and named as the default sheet name. Those sheets have the data they should, but are just not taking the name of the column values like all the others. Is this just too big of an operation and it is having errors, or is there something I could do to the master sheet to help fix what may be happening because it seems to be the same data groups doing it each time.
    Thank you!
  • To post as a guest, your comment is unpublished.
    Ajaz · 4 years ago
    Dear, i have values in a range of cell, say fromA1: A100. In another cell C1 i have value 200. Now i will start adding A1 with A2 if the result value is less than C1 i will again add A1 to A3 if the sum is less than C1 i will again add A1:A4 and so on untill the sum is more or equal to C1. How can i do that
    • To post as a guest, your comment is unpublished.
      admin_jay · 4 years ago
      [quote name="Ajaz"]Dear, i have values in a range of cell, say fromA1: A100. In another cell C1 i have value 200. Now i will start adding A1 with A2 if the result value is less than C1 i will again add A1 to A3 if the sum is less than C1 i will again add A1:A4 and so on untill the sum is more or equal to C1. How can i do that[/quote]
      Please try to use this formula: =IF(SUM(INDIRECT("B1"))>=$C$1,"",A2)
  • To post as a guest, your comment is unpublished.
    Ram · 4 years ago
    I just wish to find sum of best of two questions using a single formula in total column
  • To post as a guest, your comment is unpublished.
    Jenny · 4 years ago
    Since I purchased this software it never worked for me, every time I try to do something with kutools it always frozen my excel, it is horrible and I can not get any support from the kutools team. Very disappointing!
    • To post as a guest, your comment is unpublished.
      admin_jay · 4 years ago
      [quote name="Jenny"]Since I purchased this software it never worked for me, every time I try to do something with kutools it always frozen my excel, it is horrible and I can not get any support from the kutools team. Very disappointing![/quote]
      Please try to contact us with your order informaiton. You can contact me via jaychivo@extendoffice.com. :-)
      We will solve it for you.
  • To post as a guest, your comment is unpublished.
    marco · 4 years ago
    I had problem to register the product (Kutools for excel) but after having solved this issue I can't use the tools becuase every time I' trying to use a Kutools task the Excel closed.
    Please help me
    Thanks

    Marco
    • To post as a guest, your comment is unpublished.
      admin_jay · 4 years ago
      [quote name="marco"]I had problem to register the product (Kutools for excel) but after having solved this issue I can't use the tools becuase every time I' trying to use a Kutools task the Excel closed.
      Please help me
      Thanks

      Marco[/quote]
      Please try to contact us with your order information via jaychivo@extendoffice.com.

      We will solve it for you. :-)
  • To post as a guest, your comment is unpublished.
    I N · 4 years ago
    Hello, I am using the file list function and finding that Kutools can only import 32,767 lines of data. Why is this the case and is there a way to generate the file list with more than 32,767 rows?

    Also, I am finding that after a few uses of this function, Kutools and my other add-ins disappear. Is there a way to fix this?

    Thank you,
    I N
    • To post as a guest, your comment is unpublished.
      admin_jay · 4 years ago
      [quote name="I N"]Hello, I am using the file list function and finding that Kutools can only import 32,767 lines of data. Why is this the case and is there a way to generate the file list with more than 32,767 rows?

      Also, I am finding that after a few uses of this function, Kutools and my other add-ins disappear. Is there a way to fix this?

      Thank you,
      I N[/quote]

      Please try to contact us via jaychivo@extendoffice.com with detailed information about the issue.