Ungasenza kanjani isixhumanisi ku-Excel. Ukudala izixhumanisi ku-Excel kwelinye ishidi, kwenye incwadi, isixhumanisi

Ukudala izixhumanisi kuyinkambiso lapho wonke umsebenzisi wespredishithi e-Excel abhekana nayo. Izixhumanisi zisetshenziselwa ukusebenzisa ukuqondisa kabusha emakhasini athile ewebhu, kanye nokufinyelela noma yimiphi imithombo yangaphandle noma imibhalo. Kulesi sihloko, sizocubungula inqubo yokudala izixhumanisi futhi sithole ukuthi yiziphi izinto ezingenziwa ngazo.

Izinhlobonhlobo zezixhumanisi

Kunezinhlobo ezi-2 eziyinhloko zezixhumanisi:

1. Izithenjwa ezisetshenziswa kumafomula wokubala ahlukahlukene, kanye nemisebenzi ekhethekile.
2. Izixhumanisi ezisetshenziselwa ukuqondisa kabusha ezintweni ezithile. Abizwa ngokuthi ama-hyperlink.

Zonke izixhumanisi (izixhumanisi) zihlukaniswe ngezinhlobo ezi-2.

• uhlobo lwangaphandle. Isetshenziselwa ukuqondisa kabusha into ekwenye idokhumenti. Isibonelo, kolunye uphawu noma ikhasi lewebhu.
• Uhlobo lwangaphakathi. Isetshenziselwa ukuqondisa kabusha entweni etholakala encwadini yokusebenzela efanayo. Ngokuzenzakalelayo, asetshenziswa ngendlela yamanani opharetha noma izakhi ezisizayo zefomula. Isetshenziselwa ukucacisa izinto ezithile ngaphakathi kwedokhumenti. Lezi zixhumanisi zingaholela kokubili ezintweni zeshidi elifanayo nasezintweni zamanye amaphepha okusebenza edokhumenti efanayo.

Kunezinhlobonhlobo eziningi zokwakha izixhumanisi. Indlela kufanele ikhethwe, kucatshangelwa ukuthi hlobo luni lwereferensi oludingekayo kudokhumenti yokusebenza. Ake sihlaziye indlela ngayinye ngokuningiliziwe.

Uzidala kanjani izixhumanisi eshidini elifanayo

Isixhumanisi esilula ukucacisa amakheli eseli ngendlela elandelayo: =B2.

Uphawu elithi “="” luyingxenye eyinhloko yesixhumanisi. Ngemva kokubhala lo mlingisi emgqeni wokufaka amafomula, isipredishithi sizoqala ukubona leli nani njengereferensi. Kubaluleke kakhulu ukufaka kahle ikheli leseli ukuze uhlelo lucubungule kahle ulwazi. Esibonelweni esicatshangelwe, inani elithi "=B2" lisho ukuthi inani elisuka kuseli B3 lizothunyelwa kunkambu D2, lapho sifake khona isixhumanisi.

Kuyaphawuleka! Uma sihlela inani ku-B2, khona-ke lizoshintsha ngokushesha kuseli D3.

Konke lokhu kukuvumela ukuthi wenze imisebenzi ehlukahlukene ye-arithmetic kusiprosesa sespredishithi. Isibonelo, masibhale ifomula elandelayo ensimini D3: =A5+B2. Ngemva kokufaka le fomula, cindezela "Enter". Ngenxa yalokho, sithola umphumela wokwengeza amaseli B2 no-A5.

Eminye imisebenzi ye-arithmetic ingenziwa ngendlela efanayo. Kunezitayela ezi-2 zokuxhumanisa eziyinhloko kusipredishithi:

1. Ukubuka okujwayelekile - A1.
2. Ifomethi R1C Inkomba yokuqala ikhombisa inombolo yomugqa, bese eyesi-2 ikhombisa inombolo yekholomu.

I-walkthrough yokushintsha isitayela sokuhlanganisa imi kanje:

1. Sithuthela esigabeni "Ifayela".

2. Khetha into ethi "Izinketho" etholakala engxenyeni engezansi kwesokunxele sewindi.

3. Iwindi elinezinketho liyavela esikrinini. Sithuthela esigatshaneni esibizwa ngokuthi "Amafomula". Sithola "Ukusebenza ngamafomula" bese sibeka uphawu eduze kwesici "Isitayela sereferensi R1C1". Ngemuva kokwenza konke ukukhohlisa, chofoza "OK".

Kunezinhlobo ezi-2 zezixhumanisi:

• Ukubhekisela ngokuphelele endaweni yento ethile, kungakhathaliseki ukuthi iyiphi i-elementi enokuqukethwe okunikeziwe.
• Isihlobo sibhekisela endaweni yezinto ezihlotshaniswa neseli yokugcina ngesisho esibhaliwe.

Nakani! Kuzikhombo eziphelele, uphawu lwedola oluthi “$” lunikezwa ngaphambi kwegama lekholomu nenombolo yomugqa. Ngokwesibonelo, $B$3.

Ngokuzenzakalelayo, zonke izixhumanisi ezingeziwe zibhekwa njengezihlobene. Cabanga ngesibonelo sokukhohlisa izixhumanisi ezihlobene. Ukuhamba:

1. Sikhetha iseli bese sifaka isixhumanisi kwelinye iseli kuyo. Ngokwesibonelo, masibhale: =V1.

2. Ngemva kokufaka isisho, cindezela "Enter" ukuze ubonise umphumela wokugcina.

3. Hambisa ikhesa ekhoneni elingezansi kwesokudla seseli. Isikhombi sizothatha isimo sophawu oluncane olumnyama oluhlanganisayo. Bamba i-LMB bese uhudulela isisho phansi.

4. Ifomula ikopishelwe kumaseli angezansi.

5. Siyaqaphela ukuthi kumaseli aphansi isixhumanisi esifakiwe sishintshile ngokushintsha kwesinyathelo esisodwa. Lo mphumela ungenxa yokusetshenziswa kwereferensi ehlobene.

Manje ake sibheke isibonelo sokukhohlisa izithenjwa eziphelele. Ukuhamba:

1. Sisebenzisa uphawu lwedola “$” silungisa ikheli leseli ngaphambi kwegama lekholomu nenombolo yomugqa.

2. Selula, njengakusibonelo esingenhla, ifomula phansi. Siyaqaphela ukuthi amaseli atholakala ngezansi anezinkomba ezifanayo njengaseselini lokuqala. Isithenjwa esiphelele silungise amanani eseli, futhi manje awashintshi lapho ifomula ishintshwa.

Ukwengeza, kusipredishithi, ungasebenzisa isixhumanisi ebangeni lamaseli. Okokuqala, ikheli leseli elingaphezulu kwesokunxele liyabhalwa, bese kuba iseli elingezansi kwesokudla. Ikholoni “:” ibekwe phakathi kwezixhumanisi. Isibonelo, esithombeni esingezansi, ibanga elithi A1:C6 likhethiwe. Ireferensi yalobu bubanzi ibukeka kanje: =A1:C6.

Dala isixhumanisi kwelinye ishidi

Manje ake sibheke indlela yokudala izixhumanisi kwamanye amashidi. Lapha, ngaphezu kokudidiyelwa kweseli, ikheli lephepha lokusebenzela elithile liyaboniswa. Ngamanye amazwi, ngemva kophawu “=", igama lephepha lokusebenzela liyafakwa, bese kubhalwa uphawu lokubabaza, bese kufakwa ikheli lento edingekayo ekugcineni. Isibonelo, isixhumanisi seseli C5, esisekhasini lokusebenza elibizwa ngokuthi “Sheet2”, sibukeka kanje: = Ishidi2! C5.

Ukuhamba ngezinyawo:

1. Hambisa kuseli oyifunayo, faka uphawu “=". Chofoza i-LMB egameni leshidi, elingaphansi kwesixhumi esibonakalayo sespredishithi.

2. Sithuthele eshidini lesi-2 ledokhumenti. Ngokuchofoza inkinobho yegundane engakwesokunxele, sikhetha iseli esifuna ukulinika ifomula.

3. Ngemuva kokwenza konke ukukhohlisa, cindezela "Enter". Sizithole sikuphepha lokusebenza langempela, lapho isibonisi sokugcina sesivele sikhonjisiwe.

Isixhumanisi sangaphandle esiya kwenye incwadi

Cabangela indlela yokusebenzisa isixhumanisi sangaphandle kwenye incwadi. Isibonelo, sidinga ukusebenzisa ukudalwa kwesixhumanisi seseli B5, esitholakala ekhasini lokusebenza lencwadi evuliwe ethi "Links.xlsx".

Ukuhamba ngezinyawo:

1. Khetha iseli lapho ofuna ukwengeza khona ifomula. Faka uphawu “=".

2. Sithuthela ebhukwini elivuliwe lapho iseli likhona, isixhumanisi esifuna ukusengeza. Chofoza ishidi elidingekayo, bese ucindezela iseli oyifunayo.

3. Ngemuva kokwenza konke ukukhohlisa, cindezela "Enter". Sigcine ekhasini lokusebenza lokuqala, lapho umphumela wokugcina usuvele ubonisiwe.

Xhumanisa nefayela kuseva

Uma idokhumenti itholakala, ngokwesibonelo, kufolda okwabelwana ngayo yeseva yenkampani, khona-ke ingabhekiselwa ngale ndlela elandelayo:

Ibhekisela kububanzi obuqanjwe igama

Isipredishithi sikuvumela ukuthi udale ireferensi yobubanzi obuqanjwe igama, esetshenziswa “Ngomphathi Wegama”. Ukuze wenze lokhu, udinga nje ukufaka igama lobubanzi kusixhumanisi ngokwaso:

Ukuze ucacise isixhumanisi sobubanzi obuqanjwe igama kudokhumenti yangaphandle, udinga ukucacisa igama layo, futhi ucacise nendlela:

Xhuma kuthebula elihlakaniphile noma izici zalo

Usebenzisa i-opharetha ye-HYPERLINK, ungaxhuma kunoma iyiphi ingxenye yethebula "ehlakaniphile" noma kulo lonke ithebula. Kubukeka kanjena:

Kusetshenziswa opharetha INDIRECT

Ukuze wenze imisebenzi eyahlukene, ungasebenzisa umsebenzi okhethekile we-INDIRECT. Ukubuka okujwayelekile komsebenzisi: =INDIRECT(Ireferensi_Yeseli,A1). Ake sihlaziye opharetha ngokuningiliziwe sisebenzisa isibonelo esithile. Ukuhamba:

1. Sikhetha iseli edingekayo, bese uchofoza into ethi "Faka Umsebenzi", etholakala eduze komugqa wokufaka amafomula.

2. Iwindi elibizwa ngokuthi “Faka Umsebenzi” liboniswe esikrinini. Khetha isigaba esithi "Izithenjwa Nezinhlaka".

3. Chofoza into ethi INDIRECT. Ngemuva kokwenza konke ukukhohlisa, chofoza "OK".

4. Isibonisi sibonisa iwindi lokufaka ama-agumenti o-opharetha. Emugqeni othi “Link_to_cell” faka isixhumanisi seseli esifuna ukubhekisela kulo. Ulayini “A1” ushiywe ungenalutho. Ngemuva kokwenza konke ukukhohlisa, chofoza inkinobho ethi "OK".

5. Ilungile! Iseli libonisa umphumela esiwudingayo.

Yini i-hyperlink

Isixhumanisi siwucezu lwedokhumenti olubhekisela entweni ekudokhumenti efanayo noma kwenye into etholakala ku-hard drive noma kunethiwekhi yekhompyutha. Ake sibhekisise inqubo yokudala izixhumanisi.

Dala izixhumanisi

Izixhumanisi azivumeli kuphela "ukukhipha" ulwazi kumaseli, kodwa futhi nokuzulazula kusici esikhonjiwe. Umhlahlandlela wesinyathelo ngesinyathelo ukwakha isixhumanisi:

1. Ekuqaleni, udinga ukungena efasiteleni elikhethekile elikuvumela ukuthi udale isixhumanisi. Kunezinketho eziningi zokwenza lesi senzo. Okokuqala - chofoza kwesokudla kuseli edingekayo bese ukhetha into ethi "Xhuma ..." kumenyu yokuqukethwe. Okwesibili - khetha iseli oyifunayo, hambisa engxenyeni ethi "Faka" bese ukhetha into ethi "Xhuma". Okwesithathu - sebenzisa inhlanganisela yokhiye "CTRL + K".

2. Kuvela iwindi esikrinini elikuvumela ukuthi usethe isixhumanisi. Kukhona ukukhethwa kwezinto eziningana lapha. Ake sihlolisise ukhetho ngalunye.

Ungayakha kanjani isixhumanisi ku-Excel kwenye idokhumenti

Ukuhamba ngezinyawo:

1. Sivula iwindi ukuze sakhe isixhumanisi.
2. Emugqeni othi "Xhuma", khetha into ethi "Ifayela, ikhasi lewebhu".
3. Emgqeni othi "Sesha ku" sikhetha ifolda lapho ifayela likhona, lapho sihlela ukwenza khona isixhumanisi.
4. Emugqeni othi “Umbhalo” sifaka ulwazi lombhalo oluzoboniswa esikhundleni sesixhumanisi.
5. Ngemuva kokwenza konke ukukhohlisa, chofoza "OK".

Ungayakha kanjani isixhumanisi ku-Excel ekhasini lewebhu

Ukuhamba ngezinyawo:

1. Sivula iwindi ukuze sakhe isixhumanisi.
2. Emugqeni othi "Xhuma", khetha into ethi "Ifayela, ikhasi lewebhu".
3. Chofoza inkinobho ethi "Inthanethi".
4. Emgqeni othi "Ikheli" sishayela ekhelini lekhasi le-Inthanethi.
5. Emugqeni othi “Umbhalo” sifaka ulwazi lombhalo oluzoboniswa esikhundleni sesixhumanisi.
6. Ngemuva kokwenza konke ukukhohlisa, chofoza "OK".

Ungayakha kanjani isixhumanisi ku-Excel endaweni ethile kudokhumenti yamanje

Ukuhamba ngezinyawo:

1. Sivula iwindi ukuze sakhe isixhumanisi.
2. Emugqeni othi "Xhuma", khetha into ethi "Ifayela, ikhasi lewebhu".
3. Chofoza ku-“Bhukhmaka…” bese ukhetha ishidi lokusebenzela ukuze wakhe isixhumanisi.
4. Ngemuva kokwenza konke ukukhohlisa, chofoza "OK".

Ungayakha kanjani isixhumanisi ku-Excel encwadini yokusebenzela entsha

Ukuhamba ngezinyawo:

1. Sivula iwindi ukuze sakhe isixhumanisi.
2. Emgqeni othi "Xhuma", khetha into ethi "Idokhumenti Entsha".
3. Emugqeni othi “Umbhalo” sifaka ulwazi lombhalo oluzoboniswa esikhundleni sesixhumanisi.
4. Emgqeni othi “Igama ledokhumenti entsha” faka igama ledokhumenti entsha yesipredishithi.
5. Emgqeni othi "Indlela", cacisa indawo yokugcina idokhumenti entsha.
6. Emgqeni othi “Isikhathi sokwenza ukuhlela kudokhumenti entsha”, khetha inketho ekulungele kakhulu wena.
7. Ngemuva kokwenza konke ukukhohlisa, chofoza "OK".

Ungayakha kanjani iHyperlink ku-Excel Ukwakha I-imeyili

Ukuhamba ngezinyawo:

1. Sivula iwindi ukuze sakhe isixhumanisi.
2. Emgqeni othi "Xhuma", khetha into ethi "I-imeyili".
3. Emugqeni othi “Umbhalo” sifaka ulwazi lombhalo oluzoboniswa esikhundleni sesixhumanisi.
4. Emgqeni othi “Ikheli le-imeyili. mail” cacisa ikheli le-imeyili lomamukeli.
5. Faka igama le-imeyili emugqeni wesihloko
6. Ngemuva kokwenza konke ukukhohlisa, chofoza "OK".

Ungahlela kanjani isixhumanisi ku-Excel

Ngokuvamile kwenzeka ukuthi isixhumanisi esidaliwe sidinga ukuhlelwa. Kulula kakhulu ukwenza lokhu. Ukuhamba:

1. Sithola iseli elinesixhumanisi esilungile.
2. Sichofoza kuyo i-RMB. Imenyu yokuqukethwe iyavula, lapho sikhetha khona into ethi "Shintsha isixhumanisi ...".
3. Efasiteleni elivelayo, senza zonke izinguquko ezidingekayo.

Ungafometha kanjani isixhumanisi ku-Excel

Ngokuzenzakalelayo, zonke izixhumanisi kusipredishithi ziboniswa njengombhalo oluhlaza okwesibhakabhaka odwetshelwe. Ifomethi ingashintshwa. Ukuhamba:

1. Sithuthela "Ekhaya" bese ukhetha into ethi "Izitayela Zeseli".

2. Chofoza umbhalo othi “Hyperlink” RMB bese uchofoza into ethi “Hlela”.
3. Ewindini elivelayo, chofoza inkinobho ethi "Fometha".

4. Ungashintsha ukufometha ezigabeni zefonti kanye ne-Shading.

Ungasusa kanjani isixhumanisi ku-Excel

Umhlahlandlela wesinyathelo ngesinyathelo ukususa isixhumanisi:

1. Chofoza kwesokudla kuseli lapho itholakala khona.
2. Kumenyu yokuqukethwe evulayo, khetha into ethi "Susa isixhumanisi". Ilungile!

Ukusebenzisa izinhlamvu ezingajwayelekile

Kunezimo lapho u-opharetha we-HYPERLINK angahlanganiswa nomsebenzi wokukhipha izinhlamvu ezingajwayelekile we-SYMBOL. Inqubo isebenzisa ukushintshwa kombhalo ongenalutho wesixhumanisi ngohlamvu oluthile olungajwayelekile.

Isiphetho

Sithole ukuthi kuspredishithi se-Excel kunenombolo enkulu yezindlela ezikuvumela ukuthi udale isixhumanisi. Ukwengeza, sifunde ukuthi singakha kanjani isixhumanisi esiholela ezintweni ezihlukene. Kufanele kuqashelwe ukuthi kuye ngohlobo olukhethiwe lwesixhumanisi, inqubo yokusebenzisa isixhumanisi esidingekayo iyashintsha.