Uyisusa kanjani imigqa engenalutho ku-Excel isinyathelo ngesinyathelo

Uyemukelwa emhlabeni omuhle futhi - kwesinye isikhathi - oyinkimbinkimbi we-Excel. Lesi sikhathi sizofunda ungayisusa kanjani imigqa engenalutho ku-excel Igxathu emvakwe gxathu. Sizozama ukukwenza kube lula ngangokunokwenzeka ukuze ufunde ngokushesha, sizokushiya ngisho ne-macro. Ngoba uma usebenzisa i-Excel uzokwazi ukuthi ama-macros enza impilo ibe lula, kodwa kufanele ube nawo futhi uwenze. Kulokhu sizokunika yona. Asidingi ukukutshela ukuthi isikhathi otshala ngaso imali yokufunda i-Excel yisikhathi osithola kuwo wonke umsebenzi wakho. Nokuthi ufunda ngedatha engcono kakhulu kanye nethuluzi lezinombolo emakethe.

Ngoba yebo, i-Excel namuhla yilelo thuluzi elinamandla elisetshenziswa izigidi zabantu, kodwa liqondwa abambalwa. Kuvamile ukuthi udinga usizo, ngisho noma kungeyokuthi uyisusa kanjani imigqa engenalutho ku-Excel, sonke siyayidinga ngesikhathi esithile. Njengoba usebenza ngenani elikhulu lolwazi, kuvamile ukuthi ubone imigqa engenalutho, futhi lokhu kuvimbela ngokuphelele ukufunda kwakho nokucubungula idatha, uhlaziya kancane ngesikhathi esengeziwe.

Izindlela Ezi-4 Zokususa Imigqa Engenalutho ku-Excel

 

Njengoba uzobona, kunezindlela ezahlukene, ikakhulukazi sizokufundisa ezine, futhi ngale ndlela uzokwazi ukususa imigqa engenalutho ku-Excel. Ekugcineni sizokunikeza kwe yini ukuqeda leyo migqa, ngendlela ebanziku. Kodwa yebo, uma kwenzeka unentshisekelo sinenye indatshana yakamuva esikhuluma ngayo Sebenzisa i-AI ku-Excel ukuze ubale amafomula ngokunembile nalula. Uma kwenzeka futhi ungumsebenzisi we-Mac, siphinde sibe nomhlahlandlela wokuthi izinqamuleli zekhibhodi ku-Excel ye-Mac. Kubonakale okwabonwa ku Tecnobits Sithanda i-Excel, kodwa ngaphezu kwakho konke sikusiza ngakho.

Susa imigqa engenalutho ngesandla

Ingabe unayo idatha encane kufayela lakho le-Excel? Ngakho lena indlela. Kulokhu kuphela lapho kuyokufanelekela ukuwasusa mathupha, gcina lokho engqondweni. Uma lokhu kuyindaba yakho, landela lezi zinyathelo:

• Khetha imigqa engenalutho, okungukuthi, ezingenalutho. Uma ubona ukuthi yonke leyo migqa emhlophe ihlakazekile, ungayikhetha ngokubamba ukhiye u-Ctrl ngenkathi uchofoza kuyo.
• Manje chofoza kwesokudla noma yikuphi kukho konke ukukhetha bese ucindezela inkinobho "susa"
• Ukuze uhlole ukuthi akulona iphutha, ibhokisi lengxoxo lizovela, futhi lizokunikeza inketho yokwenza kanjalo "Yonke imigqa" uma usuyikhethile kuzodingeka uchofoze okuthi "Yamukela"

Niyabo? Uma ubuzibuza ukuthi ungayisusa kanjani imigqa engenalutho ku-Excel, bekushesha futhi kusebenza ngempumelelo, akunjalo? Kodwa khumbula ukuthi lokhu kuphela amanani amancane emigqa engenalutho, kungenjalo uzohlanya.

Sebenzisa izihlungi ukuze uthole futhi ususe imigqa engenalutho

Ngokungafani nendlela yangaphambilini, manje lena eyenzelwe amanani amakhulu emigqa engenalutho. Nakhu sihamba nomhlahlandlela wokuhlunga:

• Khetha ububanzi bedatha noma ikholomu ofuna ukuyishiya ngaphandle kwemigqa engenalutho
• Iya kubha yamathuluzi yohlelo bese ukhetha ithebhu "Idatha", bese uchofoza "Hlunga". Uzobona imenyu yokudonsela phansi.
• Chofoza isihlungi sekholomu lapho ufuna ukususa khona imigqa engenalutho. Susa ukumaka zonke izinketho ngaphandle kokuthi "Abamhlophe" 
• Kuleli qophelo ishidi lizokukhombisa kuphela imigqa emhlophe, ukhethe futhi khetha ukususa.

Susa imigqa engenalutho ngomsebenzi othi Iya kokuthi Okukhethekile

Kusengenye indlela yamashidi e-Excel anedatha eningi. Ngale ndlela ungakwazi khetha yonke imigqa engenalutho kukholomu noma umugqa ngokuzenzakalelayo:

• Khetha ibanga ledatha noma ikholomu ngqo oyifunayo
• Manje kuzodingeka ucindezele inhlanganisela Ctrl + G noma uye kuthebhu ethi “Ekhaya” bese ukhetha okuthi “thola bese ukhetha” manje chofoza okuthi Iya kokuthi Okukhethekile.
• Manje khetha "Amaseli Angenalutho" bese uchofoza okuthi KULUNGILE
• Uma usunakho konke okukhethiwe kuzodingeka uye kuyo "ekhaya" bese "susa" bese ukhetha "susa imigqa yeshidi"

Imakhro yokususa imigqa engenalutho ku-Excel

Njengoba sathembisa, lapha sizokushiyela i-macro. I-macro, uma umusha ku-Excel, ayilutho nje umyalo ozowenza ngokuzenzakalelayo umsebenzi wakho. Ukuze ukwazi ukuyifaka kuzomele wenze lokhu okulandelayo:

• Sebenzisa inhlanganisela yokhiye I-Alt + F11 ukuze uvule umhleli we-Visual Basic for Applications
• Manje ku-Visual Basic editor, chofoza "faka" bese kuthi "module"
• Kopisha ikhodi esikushiyela yona ngezansi futhi ngemva kokuyikopisha cindezela ukhiye F5 noma "Run" ukuze i-macro yenze umsebenzi wayo

I-Sub DeleteImigqa Engenalutho()
Fiphalisa Ububanzi Njengobubanzi
Fiphalisa Iseli Njengobubanzi
Kuphutha Qalisa kabusha Okulandelayo
Setha Ububanzi = ActiveSheet.UsedRange
Ngeseli Ngalinye Ebangeni
Uma Isicelo.WorksheetFunction.CountA(Cell.EntireRow) = 0 Bese
Iseli.Umugqa Wonke.Susa
Qeda Uma
Iseli Elilandelayo
Qeda i-Sub

Kungani kufanele ngisuse imigqa engenalutho ku-Excel?

Ngemva kokukunikeza izindlela, futhi njengoba sazi ukuthi usuvele ufunde ukususa imigqa engenalutho phakathi Excel, sikutshele ngaphambilini ukuthi sizokutshela ukuthi kungani unefayela elicacile. Futhi uma ukwazi ukufunda ukuthi ungaziqeda kanjani, uzofinyelela okulandelayo:

• Uzothuthukisa ifayela le-Excel ukuze ingasindi futhi yonke into ilayisha ngokushesha
• Uzokwenza ngcono ukubona ngeso nokuhlaziya yedatha equkethe. Uzosula yonke into.
• Isamba sokuvimbela iphutha sibonga ukuthi ifayela lihlanzekile emigqeni engenalutho noma engenalutho.
• Ekugcineni, Ukwethula ifayela eliphelele, ngaphandle kwamaphutha, kukhuluma kahle ngawe, ikakhulukazi uma kungaphakathi komsebenzi wakho. Yingakho sikutshela ukuthi kusho ukuthini ukutshala imali kuwe.

Ukufunda ukususa imigqa engenalutho ku-Excel kuyisisekelo salolu hlelo. Futhi siyajabula ukuthi ufika Tecnobits ukufunda nathi. Ngoba njengoba usufike lapha, sikushiyela esinye isihloko mayelana Amafomula e-Excel abalulekile okuqala ukufunda amafomula e-Excel.