Ungasenza kanjani isixhumanisi sokuphumelela. Ukwakha izixhumanisi zokudlula kwelinye ishidi, kwenye incwadi, hyperlink

Ukudala Izikhombo kuyinqubo lapho umsebenzisi wonke weprosesa ekhethekile ebhekene nalo. Izixhumanisi zisetshenziselwa ukwenza ukuqondiswa kabusha kumakhasi athile e-web, kanye nokufinyelela kunoma yimiphi imithombo yangaphandle noma amadokhumenti. Esikhathini esihlokweni, sizocabanga ngokuningiliziwe inqubo yokwakha izixhumanisi futhi uthole ukuthi yimuphi umehluko ongafezwa nawo.

Izinhlobonhlobo zezixhumanisi

Kunezinhlobo ezi-2 eziphambili zezixhumanisi:

1. Izikhombo ezisetshenziswe kumafomula ehlukene wekhompyutha, kanye nezici ezikhethekile.
2. Izinkomba ezisetshenziselwa ukuqondisa kabusha ezintweni ezithile. Babizwa ngokuthi ama-hyperlinks.

Zonke izixhumanisi (izixhumanisi) zihlukaniswe ngezinhlobo ezi-2.

• Uhlobo lwangaphandle. Isetshenziselwe ukuqondisa kabusha entweni etholakala komunye umqulu. Isibonelo, kwesinye isibonakaliso noma ikhasi le-inthanethi.
• Uhlobo lwangaphakathi. Isetshenziselwe ukuqondisa kabusha entweni etholakala encwadini efanayo. Zisetshenziswa ngokujwayelekile ngesimo samanani opharetha noma izinto ezisizayo zefomula. Faka isicelo sokucacisa izinto ezithile ngaphakathi kwedokhumenti. Lezi zixhumanisi zingaholela zombili izinto zeshidi elifanayo nasezakhiweni zamashidi asele asetshenzisiwe edokhumenti elilodwa.

Kunokuhlukahluka okuningi kokwenza izixhumanisi. Indlela kumele ikhethwe, kucatshangelwa ukuthi hlobo luni lwezixhumanisi oludingekayo ephepheni elisebenzayo. Sizohlaziya indlela ngayinye ngemininingwane eminingi.

Ungazakhela kanjani izixhumanisi ekhasini elilodwa

Isixhumanisi esilula kakhulu ukucacisa amakheli eseli ngefomu elilandelayo: = B2.

okukodwa

Uphawu "=" ingxenye eyinhloko yesixhumanisi. Ngemuva kokubhala lolu phawu emgqeni wokufaka ifomula, iprosesa yethebula izoqala ukubona leli nani njengesixhumanisi. Kubaluleke kakhulu ukufaka kahle ikheli leseli ukuze uhlelo lukhiqize kahle ukucubungula imininingwane. Esibonelweni esibukiwe, inani elithi "= B2" lisho lokho kwinkambu ye-D3 lapho singene kulo isixhumanisi sizoqondiswa kwiseli ye-B2.

2.

3.

Konke lokhu kuvumela ukusebenza okuhlukahlukene kwe-arithmetic ku-processor ye-tabular. Isibonelo, sibhala ifomula elilandelayo kwinsimu ye-D3: = A5 + B2. Ngemuva kokufaka le formula, cindezela "ENTER". Ngenxa yalokhu, sithola umphumela wokufakwa kwamaseli B2 ne-A5.

okune

isihlanu

Omunye umsebenzi we-arithmetic angakhiqizwa ngendlela efanayo. Ku-processor ye-tabular kukhona isitayela esingu-2 esiphambili:

1. Ukubuka okujwayelekile - A1.
2. Ifomethi ye-R1C Isikhombi sokuqala sibonisa inombolo yomugqa, kanye ne-2 - inani lekholomu.

Izinguquko zesinyathelo ngesinyathelo ngesitayela zibukeka kanjena:

1. Hambisa esigabeni "sefayela".

6.

1. Khetha into "yepharamitha", etholakala engxenyeni engezansi kwesobunxele yewindi.

7.

1. Isikrini sibonisa iwindi ngamapharamitha. Sithuthela esigatshaneni esibizwa nge- "formula". Sithola "ukusebenza ngamafomula" bese sibeka umaki eduze kwento "yokuxhumanisa isitayela R1c1". Ngemuva kokwenza konke ukusebenzisana, chofoza ku- "Kulungile".

isishiyagalombili

Kunezinhlobo ezi-2 zezixhumanisi:

• Ukubhekiswa ngokuphelele endaweni ethile yento ethile, kungakhathalekile ukuthi into enokuqukethwe okucacisiwe.
• Izihlobo zibhekisela endaweni yezinto ezihlobene neseli lokugcina elinenkulumo erekhodiwe.

Ngokuzenzakalelayo, zonke izixhumanisi ezingeziwe zithathwa njengezihlobo. Cabanga ngesibonelo sokukhohlisa ngezikhombo ezihlobene. Isiqondisi Sokuma kwesinyathelo:

1. Sikhetha iseli bese sifaka isixhumanisi kwesinye iseli kuyo. Isibonelo, bhala: = B1.

isishiyagalolunye

1. Ngemuva kokufaka le nkulumo, chofoza u- "ENTER" ukuze ukhiphe umphumela wokugcina.

Okuthenyalwayo

1. Hambisa isikhombisi ekhoneni elingezansi kwesokudla seseli. Isikhombi sizothatha ukwakheka kwe-brance encane emnyama. Cindezela i-LKM bese welula inkulumo phansi.

ishumi nanye

1. Ifomula ibikopishwe kumaseli aphansi.

Okuqophele imali

1. Siphawula ukuthi emangqamuzaneni aphansi, isixhumanisi esifakiwe sesishintshile saba sesikhundleni esisodwa ngokususa isinyathelo esisodwa. Lo mphumela waba ngenxa yokusetshenziswa kwesethenjwa esihlobene.

13

Manje cabanga ngesibonelo sokukhohlisa ngezixhumanisi eziphelele. Isiqondisi Sokuma kwesinyathelo:

1. Usebenzisa i-Dollar Sign "$" Sikhiqiza ukulungiswa kwekheli leseli ngaphambi kwegama lekholomu nenombolo yomugqa.

ishumi nane

1. Selulula, kanye nesibonelo esingenhla, ifomula phansi. Sibona ukuthi amaseli atholakala ngezansi ahlale izinkomba ezifanayo njengasesitokisini sokuqala. Isixhumanisi esiphelele siqoke amanani weseli, futhi manje abaguquki lapho ifomula iguqulwa.

ishumi nanhlanu

Konke okunye, ku-processor ye-tabular, ungasebenzisa isixhumanisi sohlu lwamaseli. Okokuqala, ikheli leseli eliphezulu kwesobunxele libhaliwe, bese lilungelo eliphansi kakhulu. Phakathi kwezixhumanisi yikholoni ":". Isibonelo, isithombe esingezansi, kuqokonyiswa ibanga le-A1: C6. Ukubhekiswa kulolu banga ukuthi: = A1: C6.

ishumi nesithupha

Ukudala isixhumanisi kwelinye ishidi

Manje cabanga ukuthi ungayakha kanjani ireferensi kwamanye amashidi. Lapha, ngaphezu kokuxhumanisa kweseli, ikheli leshidi elithile lokusebenza likhonjiswe ngaphezu kwalokho. Ngamanye amagama, ngemuva kophawu "=", igama lephepha lokusebenza liyalethwa, bese kubhalwa uphawu lwesikhuseleli, futhi ikheli lento edingekayo lingezwa ekugcineni. Isibonelo, isixhumanisi esiku-C5 cell, esisephethini lomsebenzi elibizwa nge- "Uhlu2", lumi ngokulandelayo: = Uhlu2! C5.

17.

Isiqondisi Sokuma kwesinyathelo:

1. Sithuthela esitokisini esidingekayo, faka umlingiswa "=". Vala-up LKM egameni leshidi, elitholakala ezansi kwesibonisi se-processor yetafula.

ishumi nesishayagalombili

1. Sithuthele ephepheni lesibili ledokhumenti. Ngokucindezela i-LCM, sikhetha iseli esifisa ukuthi libize kwifomula.

ishumi nesishiyagalolunye

1. Ngemuva kokwenza konke ukusebenzisana, chofoza ku- "Enter". Sizithole eshidini lomsebenzi wokuqala, lapho isibalo sokugcina sesisusiwe.

amashumi amabili

Ukubhekiswa kwangaphandle kwenye incwadi

Cabanga ukuthi ungasisebenzisa kanjani isixhumanisi sangaphandle kwenye incwadi. Isibonelo, kudingeka sisebenzise ukwakhiwa kwesixhumanisi esiya e-B5 cell, etholakala ekhasini lokusebenzela lencwadi evulekile "LINKS.XLSX".

21.

Isiqondisi Sokuma kwesinyathelo:

1. Sikhetha iseli lapho sifisa ukungeza khona ifomula. Sifaka umlingiswa "=".

22.

1. Ukuhamba encwadini evulekile lapho iseli litholakala khona, isixhumanisi esifuna ukwengeza. Chofoza iqabunga elidingekayo, bese kuthi kwiseli oyifunayo.

23.

1. Ngemuva kokwenza konke ukusebenzisana, chofoza ku- "Enter". Sizitholele eshidini lomsebenzi lasekuqaleni lapho umphumela wokugcina usuvele wethulwe.

24.

Xhumanisa kufayela kwiseva

Uma idokhumenti itholakala, ngokwesibonelo, kwifolda evamile yeseva yebhizinisi, khona-ke ingabhekiswa kumi ngokulandelayo:25.

Xhumanisa uhla oluhlangene

Iprosesa yeTabular ikuvumela ukuthi udale isixhumanisi sebanga elinegama eliqanjwe ngegama "Manager Igama". Ukuze wenze lokhu, mane ufake igama lobubanzi kwisixhumanisi uqobo:

26.

Ukucacisa ireferensi ebangeni elihlangene kudokhumenti yangaphandle, udinga ukucacisa igama lawo, futhi ucacise indlela:

27.

Xhumanisa etafuleni elihlakaniphile noma izinto zalo

Usebenzisa opharetha we-hyperSlob's, ungasebenzisa isixhumanisi kunoma yisiphi isiqeshana setafula "Smart" noma kulo lonke ipuleti ngokuphelele. Kubukeka kanjena:

28.

Usebenzisa i-Operator DVSSL

Ukusebenzisa imisebenzi ehlukahlukene, ungafaka umsebenzi okhethekile we-DVSSL. Ukubukwa okujwayelekile kopharetha: = DVSSL (Link_Nenamechair; A1). Sizohlaziya opharetha ngemininingwane eminingi ngesibonelo esithile. Isiqondisi Sokuma kwesinyathelo:

1. Siveza ukukhethwa kweseli elidingekayo, bese uqhafaza kwinto ethi "Insert Funct" element, etholakala eduze komugqa wokufaka amafomula.

29.

1. Iwindi libonisa iwindi elibizwa nge- "Function Faka". Khetha izixhumanisi zesigaba "kanye nama-arrays".

amashumi amathathu

1. Chofoza kwinto yedeshi. Ngemuva kokwenza konke ukusebenzisana, chofoza ku- "Kulungile".

31.

1. Isibonisi sibonisa iwindi ukufaka izimpikiswano zomsebenzisi. Emgqeni "isixhumanisi_ame" ngethula ukuxhumanisa kweseli esifuna ukubhekisa kulo. Umugqa "A1" shiya ungenalutho. Ngemuva kwakho konke ukukhohlisa, chofoza inkinobho ethi "Kulungile".

32.

1. Silungele! Umphumela ukhombisa umphumela wethu.

33.

Yini i-hyperlink

Ukwakha i-Hyperlink

Ama-hyperlink awavumela ukuthi hhayi kuphela "ukukhipha" imininingwane kumaseli, kodwa futhi nasekuguqukeni kwento esereferensi. Isinyathelo ngesinyathelo umhlahlandlela wokwakha i-hyperlink:

1. Ekuqaleni, kuyadingeka ukungena ewindini elikhethekile elikuvumela ukuthi udale i-hyperlink. Kunezindlela eziningi zokusebenzisa lesi senzo. Okokuqala - Cindezela i-PKM esitokisini esidingekayo nakumenyu yokuqukethwe Khetha isixhumanisi se-Element "...". Okwesibili - Khetha iseli oyifunayo, hambisa esigabeni se- "Insert" bese ukhetha into ethi "Link". Okwesithathu - Sebenzisa inhlanganisela yokhiye "Ctrl + K".

34.

35.

1. Isikrini sibonisa iwindi elikuvumela ukuthi uguqule i-hyperlink. Kunokukhethwa kwezinto eziningana. Ake sicabangele inketho ngayinye ngemininingwane eminingi.

Ungawakha kanjani i-hyperlink ku-Excel kwenye idokhumenti

Isiqondisi Sokuma kwesinyathelo:

1. Sikhiqiza iwindi lokuvula ukudala i-hyperlink.
2. Emugqeni we- "Tie", khetha i- "Ifayela, ikhasi leWebhu".
3. Emugqeni we- "Search B", sikhetha ifolda lapho ifayela litholakala khona lapho esihlela khona ukwenza isixhumanisi.
4. Kumugqa "wombhalo", sifaka imininingwane yombhalo, ezokhonjiswa esikhundleni sokubhekisisa.
5. Ngemuva kwakho konke ukukhohlisa, chofoza ku- "Kulungile".

Ungawakha kanjani i-hyperlink ku-Excel ekhasini le-Web

Isiqondisi Sokuma kwesinyathelo:

1. Sikhiqiza iwindi lokuvula ukudala i-hyperlink.
2. Emugqeni we- "Tie", khetha i- "Ifayela, ikhasi leWebhu".
3. Chofoza inkinobho ethi "Internet".
4. Kumugqa "wekheli", shayela ikheli le-inthanethi.
5. Kumugqa "wombhalo", sifaka imininingwane yombhalo, ezokhonjiswa esikhundleni sokubhekisisa.
6. Ngemuva kwakho konke ukukhohlisa, chofoza ku- "Kulungile".

Ungawakha kanjani i-hyperlink ku-Excel endaweni ethile kudokhumenti yamanje

Isiqondisi Sokuma kwesinyathelo:

1. Sikhiqiza iwindi lokuvula ukudala i-hyperlink.
2. Emugqeni we- "Tie", khetha i- "Ifayela, ikhasi leWebhu".
3. Chofoza ku- "Tab ..." bese ukhetha ishidi lomsebenzi ukuze wakhe isixhumanisi.
4. Ngemuva kwakho konke ukukhohlisa, chofoza ku- "Kulungile".

38 Ungawakha kanjani i-hyperlink ku-Excel encwadini entsha yokusebenzela

Isiqondisi Sokuma kwesinyathelo:

1. Sikhiqiza iwindi lokuvula ukudala i-hyperlink.
2. Emugqeni we- "Tie", khetha into "entsha yedokhumenti".
3. Kumugqa "wombhalo", sifaka imininingwane yombhalo, ezokhonjiswa esikhundleni sokubhekisisa.
4. Elithi "ntambo yedokhumenti elisha", faka igama ledokhumenti elisha le-tabular.
5. Emugqeni we- "Path", khombisa indawo ukusindisa idokhumenti entsha.
6. Emgqeni "lapho kufanele enze ukuhlela idokhumenti entsha", khetha ipharamitha elula kunazo zonke.
7. Ngemuva kwakho konke ukukhohlisa, chofoza ku- "Kulungile".

39 Ungawakha kanjani i-hyperlink ku-Excel ukudala i-imeyili

Isiqondisi Sokuma kwesinyathelo:

1. Sikhiqiza iwindi lokuvula ukudala i-hyperlink.
2. Emugqeni we- "Tie", khetha into ye-imeyili.
3. Kumugqa "wombhalo", sifaka imininingwane yombhalo, ezokhonjiswa esikhundleni sokubhekisisa.
4. Emgqeni "el. Imeyili "Khombisa i-imeyili yomamukeli.
5. Emugqeni "wesihloko", faka igama lencwadi
6. Ngemuva kwakho konke ukukhohlisa, chofoza ku- "Kulungile".

40.

Ungahlela kanjani i-hyperlink ku-Excel

Kuvame ukwenzeka ukuthi i-hyperlink edaliwe kufanele ihlelwe. Kwenze kube lula kakhulu. Isiqondisi Sokuma kwesinyathelo:

1. Sithola iseli eline-hyperlink eqediwe.
2. Chofoza ku-IT PKM. Imenyu yomongo yembuliwe, lapho ukhetha khona into "shintsha i-hyperlink ...".
3. Ewindini elivelayo, siveza konke ukulungiswa okudingekile.

41.

Ungafomeka Kanjani Hyperlink ku-Excel

Emazingeni, zonke izinkomba ku-processor yetafula zikhonjiswa njengombhalo ogqamile womthunzi ohlaza okwesibhakabhaka. Ifomethi ingashintshwa. Isiqondisi Sokuma kwesinyathelo:

1. Sithuthela "ekhaya" bese sikhetha into "yezitayela zeseli".

42.

1. Chofoza ku-Ocrent "Hyperlink" nge-PKM bese uqhafaza kwi-"Shintsha" element.
2. Ewindini elibonisiwe, cindezela inkinobho ethi "format".

43.

1. Ku- "font" kanye "gcwalisa" izigaba, ungashintsha ukufomatha.

44.

Ungayisusa kanjani i-hyperlink ku-Excel

Umhlahlandlela wesinyathelo ngesinyathelo sokususa ama-hyperlinks:

1. Chofoza i-PCM esitokisini, lapho itholakala khona.
2. Kumenyu yokulahla yomongiwe, khetha into ethi "Delete Hyperlink". Silungele!

45.

Kusetshenziswa izimpawu ezingezona ezijwayelekile

Kunamacala lapho i-hyperlink opharetha ingahlanganiswa nomsebenzi wokukhipha wezinhlamvu ezingezona ezijwayelekile. Inqubo isebenzisa ukufakwa esikhundleni kwesixhumanisi esijwayelekile sombhalo kunoma yiluphi uphawu olungejwayelekile.46.

Ukugcina

Sithole ukuthi ku-processor yetafula i-Excel kunenombolo enkulu yezindlela ezikuvumela ukuthi udale isixhumanisi. Ngaphezu kwalokho, sajwayelana nokuthi ungazakhela kanjani i-hyperlink eholela ezintweni ezahlukahlukene. Kuyaqapheleka ukuthi ngokuya ngombono okhethiwe wesethenjwa, inqubo yokusetshenziswa kwezinguquko ezidingekayo zokuxhumanisa.

Umlayezo wokuthi ungasenza kanjani isixhumanisi sokuphumelela. Ukwakha izinkomba zokudlula kwelinye iqabunga, kwenye incwadi, i-hyperlink yavela kuqala kubuchwepheshe bolwazi.