Okuqukethwe
I-Microsoft Office Excel inomsebenzi osetha ukufometha okufanayo kwezingcezu ezimbalwa zetafula ngesikhathi esisodwa. Lesi sihloko sizochaza izici eziyinhloko zenketho.
Unika amandla Umdwebi Wefomethi
Unganika amandla le modi ngendlela elandelayo:
- Vula i-Excel bese ukhetha iseli ofuna ukukopisha kulo ifomethi.
- Iya engxenyeni ethi “Ekhaya” phezulu kwemenyu enkulu bese uchofoza inkinobho ethi “Fometha Umdwebi”. Itholakala eduze kwegama elithi "Faka".
- Khetha ububanzi bamaseli kuthebula ofuna ukusebenzisa kulo ukufometha okufanayo nento yoqobo. Uma umsebenzisi ekhulula inkinobho yegundane engakwesokunxele, umsebenzi uyaqedwa.
Nakani! Ngemva kokuvula lo msebenzi, isithonjana somshanelo sizovela eduze kwekhesa evamile ku-Excel.
Izici Zomdwebi Wefomethi
Ukuze usiqonde kangcono isihloko, kubalulekile ukucabangela amathuba amaningi okuthi ukufometha okunjalo kunakho. Kuneziningana zazo:
- Ikhono lokukopisha ifomethi yeseli eyodwa. Inani lamaseli ongakopisha kuwo ifomethi alinqunyelwe.
- Umsebenzi usebenza kuyo yomibili imigqa namakholomu anoma yiliphi ithebula. Ngaphezu kwalokho, uhla olukhethiwe lwezakhi luzohambisana ngokugcwele nelokuqala.
- Ngosizo lwalolu khetho, kungenzeka ukususa amafomethi angadingekile kwamanye amaseli ohlu lwetafula.
- Uma uchofoza inkinobho yokufometha kabili nge-LMB, umyalo uzolungiswa, futhi umsebenzisi uzokwazi ukuletha amaseli amaningi ngendlela eyodwa kuze kube yilapho ecindezela ukhiye we-Esc kukhibhodi.
- Amathuba okufometha ngokwesampula yanoma yiziphi izici: izithombe, umbala, amashadi, amagrafu, njll.
Okhiye bokushisa ukuze uvule I-Format Painter
Ku-Excel, noma yimuphi umyalo, umsebenzi ungaqaliswa ngenhlanganisela yezinkinobho ezikhethekile kukhibhodi yekhompyutha. Ukuze unike amandla imodi “Yomdwebi Wefomethi”, uzodinga ukwenza lokhu okulandelayo:
- Sebenzisa inkinobho yegundane kwesokunxele ukuze ukhethe ibanga lamaseli noma into eyodwa ofuna ukuyikopisha ifomethi yayo.
- Ngesikhathi esifanayo cindezela izinkinobho "Ctrl + C" kusukela kukhibhodi ye-PC, ushintshela kusakhiwo sesiNgisi.
- Hambisa ikhesa yegundane kwenye iseli bese ucindezela izinkinobho "Ctrl + V". Ngemva kwalokho, le elementi izothatha ifomethi yeseli yokuqala kanye nokuqukethwe kwayo.
Kubalulekile! Ungasebenzisa futhi inhlanganisela ethi “Ctrl + Shift + V” ukuze ufomethe ngokuya ngesampula. Nokho, ukuze wenze lokhu, kuzodingeka ubhale ikhodi encane futhi uyigcine encwadini yakho enkulu.
Ngemva kokubhalwa kwekhodi, i-hotkey izodinga ukungezwa ohlwini lwemiyalo ye-Excel. Ukuze ubhekane nomsebenzi, udinga ukwenza izinyathelo ezimbalwa ezilula ngokuya nge-algorithm:
- Faka ithebhu ethi "Buka" kubha yamathuluzi ephezulu yohlelo.
- Nweba imenyu ethi “Macros” ngokuchofoza i-LMB kumcibisholo oseduze kwayo.
- Kumenyu yokuqukethwe, khetha into enegama elifanayo.
- Ewindini elivulayo, ngaphansi komugqa "I-Macro Name", igama lekhodi engeziwe lizobhalwa. Kufanele ikhethwe ngenkinobho yegundane engakwesokunxele bese uchofoza inkinobho ethi "Parameters" kubha yamathuluzi ngakwesokudla kwewindi.
- Kuthebhu evelayo, engxenyeni ethi "Isinqamuleli Sekhibhodi", cindezela izinkinobho "Ctrl + Shift + V" ukuze wengeze ukhiye oshisayo, bese uchofoza u-"KULUNGILE" ukuze usebenzise izinguquko.
Ungawusebenzisa kanjani umyalo "Ctrl+Shift+V".
Ngemuva kokudala i-hotkey, udinga ukuqonda ukuthi ungawusebenzisa kanjani lo myalo. Umgomo wokusebenza kwenhlanganisela "Ctrl + Shift + V" ungabonakala ngale ndlela elandelayo:
- Khetha ububanzi bezinto ofuna ukukopisha kuzo ifomethi.
- Cindezela izinkinobho ze-“Ctrl + C” ukuze wengeze okuqukethwe kweseli ebhodini lokunamathisela.
- Hambisa ohlwini olufunayo lweshidi bese ubamba inhlanganisela "Ctrl + Shift + V".
- Hlola umphumela.
Ulwazi Olwengeziwe! Ngemva kokucindezela izinkinobho ze-“Ctrl + C”, iseli lokuqala lizogqanyiswa ngombala ohambisanayo. Lesi simo sikhombisa ukuqala komsebenzi weqembu.
Umsebenzi we-Format Painter wenza kube lula ukukopisha izimo nemifanekiso ehlukahlukene. Uma nje udinga ukukopisha okuqukethwe kweseli ethile, ungasebenzisa inhlanganisela "Ctrl + Shift + V"
Ungakopisha kanjani ngokushesha okuqukethwe kweseli kuthebula
Kunezindlela eziningana zokukopisha okunjalo. Nokho, indlela elula futhi ephumelela kakhulu ihlukaniswe ngezinyathelo ezilandelayo:
- Khetha i-elementi yohlu lwethebula, okuqukethwe kwayo okufanele kudluliselwe kwelinye iseli.
- Khetha iseli oyifunayo ngokuyikhetha ngenkinobho yegundane engakwesokunxele.
- Hambisa ikhesa yegundane emugqeni wokufaka amafomula emugqeni ophezulu wemenyu enkulu yohlelo.
- Faka uphawu "=" emgqeni bese ukhomba iseli elingumthombo.
- Cindezela okuthi “Enter” kusukela kukhibhodi ukuze uqedele umsebenzi.
- Hlola umphumela. Okuqukethwe kwe-elementi yoqobo kufanele kuthuthele kwekhethiwe.
Nakani! Ngokufanayo, ungagcwalisa uhla olufunayo lwamaseli epuletini.
Isiphetho
Ngakho-ke, i-Microsoft Office Excel inenani elikhulu lezici eziwusizo ezikuvumela ukuthi wenze inqubo ethile ngokuzenzakalelayo. Ukufometha kwezimbotshana zephethini kungenye yezinketho ezinjalo. Zonke izindlela zokuyisebenzisa nokuyisebenzisa zixoxiwe ngenhla.