Maitiro ekuita chinongedzo kuti chibudirire. Kugadzira zvinongedzo kuti ubudirire kune rimwe pepa, pane rimwe bhuku, hyperlink

Kugadzira mareferenzi maitiro ayo iyo munhu wese mushandisi weiyo special tafura processor yatarisana naro. Zvinongedzo zvinoshandiswa kuita kuti zviitwe zviyero kune yakatarwa mapeji eWebhu, pamwe nekuwanikwa mune chero zvinyorwa zvekunze kana zvinyorwa. Munyaya yacho, isu tichakurukura zvakadzama maitiro ekugadzira zvinongedzo uye nekuziva kuti ndedzipi dzingadziviswa dzingaitwa navo.

Varietsies yeLinks

Kune marudzi maviri makuru ezvivande:

1. Mareferensi anoshandiswa mune akasiyana komputa mafomula, pamwe nezvinhu zvakakosha.
2. Mareferensi anoshandiswa kudzosera kune zvakananga zvinhu. Ivo vanonzi hyperlink.

Zvese zvinongedzo (zvinongedzo) zvinowedzera zvakakamurwa mumhando mbiri.

• Kunze mhando. Yaishandiswa kutungamira kune chinhu chiri mune rimwe gwaro. Semuenzaniso, pane chimwe chiratidzo kana peji online.
• Yemukati mhando. Yaishandiswa kutungamira kune chinhu chiri mubhuku rimwe chetero. Izvo zvakanyatso shandiswa muchimiro chehunhu hweanoshanda kana zvinhu zvebetsero zve formula. Nyorera kutsanangura zvakananga zvinhu mukati megwaro. Izvi zvinongedzo zvinogona kutungamira zvinhu zvese zvebepa rimwe chete uye kune izvo zvinhu zvemaheets anosara egwaro rimwe chete.

Pane zvakawanda zvakasiyana zvekugadzira zvinongedzo. Maitiro acho anofanira kusarudzwa, achifunga kuti ndeipi mhando yezvinongedzo zvinodiwa mupepa rekushanda. Isu tichaongorora imwe neimwe nzira mune zvimwe zvakadzama.

Maitiro ekugadzira zvinongedzo pane rimwe pepa

Iyo iri nyore chinongedzo ndeyekutsanangurira iyo cell kero mune inotevera fomu: = B2.

Poshi

Chiratidzo "=" ndicho chikamu chikuru chechibatanidza. Mushure mekunyora chiratidzo ichi mumutsara wekupinda formula, iyo tabular processor ichatanga kuona kukosha uku sechinhu chinongedzo. Izvo zvakakosha kwazvo kupinda nenzira chaiyo yekuisa kero yesero kuitira kuti chirongwa chacho chichigadzira ruzivo rwekugadzirisa ruzivo. Muchiitiko chinofungidzirwa, kukosha "= b2" kunoreva kuti muD3 munda matina kupinda muchinongedzo chichaumbirwa kubva kuB2 Cell.

2.

3.

Zvese izvi zvinobvumira zvakasiyana siyana zveArithmetic mashandiro mune tabular processor. Semuenzaniso, isu tinonyora iyo inotevera formula mune D3 munda: = A5 + B2. Mushure mekupinda iyi formula, tinya "Enter". Nekuda kweizvozvo, tinowana mhedzisiro yekuwedzera kwemasero B2 uye A5.

ina

shanu

Kumwe mashandiro arithmetic kunogona kugadzirwa nenzira yakafanana. Mune iyo tabular processor kune 2 Main link maitiro:

1. Maonero akajairika - A1.
2. R1c Chimiro Chekutanga Chiratidzo chinoratidza huwandu hwemutsara, uye 2nd - nhamba yekamuri.

Nhanho-ne-nhanho kuronga maitiro maitiro anotaridzika seizvi:

1. Enda kune "faira" chikamu.

6.

1. Sarudza iyo "parameter" chinhu, iri mune yakadzika kuruboshwe chikamu chewindo.

7.

1. Iyo skrini inoratidza hwindo neparamende. Isu tinofamba kuenda kunzvimbo inotevera inonzi "mafomu". Isu tinowana "kushanda neFormasi" uye tichaisa chiratidzo pedyo ne "link style r1c1" chinhu. Mushure mekuita zvese manipupolations, tinya pane "Zvakanaka".

sere

Kune marudzi maviri ezvibatanidza:

• Kutaura kwakazara kwenzvimbo yeimwe chinhu, zvisinei nechinhu icho chine zvakatsanangurwa zvemukati.
• Hama dzinoreva nzvimbo yenzvimbo yezvinhu zvinoenderana nesero rekupedzisira nekunyorwa kutaura.

Nokusvibiswa, zvese zvinowedzerwa zvinongedzo zvinoonekwa sehama. Funga nezve muenzaniso wekunyengera zvine hukama. Nhanho-BY-STEPT NGUVA:

1. Isu tinosarudza iyo cell uye isa chinongedzo kune imwe sero mukati maro. Semuenzaniso, nyora: = B1.

pfumbamwe

1. Mushure mekupinda Chirevo, tinya "Enter" kuti ubudise mhedzisiro yekupedzisira.

10

1. Fambisa iyo kiroti kusvika pakona yakadzika yekona yechitokisi. Iyo pointer inotora chimiro cherima diki uye. Dzvanya iyo LKM uye tambanudza chirevo pasi.

gumi neimwe

1. Iyo formula yakateedzerwa kumasero epazasi.

12

1. Isu tinoona kuti mumasero ezasi, iyo yakapinda chinongedzo chachinja kune imwe nzvimbo nekudzingwa nhanho imwe. Izvi zvinoitika zvakakonzerwa nekushandiswa kwerevo yehama.

13

Iye zvino funga muenzaniso wekunyengera uine mhedziso zvibatanidzwa. Nhanho-BY-STEPT NGUVA:

1. Kushandisa dhora chiratidzo "$" Isu tinogadzira iyo kero yekero yekugadziriswa pamberi pezita rekisimusi uye nhamba yemutsara.

gumi neina

1. Isu tinotambanudza, pamwe nemuenzaniso uri pamusoro, fomula pasi. Isu tinoona kuti masero ari pazasi anoramba ari iwo mairatidzira sezvakaita muchitokisi chekutanga. Iyo yekubatanidza mhedziso yakanyora iyo sero tsika, uye zvino havachinje kana iyo formula ikashandurwa.

gumi neshanu

Zvese zvimwe, mune iyo tabular processor, iwe unogona kuita chinongedzo kune huwandu hwemasero. Kutanga, kero yesero rekuruboshwe rakanyorwa, uyezve rakadzika kwazvo. Pakati pevarongi ndiro colon ":". Semuenzaniso, pikicha iri pazasi, iyo A1 renji inoratidzwa: C6. Kunongedzera kune ino mhando ndeye: = A1: C6.

gumi nenhanhatu

Kugadzira chinongedzo kune rimwe sheet

Iye zvino imbofunga kuti ungagadzira sei kutaurwa kwemamwe mashiti. Pano, mukuwedzera kune iyo kuronga kwechitokisi, kero yeiyo chaiyo yekushanda pepa inowedzera kuratidzwa. Mune mamwe mazwi, mushure mekunge chiratidzo "=" Semuenzaniso, chinongedzo paC5 ce cell, iri pane pepa rebasa inonzi "Rondedzero2", iri seinotevera: = rondedzero2! C5.

17.

Nhanho-BY-STEPT NGUVA:

1. Isu tinofamba kuenda kuchitokisi chinodiwa, isa hunhu "=". Vhara-kumusoro Lkm pazita repepa, iro riri pazasi pepafura processor interface.

gumi nesere

1. Takatamira kune yechipiri pepa regwaro racho. Nekudzvanya lcm, isu tinosarudza iyo sero ratinoshuvira kuitisa mu formula.

gumi nepfumbamwe

1. Mushure mekuita zvese zvakanyanyisa, tinya ku "Enter". Isu takazviwana vari pane yekutanga basa pepa, umo iyo yekupedzisira nhamba yatobviswa kare.

makumi maviri

Kunze kwekunongedzera kune rimwe bhuku

Funga maitiro ekuita zvekunze chinongedzo kune rimwe bhuku. Semuenzaniso, isu tinofanirwa kuita chisikwa chechibatanidza kune iyo B5 cell, iri pane yebasa rebhuku rakavhurika "links.xlsx".

21.

Nhanho-BY-STEPT NGUVA:

1. Isu tinosarudza sero ratinoshuvira kuwedzera formula. Isu tinopinda mune hunhu "=".

22.

1. Kufamba mubhuku rakavhurika umo sero racho, chinongedzo chatiri kuda kuwedzera. Dzvanya pane iyo shizha rinodiwa, uye ipapo muchitokisi chaunoda.

23.

1. Mushure mekuita zvese zvakanyanyisa, tinya ku "Enter". Isu takazviwana tiri pane yekutanga basa rebasa umo mhedzisiro yekupedzisira yatotangwa.

24.

Chinongedzo kune faira pane server

Kana gwaro racho iri, semuenzaniso, mune general folda yekambani server, ipapo inogona kutaurwa nezvake seinotevera:25.

Chinongedzo kune inonzi range

Iyo tabular processor inobvumidza iwe kuti ugadzire chinongedzo kune inonzi range yakaiswa kuburikidza ne "zita maneja". Kuti uite izvi, ingoisa zita renzvimbo mune chinongedzo pachayo:

26.

Kuti utaure zvinongedzo kune rakatumidzwa renji mugwaro rekunze, iwe unofanirwa kujekesa zita rayo, uye unotsanangudza nzira iyi:

27.

Batanidza kune Smart tafura kana zvinhu zvayo

Uchishandisa iyo inoshandisa yehupenzi, unogona kushandisa chinongedzo kune chero chidimbu che "smart" tafura kana pane yakazara ndiro yakazara. Zvinotaridzika seizvi:

28.

Uchishandisa mushandi weDVSSL

Kuti uite mabasa akasiyana siyana, iwe unogona kushandisa yakakosha basa reDVSSL. Kuonekwa kwakawanda kweanoshanda: = dvssl (link_namechair; A1). Isu tichaongorora mushandiresi mune zvakadzama pane mumwe muenzaniso. Nhanho-BY-STEPT NGUVA:

1. Isu tinoburitsa kusarudzwa kwechitokisi chakakodzera, uye ndobva tinya pane "isa basa" chinhu, chiri padyo nemutsetse wekupinda mafomula.

29.

1. Iyo hwindo inoratidza hwindo rainzi "basa isa". Sarudza chikamu "chinongedzo uye arrays".

makumi matatu

1. Dzvanya pane chinhu cheiyo dash. Mushure mekuita zvese manipupolations, tinya pane "Zvakanaka".

31.

1. Iyo inoratidzira inoratidza hwindo kuti upinde operator nharo. Mumutsara "link_name" Ini ndinosuma iyo kuronga kwesero pane yatinoda kutaura nezvayo. Line "A1" Siya isina chinhu. Mushure mezvose manipulations, tinya pane "OK" bhatani.

32.

1. Kugadzirira! Mhedzisiro inoratidza mhedzisiro yedu.

33.

Chii chinonzi hyperlink

Kugadzira hyperlink

Hyperlinks anotendera kwete chete kuti "bvisa" ruzivo kubva kumasero, asi zvakare kushandura kune chinorehwa chinhu. Nhanho nedanho redanho rekugadzira hyperlink:

1. Pakutanga, zvinodikanwa kuti upinde muhwindo rakakosha iro rinokutendera kuti ugadzire hyperlink. Pane zvakawanda zvingasarudzwa zvekushandisa ichi chiito. Yekutanga - tinya iyo pkm pane iyo yakakosha cell uye mune iyo mamiriro menyu sarudza iyo Element "link ...". Yechipiri - sarudza sero raunoda, fambisa kune "kuisa" chikamu uye sarudza iyo "link" chinhu " Yetatu - shandisa kiyi musanganiswa "Ctrl + k".

34.

35.

1. Iyo skrini inoratidza hwindo rinoita kuti iwe ugadzirise hyperlink. Pane sarudzo yezvinhu zvinoverengeka. Ngatimbokurukurai sarudzo imwe neimwe zvakadzama.

Maitiro ekugadzira hyperlink muExcel kune rimwe gwaro

Nhanho-BY-STEPT NGUVA:

1. Isu tinoburitsa hwindo rekuvhura kugadzira hyperlink.
2. Mu "Tie" mutsara, sarudza iyo "faira, webhu peji" chinhu.
3. Mu "Kutsvaga B" mutsara, tinosarudza folda iyo iyo faira iri iyo yatiri kuronga kuita chinongedzo.
4. Mu "zvinyorwa" zvemavara, isu tinopinda zvinyorwa zvemavara, izvo zvicharatidzwa pachinzvimbo.
5. Mushure mekunyengedza kwese, tinya pane "Zvakanaka".

36 Maitiro Ekugadzira Hyperlink muExcel pane peji rewebhu

Nhanho-BY-STEPT NGUVA:

1. Isu tinoburitsa hwindo rekuvhura kugadzira hyperlink.
2. Mu "Tie" mutsetse, sarudza iyo "faira, peji rewebhu" chinhu.
3. Dzvanya pane iyo "Internet" bhatani.
4. Mu "Kero" mutsara, tyaira kero yepepa repamhepo.
5. Mu "zvinyorwa" zvemavara, isu tinopinda zvinyorwa zvemavara, izvo zvicharatidzwa pachinzvimbo.
6. Mushure mekunyengedza kwese, tinya pane "Zvakanaka".

37 Maitiro ekugadzira hyperlink muExcel kune imwe nzvimbo yegwaro razvino mugwaro razvino

Nhanho-BY-STEPT NGUVA:

1. Isu tinoburitsa hwindo rekuvhura kugadzira hyperlink.
2. Mu "Tie" mutsara, sarudza iyo "faira, webhu peji" chinhu.
3. Dzvanya pane iyo "tab ..." uye sarudza iyo yebasa pepa kugadzira chinongedzo.
4. Mushure mekunyengedza kwese, tinya pane "Zvakanaka".

38 Maitiro ekugadzira hyperlink muExcel kuBhuku Rekutanga Bhuku

Nhanho-BY-STEPT NGUVA:

1. Isu tinoburitsa hwindo rekuvhura kugadzira hyperlink.
2. Mu "Tie" mutsara, sarudza "gwaro ritsva" chinhu.
3. Mu "zvinyorwa" zvemavara, isu tinopinda zvinyorwa zvemavara, izvo zvicharatidzwa pachinzvimbo.
4. Mu "Itsva yeRugwaro zita" tambo, pinda zita regwaro idzva reTabular.
5. Mu "Path" mutsara, ratidza nzvimbo yacho kuti uchengetedze gwaro idzva.
6. Mutsetse "nguva yekugadzirisa kune gwaro idzva", sarudza iyo yakanyanya nyore paramende iwe pachako.
7. Mushure mekunyengedza kwese, tinya pane "Zvakanaka".

39 Maitiro ekugadzira hyperlink mu Excel kuti ugadzire email

Nhanho-BY-STEPT NGUVA:

1. Isu tinoburitsa hwindo rekuvhura kugadzira hyperlink.
2. Mu "Tie" mutsetse, sarudza iyo email chinhu.
3. Mu "zvinyorwa" zvemavara, isu tinopinda zvinyorwa zvemavara, izvo zvicharatidzwa pachinzvimbo.
4. Mumutsara "El. Email "ratidza iyo email yeanogamuchira.
5. Mu "chinyorwa" mutsara, pinda zita retsamba
6. Mushure mekunyengedza kwese, tinya pane "Zvakanaka".

40.

Maitiro Ekugadzirisa Hyperlink muExcel

Zvinowanzoitika kuti iyo yakasikwa hyperlink inofanira kugadziriswa. Ita kuti zvive nyore kwazvo. Nhanho-BY-STEPT NGUVA:

1. Isu tinowana sero rine hyperlink.
2. Dzvanya pairi pkm. Mamenyu emamenyu akaziviswa, umo iwe unosarudza chinhu "chinja hyperlink ...".
3. Muwindo rinoonekwa, isu tinogadzira zvese zvinodikanwa gadziriso.

41.

Maitiro Ekugadzira Hyperlink muExcel

Zvakaringana, mareferenzi ese ari muTafura processor anoratidzwa seyakagadziriswa zvinyorwa zvemumvuri webhuruu. Chimiro chinogona kuchinjwa. Nhanho-BY-STEPT NGUVA:

1. Isu tinoenda ku "imba" uye sarudza chinhu che "cell sterles".

42.

1. Dzvanya pane zvakanyorwa "hyperlink" nePkm uye tinya pane "shanduko" chinhu.
2. Muwindo rinoratidzwa, tinya bhatani re "Fomati".

43.

1. Mu "font" uye "zadza" zvikamu, unogona kuchinja chimiro.

44.

Maitiro ekubvisa iyo hyperlink muExcel

Nhanho-ne-nhanho gwara kuti ubvise hyperlinks:

1. Dzvanya PCM pachiteshi, painowanikwa.
2. Mumamiriro ezvinhu anoregedzwa, sarudza iyo "Delete hyperlink" chinhu. Kugadzirira!

45.

Uchishandisa zvisiri-zvakajairika zviratidzo

Kune zviitiko apo iyo opareta hyperlink inogona kusanganiswa neyekuburitsa basa reisiri-standard mavara chiratidzo chiratidzo. Maitiro acho anoshandisa kutsiva kweiyo yakajairwa zvinyorwa zvekubatanidza kune chero isina-standard chiratidzo.46.

Mhedziso

Takaona kuti muTafura processor Excel kune huwandu hukuru hwenzira dzinobvumidza iwe kuti ugadzire chinongedzo. Pamusoro pezvo, isu takaziviswa nemaitiro ekugadzira hyperlink inotungamira kune dzakasiyana siyana. Izvo zvakakosha kucherechedza kuti zvichienderana nemaonero akasarudzwa erevo, maitiro ekuita kwekushandiswa kweiyo inodiwa yekubatanidza shanduko.

Mharidzo Maitiro Ekuita Chinongedzo Kubuditsa. Kugadzira zvinongedzo zvekubuditsa kune imwe shizha, pane rimwe bhuku, hyperlink raioneka kutanga kune tekinoroji yeruzivo.