Uyicima njani imiqolo engenanto kwi-Excel inyathelo ngenyathelo

Wamkelekile kwihlabathi elimangalisayo kwaye - ngamanye amaxesha - elintsokothileyo le-Excel. Ngeli xesha siza kufunda uyicima njani imiqolo engenanto kwi-excel Inyathelo nenyathelo. Siza kuzama ukuyenza ibe lula kangangoko ukuze ufunde ngokukhawuleza, siya kukushiya ne-macro. Kuba ukuba usebenzisa i-Excel uya kwazi ukuba iimacros zenza ubomi bube lula, kodwa kufuneka ube nazo kwaye uziphumeze. Kule meko siya kukunika yona. Akukho mfuneko yokuba sikuxelele ukuba ixesha otyala ngalo ngokufunda i-Excel lixesha elizuzwe kuwo wonke umsebenzi wakho. Kwaye ufunda ngeyona datha ilungileyo kunye nesixhobo samanani kwimarike.

Kuba ewe, i-Excel namhlanje sisixhobo esinamandla esisetyenziswa zizigidi zabantu, kodwa siqondwa ngabambalwa. Kuqhelekile ukuba ufuna uncedo, nokuba lolwendlela yokucima imiqolo engenanto kwi-Excel, sonke siyayifuna ngaxa lithile. Njengoko usebenza ngezixa ezikhulu zolwazi, kuyinto eqhelekileyo ukuba ubone imiqolo engenanto, kwaye oku ithintela ngokupheleleyo ukufunda kunye nokuqhubekeka kwedatha, uhlalutya kancinci ngexesha elininzi.

Iindlela ezi-4 zokucima imiqolo engenanto kwi-Excel

 

Njengoko uza kubona, kukho iindlela ezahlukeneyo, ngokukodwa siza kukufundisa ezine, kwaye ngale ndlela uya kukwazi ukucima imiqolo engenanto kwi-Excel. Ekugqibeleni siya kukunika i for yintoni ukuphelisa loo miqolo, ngendlela ebanzi ngakumbiukuya. Kodwa ewe, ukuba unomdla sinelinye inqaku lamva nje esithetha ngalo Sebenzisa i-AI kwi-Excel ukubala iifomyula ngokuchanekileyo nangokulula. Kwimeko kwakhona ungumsebenzisi Mac, sikwanaso isikhokelo iindlela ezimfutshane zekhibhodi kwi-Excel ye-Mac. Yibone into ebonwe kuyo Tecnobits Siyayithanda i-Excel, kodwa ngaphezu kwayo yonke into iyakunceda ngayo.

Cima imiqolo engenanto ngesandla

Ngaba unayo idatha encinci kwifayile yakho ye-Excel? Ngoko le ndlela. Kule meko kuphela kuya kufaneleka ukuwacima ngesandla, gcina loo nto engqondweni. Ukuba le yimeko yakho, landela la manyathelo:

• Khetha imiqolo engenanto, oko kukuthi, ezingenanto. Ukuba ubona ukuba yonke loo miqolo imhlophe ithe saa, ungakhetha ngokubamba iqhosha le-Ctrl ngelixa ucofa kuyo.
• Ngoku cofa ekunene naphi na kulo lonke ukhetho kwaye ucinezele iqhosha "susa"
• Ukujonga ukuba asiyompazamo, ibhokisi yencoko yababini iya kuvela, kwaye iya kukunika ukhetho lokuyenza "Imiqolo yonke" xa uyikhethile kuya kufuneka ucofe u-"Yamkela"

'Yabona? Ukuba ubuzibuza ukuba ungayicima njani imiqolo engenanto kwi-Excel, ibikhawuleza kwaye iyasebenza, akunjalo? Kodwa khumbula ukuba oku kuphela amanani amancinci emiqolo engenanto, kungenjalo ubuya kuphambana.

Sebenzisa izihluzi ukufumana kunye nokususa imiqolo engenanto

Ngokungafaniyo nendlela yangaphambili, ngoku le yenzelwe izixa ezikhulu zemiqolo engenanto. Apha sihamba nesikhokelo sokucoca:

• Khetha uluhlu lwedatha okanye ikholamu ofuna ukuyishiya ngaphandle kwemiqolo engenanto
• Yiya kwibar yesixhobo kwaye ngoku khetha ithebhu "Idatha", emva koko ucofe "Hlunga". Uya kubona imenyu eyehlayo.
• Cofa icebo lokucoca umhlathi apho ufuna ukususa khona imiqolo engenanto. Sukukhangela zonke iinketho ngaphandle kokuthi "Abamhlophe" 
• Ngeli xesha iphepha liza kukubonisa kuphela imiqolo emhlophe, ukhethe kwaye khetha ukucima.

Cima imiqolo engenanto nge Yiya kumsebenzi okhethekileyo

Iseyenye indlela yamaphepha e-Excel anedatha eninzi. Ngale ndlela unako khetha yonke imiqolo engenanto kwikholamu okanye kumqolo ngokuzenzekelayo:

• Khetha uluhlu lwedatha okanye ikholamu ngqo oyifunayo
• Ngoku kuya kufuneka ucinezele indibaniselwano Ctrl + G okanye uye kwithebhu ethi "Ekhaya" kwaye ukhethe "fumana kwaye ukhethe" ngoku cofa yiya ku Special.
• Ngoku khetha "Iiseli ezingenanto" kwaye ucofe u-OK
• Emva kokuba yonke into ikhethiwe kuya kufuneka uye kuyo "ikhaya" emva koko "cima" kwaye ukhethe "cima imiqolo yamaphepha"

IMacro yokucima imiqolo engenanto kwi-Excel

Njengoko besithembisile, apha siza kukushiya i-macro. I-macro, ukuba umtsha kwi-Excel, ayikho enye into Umyalelo oza kuwenza ngokuzenzekelayo umsebenzi wakho. Ukuze ukwazi ukungena kuyo kufuneka wenze oku kulandelayo:

• Sebenzisa indibaniselwano yesitshixo Alt + F11 ukuvula iVisual Basic for Applications umhleli
• Ngoku kumhleli weVisual Basic, cofa "faka" kwaye emva koko "imodyuli"
• Khuphela ikhowudi esikushiya ngezantsi kwaye emva kokuyikopisha cofa isitshixo F5 okanye "Baleka" ukuze i-macro yenze umsebenzi wayo

Ukucinywa kweMiqolo eNgaphantsi ()
Dim Uluhlu njengoluhlu
Dim Iseli Njengoluhlu
Kwi-Error Resume Next
Seta uluhlu = ActiveSheet.UsedRange
NgeSeli nganye ekuluhlu
Ukuba Application.WorksheetFunction.CountA(Cell.EntireRow) = 0 Emva koko
Cell.EntireRow.Delete
Ukuphela Ukuba
Iseli elandelayo
Ukuphela kweNqununu

Kutheni kufuneka ndicime imiqolo engenanto kwi-Excel?

Emva kokukunika iindlela, kwaye njengoko sisazi ukuba sele ufunde ukucima imiqolo engenanto Excel, sikuxelele ngaphambili ukuba siza kukuxelela ukuba kutheni unefayile ecacileyo. Kwaye ukuba uyakwazi ukufunda indlela yokuphelisa, uya kufezekisa oku kulandelayo:

• Uya kwenza ifayile ye-Excel ukuze ingabi nzima kwaye yonke into ilayisha ngokukhawuleza
• Uya kuphucula i ukubonwa kunye nohlalutyo yedatha equlathe yona. Uya kucoca yonke into.
• Uthintelo lwempazamo lulonke enkosi ekubeni ifayile icocekile kwimigca engenanto okanye engenanto.
• Ekugqibeleni, Ukunikezela ngefayile epheleleyo, ngaphandle kweempazamo, kuthetha kakuhle ngawe, ngakumbi ukuba kungaphakathi komsebenzi wakho. Yiyo loo nto sikuxelela ukuba kuthetha ukuthini ukutyala imali kuwe.

Ukufunda indlela yokucima imiqolo engenanto kwi-Excel sisiseko sale nkqubo. Kwaye siyavuya ukuba uze Tecnobits ukufunda kunye nathi. Kuba ekubeni ufikile ngoku, sikushiya elinye inqaku malunga Essential Excel iifomyula ukuqalisa ukufunda iifomyula Excel.