Logáil isteach  \/ 
x
or
x
Cláraigh  \/ 
x

or

Kutools for Excel: Bosca Uirlisí Cumhachtacha Excel

Kutools le haghaidh Excel Is bosca uirlisí cumhachtach Excel é a shaorann tú ó oibríochtaí am-íditheach a dhéanamh in Excel. Tá níos mó ná 300 feidhm chumhachtach sa bhosca uirlisí le haghaidh Excel 2019, 2016, 2013, 2010, 2007 agus Office 365.

Nuashonrú is déanaí:  Kutools le haghaidh Excel 24.00
Dáta: 15 Eanáir, 2021
Cuirimid fáilte roimh gach ceist, aiseolas agus tuairisc ar fhabhtanna. Is gnách go mbíonn an fhaisnéis seo a leanas de dhíth orainn: Glaoigh orainn
  • Cur síos gairid ar an gceist agus conas is féidir í a mhacasamhlú (más infheidhme).
  • Do chóras oibriúcháin (Windows 10, 8, Windows 7, srl) agus faisnéis leaganacha do Microsoft Office.
  • Scáileáin scáileáin a léiríonn an fhadhb - Conas a thógfaidh mé pictiúr? http://www.take-a-screenshot.org

Liostáil Nuachtlitir:


Kutools le haghaidh Ranganna Teagaisc Gné Excel:


Is féidir leat rochtain a fháil go tapa ar na ranganna teagaisc gné trí ainm gné a chlóscríobh sa bhosca cuardaigh seo a leanas. Mar shampla, más mian leat a fháil amach conas an Leagan Amach Léitheoireachta Amharc, ní gá duit ach clóscríobh a dhéanamh léitheoireacht eochairfhocal sa bhosca cuardaigh.

Féach ar an nGrúpa:

Track Snap (Cúltaca Leabhar Oibre Reatha): Déan an leabhar oibre reatha a chúltaca go sealadach ag am ar bith
Pána Nascleanúna: Liostaigh gach bileog, leabhar oibre, colún agus ainm
Aimsigh agus Ionadaigh Ard: Faigh go héasca agus cuir in ionad iad i mbileoga oibre agus leabhair oibre iomadúla
Méid Réimse Oibre: Athraigh méid an cheantair oibre go tapa
Leagan Amach Léitheoireachta: Go héasca ag léamh / ag breathnú ar líon mór sraitheanna agus colúin
Taispeáin Colúin: Tog na colúin fholaithe go léir le bheith infheicthe nó dofheicthe
Taispeáin Bileoga: Tog gach bileog i bhfolach le bheith infheicthe nó dofheicthe
Folaigh / Folaigh Leabhair Oibre agus Bileoga: Folaigh nó folaigh leabhair oibre agus bileoga oibre
Féach ar na Roghanna: Toggle leabhar oibre agus socruithe bileog oibre
Limistéar Scrollaigh Socraigh: Socraigh limistéar scrollaigh (folaigh colúin agus sraitheanna neamhroghnaithe ag an am céanna)
Folaigh bileoga neamhroghnaithe: Folaigh gach bileog oibre neamhghníomhach (nó gach ceann neamhroghnaithe)
Folaigh Windows Neamhghníomhacha: Folaigh leabhair oibre eile (gach fuinneog neamhghníomhach)
Unhide Gach Rang: Unhide gach sraitheanna agus colúin
Unhide Gach Bileog Oibre: Taispeáin gach bileog oibre i bhfolach
Unhide Gach Windows: Cuir fuinneoga uile an leabhair oibre i bhfolach

Grúpa Raon agus Cealla:

Coigeartaigh Méid na gCill: Socraigh airde as a chéile nó leithead colún in orlach, punt, ceintiméadar nó picteilín
Cumaisc Cealla Mar an gcéanna: Cumaisc cealla cóngaracha i gcolún leis na sonraí / luach céanna
Cill Unmerge: Cealla a dhíbirt agus luachanna a líonadh
Raon Cothrománach Smeach: Ord sonraí smeach (droim ar ais) na gcolún nó na sraitheanna
Raon Ingearach Smeach: Ord sonraí smeach (droim ar ais) na gcolún nó na sraitheanna
Toisí Tábla Trasuí: Tiontaigh tábla 2-thoiseach / tras-tábla le liostáil
Raon Trasfhoirmithe: Colún nó ró as a chéile a thrasuí go raonta
Raonta Babhtála: Babhtáil sraitheanna, colúin nó raonta
Raon Sórtáil go randamach: Cealla, sraitheanna agus colúin a shórtáil nó a roghnú go randamach
Déan comparáid idir Cealla: Déan comparáid éasca idir dhá shraith cealla má tá siad cothrom nó difriúil
Roghnaigh Cealla Mar an gcéanna & Éagsúla: Dhá raon a chur i gcomparáid le luachanna dúblacha nó uathúla a roghnú
Cosc a chur ar Dúblach: Cosc ar iontrálacha dúblacha i gcolún
Cosc ar Chlóscríobh: Cosc a chur go héasca ar charachtair speisialta nó áirithe a chlóscríobh i gcealla
Ná lig ach carachtair ar leith a iontráil i raon cealla
Cóipeanna Ranna: Cóipeáil ilroghnuithe nó raonta
Tiontaigh idir Téacs agus Uimhir: Tiontaigh / bhfeidhm téacs go huimhir nó uimhir go téacs
Tiontaigh idir Rómhánach agus Uimhir: Tiontaigh idir uimhreacha Rómhánacha agus uimhreacha
Tiontaigh an Fhoirmle go Téacs: Déan foirmlí cille a thiontú go teaghráin téacs go tapa
Tiontaigh Téacs go Foirmle: Teaghrán téacs a thiontú go foirmle go tapa
Tiontaigh go dtí seo: Formáid dáta a aithint agus a thiontú
Am Tiontaithe: Tiontaigh an t-am go soicind / nóiméad / uair an chloig
Comhshó Airgeadra: Tiontaigh airgeadra (USD go EURO / USD go GBP)
Comhshó Aonad: Aonaid tomhais a thiontú
Córais Uimhreacha a Thiontú: Tiontaigh idir córais uimhreacha éagsúla gan an fhoirmle a úsáid
Uimhreacha Litrithe Amach: Tiontaigh nó litrigh uimhir go focail Bhéarla
Athraigh Comhartha Luachanna: Athraigh comharthaí uimhreacha (Deisigh comharthaí diúltacha rianaithe / Athraigh na luachanna diúltacha go dearfach)
Sraitheanna Comhcheangail Casta: Cuir sraitheanna le chéile go tapa bunaithe ar an luach céanna
Tiontaigh Uimhir go Gnáth: Déan uimhreacha a thiontú go huimhir ordaitheach go tapa
Go Iarbhír: Cuir luachanna / torthaí ríofa i gcealla in ionad foirmlí
Babhta (Gan Foirmle): Luachanna cille cruinn gan foirmle
Comhcheangail (Sraitheanna & Colúin): Comhcheangail (cumasc) ilcholúin nó sraitheanna

Grúpa Eagarthóireachta:

Sár-Aimsiú:
Faigh teaghráin shonracha téacs sna tráchtanna amháin
Faigh sreangán téacs ar leith i luach cille amháin
Faigh teaghráin shonracha téacs sna foirmlí amháin
Faigh cealla ina bhfuil luachanna de chineál dáta bunaithe ar chritéir
Faigh uimhreacha bunaithe ar chritéir
Cuardaigh luachanna téacs ar leith i hipearnasc amháin
Faigh na cealla go léir a bhfuil formáidiú sonrach cille acu
Amharc doiléir: Faigh agus cuir na taifid chosúla in áit ó liosta luachanna cille
Roghnaigh Cúntóir Raon: Roghnaigh, dí-roghnú agus aisiompú raonta iolracha
Roghnaigh Sraitheanna agus Colúin Eatramh: Roghnaigh sraitheanna nó colúin eatramh (gach ceann eile)
Roghnaigh Cealla Cumaisc: Aimsigh agus roghnaigh cealla cumaisc
Roghnaigh Cealla Deireanacha: Chun an chill dheireanach den raon úsáidte nó an chill dheireanach a roghnú le sonraí den tsraith dheireanach nó den cholún
Roghnaigh Cealla a bhfuil Uasluach nó Íosluach acu: Roghnaigh ceall luacha max nó min (is lú nó is mó)
Roghnaigh Cealla le Luach Earráide: Roghnaigh cealla le luachanna earráide
Roghnaigh Cealla Sonracha: Roghnaigh cealla, sraitheanna agus Colúin shonracha
Roghnaigh Cealla le Formáid: Roghnaigh cealla bunaithe ar fhormáidiú
Roghnaigh Cealla Díghlasáilte: Roghnaigh gach cealla díghlasáilte go tapa
Roghnaigh Cealla Unblank: Roghnaigh cealla neamhfholamh nó neamhfholamh go héasca
Roghnaigh Cealla Dúblacha & Uathúla: Faigh cealla / sraitheanna dúblacha nó uathúla i raon
Cuir Sraitheanna Teidil isteach: Cuir sraitheanna teidil isteach i raon
Cuir Sraitheanna agus Colúin Bhána isteach: Cuir isteach sraitheanna nó colúin bhána gach sraitheanna / colún eile
Dáta Ionsáigh: Cuir isteach an dáta le formáidiú an dáta
Bosca Seiceála Ionsáigh Baisc: Cuir isteach ticbhoscaí iolracha go tapa ag an am céanna
Cnaipe Rogha Iontrála Baisc: Cuir isteach cnaipí ilroghnacha go tapa ag an am céanna
Cuir isteach Comhartha Uisce: Cuir isteach agus bain comharthaí uisce go tapa
AutoText: Cruthaigh agus cuir isteach iontráil Auto Text go héasca
Cuir isteach Uimhreacha Seicheamh: Cruthaigh agus cuir isteach uimhreacha seicheamh uathúla
Faigh Uimhir Seicheamh ar Iarraidh: Faigh agus líon isteach na huimhreacha atá in easnamh go tapa in ord
Líon Liostaí Saincheaptha: Cruthaigh liostaí saincheaptha agus líon cealla leo
Liostaigh Gach Comhcheangal: Déan gach teaglaim féideartha de liostaí áirithe a ghiniúint / liostáil go tapa
Cuir Bullet Nó Uimhriú isteach: Cuir Urchair nó Uimhreacha i gCill Ilchealla in Excel go tapa
Cuir isteach Sonraí randamacha: Gineadóir uimhreacha randamacha a úsáid chun uimhreacha agus pasfhocal a ghiniúint
Líon Cealla Bána: Líon cealla bána le luach os cionn nó 0
Scrios Sraitheanna Bána: Bain nó scrios gach sraitheanna bán ón mbun / raon
Scrios Sraitheanna & Colúin: Scrios sraitheanna bán nó i bhfolach (colúin)
Scrios Uirlisí: Scrios gach cairt, bosca téacs agus réad leabaithe OLE
Scrios Rialuithe Gréasáin: Bain gach réad html mar bhosca seiceála
Bosca Seiceála Scrios Baisc: Bain / scrios ilbhoscaí
Cnaipe Rogha Baisc Scrios: Baisc na cnaipí rogha scriosadh
Bain Gach Macraí: Bain gach macraí laistigh den bhileog oibre nó den leabhar oibre
Baisc Bain Gach Macraí: Baisc gach macraí a bhaint nó a scriosadh as leabhair oibre
Bain Spásanna: Bain spásanna roimh / tar éis téacs nó bain spásanna breise den téacs
Cás Athraithe: Athraigh cás an téacs go dtí na caipíní go léir, níos ísle agus i gceart
Uimhreacha síntiúis i bhFoirmlí Ceimiceacha: Liostáil na huimhreacha go léir i gcothromóidí ceimiceacha i gceart
Bain de réir Poist: Bain nó scrios carachtair ó thús / deireadh teaghráin téacs
Ordú Téacs Droim ar Ais: Teaghrán téacs droim ar ais nó ordú focail
Ionadaigh Carachtair Accented: Cuir carachtair rialta in ionad carachtair iolracha aicrileach
Téacs Sliocht: Bain téacs áirithe as cealla go tapa
Sliocht Seoladh Ríomhphoist: Sliocht seoladh ríomhphoist as sreangán an téacs
Cuir Téacs leis: Cuir an téacs céanna i raon cealla
Ainmneacha Scoilt: Roinn ainmneacha céad, lár agus deiridh
Cealla Scoilt: Roinn ábhar na gceall go tapa de réir spáis nó teorannaithe eile
Scrios Carachtair: Bain carachtair uimhriúla, aibítreacha, neamh-inphriontáilte nó alfa-uimhriúla ó chealla
Scáth Malartach Rae / Colún: Scáthaigh gach ró / colún eile
Forscríbhinn / Síntiús (Formáidiú): Téacs na formáide mar fhorscríbhinn nó mar shíntiús
Cuir Formáidiú Dáta i bhFeidhm: Cuir formáidiú dáta i bhfeidhm ar raon dátaí
Cóipeáil Formáidiú Cealla: Cóipeáil formáidiú cille ó chill amháin go cealla eile
Formáidiú Glan Gach Cealla: Glan go hiomlán gach formáidiú raon-chealla
Tiontaigh Hipearnasc: Bain naisc url ó hipearnasc nó chun naisc ghnáth-théacs a thiontú go hipearnasc
Aimsigh agus Briseadh Naisc Bhriste: Faigh agus briste naisc briste (tagairtí seachtracha)
Scrios Hipearnasc: Bain gach hipearnasc de raonta, leatháin agus leabhar oibre
Áireamhán Kutools: Fetches luachanna ó chealla le haghaidh oibríochtaí agus torthaí a ghreamú i gcealla
Uirlisí Oibríochta: Cuir oibríochtaí matamaitice i bhfeidhm ar raon gan fhoirmle
Athraigh Cruth Tráchta: Athraigh cruth an bhosca trácht
Uirlisí Tráchta Cill: Athraigh tráchtanna iolracha cille
Cruthaigh Liosta Tráchta: Déan gach trácht a bhaint agus a liostáil go tapa ar bhileog oibre nó leabhar oibre nua
Trácht na Formáide: Déan gach trácht a fhormáidiú go tapa bunaithe ar thrácht
Aimsigh / Ionadaigh Téacs Tráchta: Faigh téacs go tapa agus cuir in ionad é i dtuairimí
Bain / Cuir Ainm Úsáideora sa Trácht: Athraigh / bain / cuir ainm an údair go tapa i dtuairimí
Tiontaigh Trácht agus Cill: Tiontaigh go tapa idir ábhar cille agus tráchtanna
Tráchtaireacht AutoFit: Athraigh méid na mboscaí tráchta go huathoibríoch chun an t-ábhar a fheistiú

Grúpa Foirmle:

   Feidhmeanna:

Líon de réir Dath na gCill: Feidhm a úsáid chun cealla a chomhaireamh / shuimiú de réir dath líonta nó cló
Líon Char: Comhairigh carachtar carachtar i sreangán
Uimhreacha Sliocht: Sliocht uimhreacha as sreangán téacs measctha le feidhm
Téacs Droim ar Ais: Ord carachtair a aisiompú go héasca i gcill le feidhmeanna
Suim de réir cló trom: Suim go tapa luachanna / uimhreacha troma amháin
Líon de réir cló trom: Déan líon na gcealla troma amháin i raon a chomhaireamh go héasca
ACHOIMRE: Cealla, sraitheanna nó colúin infheicthe go héasca a chomhaireamh / a chomhaireamh

   Foirmlí:

Cuir uaireanta / nóiméad / soicind leis go dtí seo: Cuir uaireanta / nóiméad / soicind go héasca le ham dáta
Cuir blianta / míonna / laethanta / seachtainí leis go dtí seo: Cuir blianta / míonna / laethanta / seachtainí leis go dtí seo
Ríomh aois bunaithe ar bhreithlá: Ríomh aois de réir dáta breithe
Uimhreacha suime i gcill: Suimigh na digití / na huimhreacha go léir i gcill
Luachanna iomlána suime: Luachanna iomlána a lua go héasca i raon
Cuardaigh luach ar an liosta: Déan luach a chuardach go tapa agus cill dhifriúil a chur ar ais ón tábla
Líon deireadh seachtaine idir dhá dháta: Déan líon na deireadh seachtaine / laethanta na seachtaine / lá sonrach na seachtaine a chomhaireamh go tapa idir dhá dháta
Faigh an naoú tarlú de charachtar: Faigh go héasca suíomh an naoú tarlú de charachtar i sreangán téacs
Líon na bhfocal sa raon: Déan líon na bhfocal a chomhaireamh go tapa
Faigh an luach is coitianta: Déan líon na bhfocal a chomhaireamh go tapa
Bain an t-am ón dáta: Bain Am go tapa ó Dáta Formáid Am go Buan

Cóip Foirmle Díreach: Cóipeáil foirmlí beachta gan tagairtí cille a athrú
Tagairtí Tiontaigh: Tiontaigh tagairt cille go tagairt choibhneasta / iomlán
Ionadaigh Ainmneacha Raon: Cuir tagairt cille in ionad an ainm i bhfoirmlí
Folaigh / Folaigh Ainm Raon: Raon ainmnithe a cheilt nó a cheilt go héasca
Draoi Coinníoll Earráide: Cuir nialas, cealla bána nó téacs saincheaptha in ionad teachtaireachtaí earráide foirmlí
Féach go dinimiciúil ar bhileoga oibre: Líon tagairtí cille go tapa ó iliomad bileoga oibre
Lorg Fasach agus Cleithiúnach: Déan gach cleithiúnaí nó fasach a rianú go tapa

Grúpa Leabhar Oibre agus Bileog:

Uirlisí Leabhar Oibre

Leabhar Oibre Scoilt: Roinn nó sábháil gach bileog / bileog oibre ón leabhar oibre mar chomhad Excel amháin ar leithligh
Tiontaire Formáid Comhad: Tiontaigh ilchomhaid XLSX go comhaid XLS nó PDF
Cuir isteach Eolas faoin Leabhar Oibre: Cuir ainm nó cosán an chomhaid isteach i gcill / ceanntásc nó buntásc
Fillteán Oscailte Oscailte: Oscail eolaire / fillteán reatha an leabhair oibre ghníomhaigh
Cóipeáil Conair Iomlán: Cóipeáil agus cuir isteach ainm agus cosán comhaid an leabhair oibre ghníomhaigh
Auto Open Na Leabhair Oibre sin An chéad uair eile: Oscail leabhair oibre shonraithe go huathoibríoch nuair a thosaíonn Excel
Comhcheangail Bileoga Oibre:
1. Comhcheangail iliomad bileoga oibre / raonta ó leabhair oibre i mbileog oibre amháin
2. Comhcheangail / cumasc gach bileog oibre den ainm céanna ar fud leabhair oibre i mbileog oibre amháin
3. Bileoga oibre nó leabhair oibre a chomhcheangal / a chumasc in aon leabhar oibre amháin
4. Déan achoimre ar agus ríomh sonraí ó iliomad bileoga oibre i mbileog oibre amháin

Uirlisí Bileog Oibre

Bileoga Oibre a Sioncrónú: Roghnaigh na cealla céanna go sioncrónach i ngach bileog oibre
Bileoga Sórtáil: Bileoga / bileoga oibre a shórtáil nó a shocrú in ord aibítre
Bileoga Oibre Il-Pannaí Reo: Reo panes ar fud iliomad bileoga oibre
Bileoga Oibre Il-Panes Neamhréire: Panes unfreeze ar iliomad bileoga oibre
Athainmnigh Bileoga Oibre Il: Athainmnigh iliomad bileoga oibre
Cruthaigh Liosta Ainmneacha na mBileog: Cruthaigh innéacs bileoga sa leabhar oibre gníomhach
Cóipeáil Bileoga Oibre Il: Cóipeáil nó cuir isteach iliomad bileoga oibre
Cruthaigh Bileoga Oibre Seicheamh: Cruthaigh leabhar oibre nua le hainmneacha bileog oibre saincheaptha air
Féilire Suthain: Cuir isteach féilire míosúil nó bliantúil in Excel
Sonraí Scoilt: Roinn sonraí i mbileoga iolracha
Scrios Bileoga Oibre Blank: Scrios gach bileog oibre bán le cliceáil amháin
Scrios Gach Bileog Hidden: Scrios gach bileog oibre i bhfolach le cliceáil amháin
Scrios Gach Bileog Neamhghníomhach: Scrios gach bileog seachas ceann reatha / gníomhach ón leabhar oibre
Comhcheangail Bileoga Oibre: Comhcheangail iliomad bileoga oibre nó leabhair oibre in aon leabhar oibre amháin
Cumasc Tábla: Táblaí Nuashonraithe Nó Cumaisc Trí Cholún a Mheaitseáil Ó Dhá Bhileog Oibre / Leabhar Oibre
Raon Easpórtála go Comhad: Raon a easpórtáil nó a shábháil mar CSV, HTML agus Leabhar Oibre
Raon Easpórtála mar Ghrafach: Raon easpórtála mar chomhad íomhá
Grafaic Easpórtála: Sábháil agus easpórtáil graif cairteacha (pictiúir nó cruthanna) mar chomhaid íomhá JPEG
Cuir isteach Comhad ag Cúrsóir: Cuir isteach ábhar na gcomhad CSV, Excel, Text nó PRN ag suíomh an chúrsóra
Liosta Ainm comhaid: Faigh agus cruthaigh liosta d’ainmneacha comhaid i bhfillteán nó i eolaire
Cruthaigh Fillteáin Bunaithe ar Ábhar na gCill: Cruthaigh fillteáin bunaithe ar luachanna cille
Draoi Leabhar Oibre Il: Priontáil: Priontáil iliomad leabhar oibre ó eolaire
Draoi Ilroghnacha a Phriontáil: Priontáil raonta / roghnúcháin iolracha i leathanach amháin
Leathanaigh Priontála in Ord Droim ar Ais: Leathanaigh a phriontáil go héasca in ord droim ar ais
Ionsáigh Leathanach Briseadh Gach Rae: Cuir isteach briseadh leathanach go tapa gach x sraitheanna i mbileog oibre Excel
Cuir Teorainn le gach Leathanach: Cuir teorainn timpeall gach leathanaigh go tapa agus déan é a phriontáil
Cóip Socrú Leathanach: Cóipeáil agus cuir socruithe socruithe leathanaigh i bhfeidhm ó bhileog oibre amháin go cinn eile
Fotheidil Paging: Fotheidil a chur isteach agus a phriontáil ar gach leathanach clóite
Priontáil An Chéad Leathanach de gach Bileog Oibre: Priontáil go tapa an chéad leathanach de gach bileog oibre
Pictiúir Iompórtála: Cuir iliomad pictiúr isteach i gcealla agus socraigh iad go néata
Meaitseáil Pictiúir Iompórtála: Iompórtáil pictiúir i gcealla bunaithe ar luach cille
Priontáil Ilcholúin: Liosta a phriontáil i gcolúin iolracha le feistiú ar gach leathanach clóite
Priontáil Leathanach Reatha: Priontáil leathanach clóite reatha de chill ghníomhach

Grúpa Slándála:

Cealla Criptigh: Luachanna nó ábhar roghnaithe cille a chriptiú agus a dhíchriptiú
Cealla a Dhíchriptiú: Luachanna nó ábhar roghnaithe cille a chriptiú agus a dhíchriptiú
Bileog Oibre a Chosaint: Cosain iliomad bileoga / bileoga oibre ag an am
Bileog Oibre Gan Chosaint: Gan mórán bileoga oibre / bileoga a chosaint ag an am céanna
Cruthaigh Liosta Ríomhphoist: Cruthaigh go héasca Liosta Ríomhphoist in Excel
Seol Ríomhphoist: Seol Ríomhphoist Bunaithe ar Liosta Ríomhphoist in Excel

Grúpa Ríomhphoist:

Cruthaigh Liosta Ríomhphoist: Cruthaigh liosta na bhfaighteoirí go tapa i dtábla Excel
Seol Ríomhphoist: Seol ríomhphoist pearsantaithe chuig iliomad faighteoirí ar an mórchóir

Grúpa Scagaire & Staidrimh:

Líon de réir Dath: Ríomh luach cealla bunaithe ar chúlra cille nó dath scáthú
Fotheidil Paging: Fotheidil a chur isteach agus a phriontáil ar gach leathanach clóite
Ard-Sórtáil: Sonraí a shórtáil go héasca de réir ainm deiridh / míosa / minicíochta / fad téacs
Scagaire Sármhaith: Scag sonraí bunaithe ar luach cille le ilchritéir
Scagaire Trom: Scag Gach Cealla de réir Carachtair Trom
Scagaire Iodálach: Scagaire Gach Cealla De réir Iodálach
Scagaire Strikethrough: Scagadh Cealla le Strikethrough
Tráchtaireacht Scagaire: Scag Gach Cealla le Trácht
Foirmle Scagaire: Scag Gach Cealla a bhfuil Foirmle ann
Scagaire Cumaisc: Scagaire Cealla Cumaisc
Scagaire Speisialta:
Scagadh Cealla De réir Uppercase / Lowercase
Scagadh Cealla de réir Fad an Téacs
Scagadh Cealla de réir Lá Oibre / Deireadh Seachtaine / Lá Sonrach na Seachtaine
Scagadh Cealla De réir an Dath Cló
Scagadh Cealla De réir an Dath Cúlra
Greamaigh isteach sa raon infheicthe: Cóipeáil sonraí agus greamaigh isteach i gcealla infheicthe / liosta scagtha amháin
Glas Roghnúcháin: Cumraigh cealla go héasca le bheith faoi ghlas nó díghlasáilte
Díghlasáil Roghnúcháin: Cumraigh cealla go héasca le bheith faoi ghlas nó díghlasáilte
Aibhsigh Díghlasáilte: Cuir béim / dathú tapa ar gach cealla díghlasáilte
Folaigh na Foirmlí: Foirmlí a cheilt nó a cheilt go tapa
Foirmlí Unhide: Foirmlí a cheilt nó a cheilt go tapa
Highlight Hidden: Aibhsigh go tapa cealla le foirmlí i bhfolach
Foirmlí Aibhsithe: Aibhsigh go tapa gach cealla foirmle
Aibhsigh Ainmneacha: Aibhsigh go tapa na raonta ainmnithe go léir
Taispeáin Ceanntásca: Déan ceanntásca colún agus as a chéile a cheilt agus a thaispeáint go tapa
Taispeáin Foirmlí: Gach foirmle cille a thaispeáint nó a thaispeáint go héasca
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.
    Robert · 1 months ago
    when i use count by color the color method box is greyed out, any ideas?

  • To post as a guest, your comment is unpublished.
    MMMe · 2 months ago
    I want to know how to uninstall Kutools, I cant find out the way to take it off.
  • To post as a guest, your comment is unpublished.
    MKme · 2 months ago
    Hi I have 2 columns , location and color..
    I need to count all unique cominations from Location and color for example:

    For Location R2 .. I need a formula that brings me "2" as the answer .. Since there are R2BLUE(+duplicate)+ R2GREEN,
    What can i do?
    =COUNTIFS(a15:a21,"r2",a15:a21,"<>0") This formula is counting the duplicate so brings me a "3"
    =SUM(IF(B15:B21<>"",1/COUNTIF(B15:B21,B15:B21))) .. This Formula gives me the unique values from column B (5) , but I dont know how to limit to location R2.

    PLEASE HELP!!!

    LOC COLOR
    R2 R2BLUE
    A1 A1BLUE
    A1 A1BROWN
    R2 R2BLUE
    R2 R2GREEN
    A1 A1PINK
    A1 A1PINK
  • To post as a guest, your comment is unpublished.
    John · 3 months ago
    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.

    1. S RALEIGH AVE
    2. ATLANTIC AVE
    3. S NORTH CAROLINA 906
    4. N NEW HAMPSHIRE AVE
    5. MADISON AVE

    Then I also need to move the Ave, street, alley to another cell on the same row as well.

    I have over 18000 rows of data I need to do this for. Is it possible?
  • To post as a guest, your comment is unpublished.
    Gourav · 3 months ago
    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?
  • To post as a guest, your comment is unpublished.
    David Lynch 1 · 4 months ago
    how do I copy content of notes to adjacent empty cell

    I've just bought Kutools bcause I need to do this urgently

    thx

  • To post as a guest, your comment is unpublished.
    Jose · 5 months ago
    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
  • To post as a guest, your comment is unpublished.
    Tom · 5 months ago
    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.
  • To post as a guest, your comment is unpublished.
    Seyi · 6 months ago
    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.
  • To post as a guest, your comment is unpublished.
    Aaron G · 6 months ago
    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.
    • To post as a guest, your comment is unpublished.
      Excelfans · 6 months ago
      Hello,
      We have send an email to aarong@charlesmcmurray.com.
  • To post as a guest, your comment is unpublished.
    Craig de Jager · 6 months ago
    I just want to count words in a cell or range of cells, similar to a word count in MS Word. How to please?

  • To post as a guest, your comment is unpublished.
    pathak · 6 months ago
    can i convert number in indian rupees format in words

  • To post as a guest, your comment is unpublished.
    theo · 6 months ago
    How do I turn off the highlighting of the current cell with the corresponding line and column? Thank you
  • To post as a guest, your comment is unpublished.
    Mai · 7 months ago
    I buy Kutools for excel of my computer. But after my computer broken, i can continue use to kutools on new computer??
    • To post as a guest, your comment is unpublished.
      Excelfans · 6 months ago
      Yes, you can.
  • To post as a guest, your comment is unpublished.
    Mike · 7 months ago
    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?
  • To post as a guest, your comment is unpublished.
    Jade · 7 months ago
    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?

  • To post as a guest, your comment is unpublished.
    · 7 months ago
    Hi, is any translation in Arabic language?
    thanks.
  • To post as a guest, your comment is unpublished.
    Moeen · 7 months ago
    Is there a way to reverse the speedometer order so green goes to the right side and red goes to the left side?

  • To post as a guest, your comment is unpublished.
    Gilbert · 7 months ago
    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.
  • To post as a guest, your comment is unpublished.
    Prashant · 8 months ago
    Dear Sir,
    can i send mail to following type.

    Example ----

    Dear #CustomerName#

    Your Account no. is #Account_number# debit balance is Rs. # Amount #. Please pay the immediately.

    Regards,
    XYZ

    this type of send wiz kutools excel. excel data is ready for me in column.
    if any tutorial please send me.
    Prashant
    prashant@ankurseeds.com
  • To post as a guest, your comment is unpublished.
    hassan.ismail0328@gmail.com · 9 months ago
    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.
  • To post as a guest, your comment is unpublished.
    jayaselvar@gmail.com · 9 months ago
    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.
  • To post as a guest, your comment is unpublished.
    Stephan Citteur · 9 months ago
    Hi, How can I add USL and LSL in the normal distribution chart for Excel
    The chart looks very nice but I can not add the 2 lines as I can add in a standard Excel scatter chart using NORM.DIST
  • To post as a guest, your comment is unpublished.
    Varun · 10 months ago
    can it work on ipads?
  • To post as a guest, your comment is unpublished.
    cy · 10 months ago
    how many computers can i install into if i purchase for one license?
  • To post as a guest, your comment is unpublished.
    efscottowens@gmail.com · 10 months ago
    pdf to excel
  • To post as a guest, your comment is unpublished.
    sowmissk · 10 months ago
    how to clear cell compare rules or modify the rules
  • To post as a guest, your comment is unpublished.
    sowmissk · 10 months ago
    Sir
    Just now i have downloaded your tools. but the a no "Compare Cells" the Ktools tab. how can i Use the feature
    • To post as a guest, your comment is unpublished.
      Excelfans · 10 months ago
      Hello,

      Please take a look at

      https://www.extendoffice.com/product/kutools-for-excel/excel-compare-two-cells-of-equal.html
  • To post as a guest, your comment is unpublished.
    Diderot · 10 months ago
    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
  • To post as a guest, your comment is unpublished.
    Ruth · 1 years ago
    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?
    • To post as a guest, your comment is unpublished.
      Shafeeq · 9 months ago
      I have the same question, once I save and share the file it is not accessible by others...
      • To post as a guest, your comment is unpublished.
        Ruth · 9 months ago
        Hi Shafeeq, Kutools has to be bought for each individual computer for it to work.
        So in the end Kutools refunded me for my purchase of the upgrade and I went back to the older version.
  • To post as a guest, your comment is unpublished.
    carol · 1 years ago
    how do i put kutools on my excell I downloaded it
    • To post as a guest, your comment is unpublished.
      Heather · 1 years ago
      I have the same question. I have downloaded the paid version but how do I get it on my ribbon in Excel?
  • To post as a guest, your comment is unpublished.
    Michael · 1 years ago
    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.
  • To post as a guest, your comment is unpublished.
    Cheila · 1 years ago
    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?
  • To post as a guest, your comment is unpublished.
    4-store · 1 years ago
    cerca vert
  • To post as a guest, your comment is unpublished.
    Jim · 1 years ago
    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
  • To post as a guest, your comment is unpublished.
    tomi.di.carta@gmail.com · 1 years ago
    hI, very very new user. downloaded and executed KUT, but if i open excel and then a file excel quits. Why?
  • To post as a guest, your comment is unpublished.
    michele · 1 years ago
    vevy very new user..if I open excel and then a file excel quits? what's wrong?
  • To post as a guest, your comment is unpublished.
    Stanley · 1 years ago
    Can i use kutools on my laptop and desk top with single user purchase?
  • To post as a guest, your comment is unpublished.
    Ruediger Krueger · 1 years ago
    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
  • To post as a guest, your comment is unpublished.
    Eric · 1 years ago
    Greetings, How do you enable ku tools plus?
  • To post as a guest, your comment is unpublished.
    Tim · 1 years ago
    Currency Rates do not update. It gives the following error; An error occurred while attempting to update the currency rates...
  • To post as a guest, your comment is unpublished.
    gene · 1 years ago
    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.
  • To post as a guest, your comment is unpublished.
    Usman · 1 years ago
    i want to repeat kutool utility on selected data. ?
  • To post as a guest, your comment is unpublished.
    prince · 1 years ago
    after install this sw , how can i use this /
  • To post as a guest, your comment is unpublished.
    ian mcevoy · 1 years ago
    convert numbers to text selection
  • To post as a guest, your comment is unpublished.
    jungilwong · 1 years ago
    I cannot create the file "mals.mail" So I want to change the folder.
  • To post as a guest, your comment is unpublished.
    gray_b · 1 years ago
    Am I able to 'Highlight duplicate cells across a whole workbook. Comparing every worksheet to each other and every permutation
  • To post as a guest, your comment is unpublished.
    Eddie · 1 years ago
    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?
  • To post as a guest, your comment is unpublished.
    David Lark · 1 years ago
    Copy a defined range of cells in a row from a Worksheet to next blank row in a table in a subsequent worksheet
  • To post as a guest, your comment is unpublished.
    naredra · 1 years ago
    any update