I-Painter Yefomethi - Okhiye abashisayo ku-Excel

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:

  1. Vula i-Excel bese ukhetha iseli ofuna ukukopisha kulo ifomethi.
  2. Iya engxenyeni ethi “Ekhaya” phezulu kwemenyu enkulu bese uchofoza inkinobho ethi “Fometha Umdwebi”. Itholakala eduze kwegama elithi "Faka".
Fometha Umdwebi - Okhiye bokushisa ku-Excel
Ukuvela kwenkinobho ethi “Format Painter” ku-Microsoft Office Excel. Ukuqala umsebenzi ngombhalo, mane ucindezele kanye
  1. Khetha ububanzi bamaseli kuthebula ofuna ukusebenzisa kulo ukufometha okufanayo nento yoqobo. Uma umsebenzisi ekhulula inkinobho yegundane engakwesokunxele, umsebenzi uyaqedwa.
Fometha Umdwebi - Okhiye bokushisa ku-Excel
Khetha ububanzi obufunekayo bamaseli ukuze usebenzise ukufometha njengesampula. Isithombe-skrini sibonisa ukukopisha idatha yeseli eyodwa kuphela.

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:

  1. Ikhono lokukopisha ifomethi yeseli eyodwa. Inani lamaseli ongakopisha kuwo ifomethi alinqunyelwe.
  2. Umsebenzi usebenza kuyo yomibili imigqa namakholomu anoma yiliphi ithebula. Ngaphezu kwalokho, uhla olukhethiwe lwezakhi luzohambisana ngokugcwele nelokuqala.
  3. Ngosizo lwalolu khetho, kungenzeka ukususa amafomethi angadingekile kwamanye amaseli ohlu lwetafula.
  4. 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.
  5. 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:

  1. Sebenzisa inkinobho yegundane kwesokunxele ukuze ukhethe ibanga lamaseli noma into eyodwa ofuna ukuyikopisha ifomethi yayo.
  2. Ngesikhathi esifanayo cindezela izinkinobho "Ctrl + C" kusukela kukhibhodi ye-PC, ushintshela kusakhiwo sesiNgisi.
  3. 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.

Fometha Umdwebi - Okhiye bokushisa ku-Excel
IMacro Yomdwebi Wefomethi

Ngemva kokubhalwa kwekhodi, i-hotkey izodinga ukungezwa ohlwini lwemiyalo ye-Excel. Ukuze ubhekane nomsebenzi, udinga ukwenza izinyathelo ezimbalwa ezilula ngokuya nge-algorithm:

  1. Faka ithebhu ethi "Buka" kubha yamathuluzi ephezulu yohlelo.
  2. Nweba imenyu ethi “Macros” ngokuchofoza i-LMB kumcibisholo oseduze kwayo.
  3. Kumenyu yokuqukethwe, khetha into enegama elifanayo.
  4. 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.
Fometha Umdwebi - Okhiye bokushisa ku-Excel
Izenzo efasiteleni le-Macro
  1. Kuthebhu evelayo, engxenyeni ethi "Isinqamuleli Sekhibhodi", cindezela izinkinobho "Ctrl + Shift + V" ukuze wengeze ukhiye oshisayo, bese uchofoza u-"KULUNGILE" ukuze usebenzise izinguquko.
Fometha Umdwebi - Okhiye bokushisa ku-Excel
Ukwengeza i-hotkey entsha kuhlu lwezinhlanganisela ezitholakalayo ku-Microsoft Office Excel

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:

  1. Khetha ububanzi bezinto ofuna ukukopisha kuzo ifomethi.
  2. Cindezela izinkinobho ze-“Ctrl + C” ukuze wengeze okuqukethwe kweseli ebhodini lokunamathisela.
  3. Hambisa ohlwini olufunayo lweshidi bese ubamba inhlanganisela "Ctrl + Shift + V".
  4. 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:

  1. Khetha i-elementi yohlu lwethebula, okuqukethwe kwayo okufanele kudluliselwe kwelinye iseli.
  2. Khetha iseli oyifunayo ngokuyikhetha ngenkinobho yegundane engakwesokunxele.
  3. Hambisa ikhesa yegundane emugqeni wokufaka amafomula emugqeni ophezulu wemenyu enkulu yohlelo.
  4. Faka uphawu "=" emgqeni bese ukhomba iseli elingumthombo.
Fometha Umdwebi - Okhiye bokushisa ku-Excel
Ukusetha uphawu olulinganayo kubha yefomula ye-Excel
  1. Cindezela okuthi “Enter” kusukela kukhibhodi ukuze uqedele umsebenzi.
Fometha Umdwebi - Okhiye bokushisa ku-Excel
Ukukhetha iseli lomthombo ukuze likopishe elikuqukethe
  1. 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.

shiya impendulo