Ungeza kanjani ikholomu ku-Excel. Ukwengeza ikholomu entsha, amakholomu angu-2 nekholomu ekugcineni kwethebula

Ukwengeza amakholomu amasha kuthebula kuyikhono elibalulekile wonke umsebenzisi wespredishithi se-Excel okufanele abe nalo. Ngaphandle kwaleli khono, akunakwenzeka ukusebenza ngempumelelo ngedatha yethebula. Kulesi sihloko, sizobheka izindlela eziningi eziwusizo zokudala amakholomu engeziwe ephepheni lomsebenzi wedokhumenti.

Yengeza ikholomu entsha

Kunezinketho ezimbalwa zokwengeza ikholomu entsha ekhasini lokusebenzela. Indlela ngayinye kulezi ezingezansi ilula kakhulu ukuzenza, ngakho-ke ngisho nosaqalayo angakwazi ukuyiphatha. Ake sicabangele indlela ngayinye ngokuningiliziwe.

Indlela 1. Ukufaka ikholomu ngebha yokuxhumanisa

Le ndlela ilula futhi isebenziseka kalula. Isebenzisa ukungezwa kwekholomu entsha noma umugqa owengeziwe kudatha yethebula. I-Walkthrough ibonakala kanje:

1. Sithola iphaneli yokuxhumanisa yohlobo oluvundlile bese uchofoza egameni lekholomu lapho sifuna ukwengeza khona ikholomu entsha. Ngemva kokwenza le nqubo, ikholomu yonke izogqanyiswa ekhasini lokusebenza.

2. Sichofoza i-RMB kunoma iyiphi indawo yesiqeshana esikhethiwe. Imenyu yokuqukethwe encane iboniswe esikrinini. Sithola into ebizwa ngokuthi “Faka” bese uchofoza kuyo ngenkinobho yegundane engakwesokunxele.

3. Ilungile! Senze isengezo sekholomu entsha engenalutho kwesokunxele sekholomu ekhethwe ekuqaleni.

Indlela yesi-2: Ukwengeza Ikholomu Ukusebenzisa Imenyu Yokuqukethwe Kweseli

Le ndlela, njengeyangaphambili, ihilela ukusebenzisa imenyu yokuqukethwe, kodwa hhayi ikholomu yonke ekhethiwe lapha, kodwa iseli eyodwa kuphela. I-Walkthrough ibonakala kanje:

1. Khetha iseli elingakwesokunxele lapho sihlela ukwakha ikholomu eyengeziwe. Ukukhetha kwenziwa kusetshenziswa inkinobho yegundane engakwesokunxele noma imicibisholo ekukhibhodi.

2. Chofoza kwesokudla kuseli elikhethiwe. Imenyu yokuqukethwe ejwayelekile iboniswe esikrinini. Sithola into ethi “Faka…” bese uchofoza kuyo ngenkinobho yegundane engakwesokunxele.

3. Iwindi elincane livele esibukweni, lapho kufanele ucacise ukuthi iyiphi into ezongezwa epuleti. Kunezinhlobo ezintathu ze-elementi: iseli, irowu nekholomu. Sibeka uphawu eduze kombhalo othi "Ikholomu". Ngemuva kokwenza konke ukukhohlisa, chofoza inkinobho ethi "OK", etholakala phansi kwefasitela.

4. Ilungile! Senze isengezo sekholomu entsha engenalutho kwesokunxele sekholomu ekhethwe ekuqaleni.

Indlela yesi-3: Namathisela usebenzisa amathuluzi akuribhoni

Kuribhoni, etholakala phezulu kwesixhumi esibonakalayo sespredishithi se-Excel, kunesici esikhethekile esikuvumela ukuthi ufake ikholomu entsha etafuleni. Isifundo sesinyathelo ngesinyathelo sibukeka kanje:

1. Khetha iseli elingakwesokunxele lapho sihlela ukwakha ikholomu eyengeziwe. Ukukhetha kwenziwa kusetshenziswa inkinobho yegundane engakwesokunxele noma imicibisholo ekukhibhodi.

2. Sithuthela engxenyeni ethi “Ekhaya”, etholakala phezulu kwesixhumi esibonakalayo sespredishithi. Nweba uhlu lwento ethi "Faka". Ohlwini oluvulayo, thola inkinobho ethi “Faka amakholomu eshidini” bese uchofoza kulo.

3. Ilungile! Senze umsebenzi wokwengeza ikholomu entsha engenalutho kwesokunxele sekholomu ekhethwe ekuqaleni

Indlela 4. Okhiye abashisayo bokufaka ikholomu entsha

Ukusebenzisa ama-hotkeys kungenye indlela edume kakhulu phakathi kwabasebenzisi bespredishithi be-Excel abanolwazi. Kunezinhlobonhlobo ezimbili zale ndlela. Indlela yokuqala yokulandela umkhondo imi kanje:

1. Chofoza egameni lekholomu kuphaneli yezixhumanisi.

Khumbula! Ikholomu eyengeziwe ihlale yengezwa kwesokunxele sekholomu ekhethiwe.

2. Cindezela inhlanganisela yokhiye kukhibhodi "Ctrl" + "+". Ngemva kokwenza konke ukukhohlisa, ikholomu entsha izovela kwesokunxele sekholomu ekhethiwe.

Ukuhamba kwendlela yesibili imi kanje:

1. Chofoza iseli ngenkinobho yegundane kwesokunxele.
2. Cindezela inhlanganisela yokhiye kukhibhodi "Ctrl" + "+".
3. Iwindi elijwayelekile elibizwa ngokuthi “Engeza Amaseli” liboniswe esikrinini. Sibeka imfashini eduze kombhalo othi "Ikholomu". Ngemuva kokwenza konke ukukhohlisa, chofoza inkinobho ethi "OK", etholakala phansi kwefasitela.

4. Ilungile! Ngemva kokwenza zonke izenzo kwesokunxele sekholomu ekhethiwe, kuzovela ikholomu entsha.

Ifaka amakholomu amabili noma ngaphezulu

Kunezimo lapho umsebenzisi wespredishithi edinga ukufaka amakholomu amaningana engeziwe ngesikhathi esisodwa. Ukusebenza kohlelo kwenza kube lula ukwenza lokhu. I-Walkthrough ibonakala kanje:

1. Ekuqaleni, sikhetha amaseli ngokuvundlile. Udinga ukukhetha amaseli amaningi njengoba kunamakholomu engeziwe ohlela ukuwangeza.

Nakani! Futhi akunandaba ukuthi ukukhetha kwenziwa kuphi. Ungakhetha amaseli kokubili kuthebula ngokwalo nakuphaneli yokuxhumanisa.

2. Sisebenzisa imihlahlandlela echazwe ngenhla, senza inqubo yokwengeza amakholomu engeziwe. Esibonelweni sethu esithile, sivule imenyu yokuqukethwe ngenkinobho yegundane elingakwesokudla futhi sakhetha into ethi "Faka".

3. Ilungile! Senze ukungezwa kwamakholomu engeziwe amasha angenalutho kwesokunxele kulawo makholomu akhethwe ekuqaleni.

Faka ikholomu ekugcineni kwetafula

Zonke izindlela ezingenhla zifanelekile kuphela kulezo zimo lapho kudingekile ukwengeza ikholomu eyodwa noma ngaphezulu eyengeziwe phakathi noma ekuqaleni kwepuleti elitholakala ekhasini lokusebenza ledokhumenti. Yiqiniso, usebenzisa lezi zindlela, ungakwazi ukwengeza amakholomu amasha ekupheleni kwetafula, kodwa-ke kuzodingeka uchithe isikhathi esiningi uhlela.

Ukuze usebenzise ukufakwa kwamakholomu amasha kuthebula ngaphandle kokufometha okwengeziwe, kunendlela eyodwa ewusizo. Kulele eqinisweni lokuthi ipuleti evamile iphenduka ibe "smart" eyodwa. I-Walkthrough ibonakala kanje:

1. Sikhetha ngokuphelele wonke amaseli wetafula lethu. Kunezindlela eziningi zokugqamisa yonke idatha. Sizosebenzisa inhlanganisela yokhiye kukhibhodi "CTRL + A".

2. Sithuthela engxenyeni ethi "Ekhaya", etholakala phezulu kwesixhumi esibonakalayo. Sithola ibhulokhi yemiyalo ethi "Izitayela" bese uchofoza into ethi "Fometha njengethebula".

3. Uhlu olunezitayela luvuliwe. Sikhetha isitayela esifanele "sethebula elihlakaniphile" ngokucindezela inkinobho yegundane kwesokunxele.

4. Iwindi elincane elibizwa ngokuthi “Ithebula Lefomethi” liboniswe esikrinini. Lapha udinga ukucacisa imingcele yendawo ekhethiwe. Ngokukhetha okulungile kokuqala, asikho isidingo sokushintsha noma yini lapha. Uma ubona idatha engalungile, ungayihlela. Faka uphawu lokuhlola eduze kwento ethi “Ithebula elinezihloko”. Ngemuva kokwenza konke ukukhohlisa, chofoza inkinobho ethi "OK".

5. Njengomphumela wokukhohlisa kwethu, ipuleti lokuqala laphenduka laba “elihlakaniphile”.

6. Kufanele nje sengeze ikholomu entsha ekugcineni kwethebula. Simane sigcwalise ulwazi oludingekayo nganoma iyiphi iseli etholakala kwesokudla sethebula elithi “smart”. Ikholomu egcwaliswe ngedatha ngokuzenzekelayo izoba ingxenye "yetafula elihlakaniphile". Konke ukufometha kuzogcinwa.

Ungayifaka kanjani ikholomu phakathi kwamakholomu ku-Excel?

Manje ake sikhulume kabanzi mayelana nendlela yokufaka ikholomu phakathi kwamanye amakholomu kusipredishithi se-Excel. Ake sibheke isibonelo esithile. Isibonelo, sinohlu lwamanani olunezinombolo zezinto ezingekho. Sidinga ukwengeza ikholomu eyengeziwe phakathi kwamakholomu ukuze sigcwalise izinombolo zento yohlu lwamanani. Kunezindlela ezimbili zokwenza le nqubo.

Indlela yokuqala yokulandela umkhondo imi kanje:

1. Hambisa isikhombi segundane kuseli A1 bese usikhetha.
2. Sithuthela engxenyeni ethi “Ekhaya”, etholakala phezulu kwesixhumi esibonakalayo sespredishithi. Sithola ibhulokhi yemiyalo ebizwa ngokuthi "Amaseli" bese ukhetha into ethi "Faka".
3. Uhlu oluncane luvuliwe, lapho udinga ukukhetha into ethi "Faka amakholomu eshidini".

4. Ilungile! Sisebenzise ukungezwa kwekholomu eyengeziwe engenalutho entsha phakathi kwamakholomu.

Ukuhamba kwendlela yesibili imi kanje:

1. Chofoza kwesokudla kukholamu A.
2. Imenyu yokuqukethwe encane iboniswe esikrinini, lapho udinga ukukhetha into ebizwa ngokuthi "Faka".

3. Ilungile! Sisebenzise ukungezwa kwekholomu eyengeziwe engenalutho entsha phakathi kwamakholomu.

Ngemva kokusebenzisa enye yezindlela ezimbili ezichazwe ngenhla, singaqala ukugcwalisa ikholomu edaliwe ngezinombolo zezinto zohlu lwamanani.

Faka amakholomu amaningi phakathi kwamakholomu ngesikhathi esisodwa

Ngokuqhubeka nesibonelo senani esingenhla, ake sithole ukuthi siwengeza kanjani amakholomu amaningi phakathi kwamakholomu ngesikhathi esisodwa. Uhlu lwamanani alunawo amakholomu angu-2: amanani namayunithi okulinganisa (izingcezu, amakhilogremu, amalitha, amaphakheji, njalonjalo). I-Walkthrough ibonakala kanje:

1. Ukuze sisebenzise ukungezwa kwamakholomu amabili engeziwe, sidinga ukwenza inqubo yokukhetha ububanzi bamaseli angu-2. Sigqamisa i-C1:D

2. Sithuthela engxenyeni ethi “Ekhaya”, etholakala phezulu kwesixhumi esibonakalayo sespredishithi. Sithola ibhulokhi yemiyalo ebizwa ngokuthi "Amaseli" bese ukhetha into ethi "Faka". Uhlu oluncane luvuliwe, lapho udinga ukukhetha into ethi "Faka amakholomu eshidini".
3. Ilungile! Senze umsebenzi wokwengeza amakholomu amabili phakathi kwamakholomu amabili.

Kukhona enye indlela yokwenza le nqubo. I-Walkthrough ibonakala kanje:

1. Sikhetha izihloko zekholomu ezimbili C no-D.
2. Chofoza inkinobho yegundane kwesokudla. Imenyu yokuqukethwe ejwayelekile iyavula. Sithola into ebizwa ngokuthi “Faka” bese uchofoza kuyo nge-LMB.

3. Ilungile! Senze umsebenzi wokwengeza amakholomu amabili phakathi kwamakholomu amabili.

Ngezinye izikhathi kwenzeka ukuthi umsebenzisi, ngenkathi esebenza ngolwazi lwethebula, ngephutha wengeza ikholomu engadingekile. Ake sithole ukuthi singayenza kanjani inqubo yokususa. I-Walkthrough ibonakala kanje:

1. Khetha ububanzi bamaseli esihlela ukuwasusa amakholomu awo.
2. Sidlulela esigabeni esithi "Ekhaya", sithola ibhulokhi ethi "Susa" bese uchofoza into ebizwa ngokuthi "Susa amakholomu eshidini." Ngaphandle kwalokho, chofoza kwesokudla ukuze uvule imenyu yokuqukethwe bese ukhetha into ethi "Susa".
3. Ilungile! Sisebenzise ukususwa kwamakholomu angadingekile kudatha yethebula.

Kubalulekile ukukhumbula! Amakholomu engeziwe ahlala engezwa kwesokunxele samakholomu akhethiwe. Inani lamakholomu amasha lincike enanini lamakholomu abelwe ekuqaleni. Ukuhleleka kwamakholomu afakiwe kuncike kuhlelo lokukhetha (ngokukodwa nokunye).

Isiphetho

Ispredishithi se-Excel sinenani elikhulu lezindlela ezikuvumela ukuthi ungeze amakholomu engeziwe kunoma iyiphi indawo etafuleni. Ukuguqula idatha yomthombo ibe "ithebula elihlakaniphile" kukuvumela ukuthi ufake amakholomu engeziwe ngaphandle kokuchitha isikhathi ekufometheni, njengoba ukubonakala kwamakholomu amasha kuzothatha ukufometha kwethebula eliqediwe. Izinhlobo eziningi zezindlela zokwengeza amakholomu zivumela umsebenzisi ngamunye ukuthi azikhethele elula kakhulu.