Maitiro ekugadzira chinongedzo muExcel. Kugadzira zvinongedzo muExcel kune rimwe pepa, kune rimwe bhuku, hyperlink

Kugadzira zvinongedzo inzira inotarisana nayo yese Excel spreadsheet mushandisi. Manongedzo anoshandiswa kuita redirect kune chaiwo mapeji ewebhu, pamwe nekuwana chero ekunze masosi kana zvinyorwa. Muchinyorwa ichi, isu tichanyatso tarisisa maitiro ekugadzira zvinongedzo uye kuona kuti manipulations anogona kuitwa navo.

Mhando dzakasiyana-siyana

Pane 2 mhando huru dzemalink:

1. Mareferensi anoshandiswa mumhando dzakasiyana dzekuverenga, pamwe neakakosha mabasa.
2. Manongedzo anoshandiswa kutungamira kune chaiwo zvinhu. Anonzi hyperlink.

Zvese zvinongedzo (zvinongedzo) zvinopatsanurwa kuita 2 mhando.

• mhando yekunze. Inoshandiswa kutungamira kune chimwe chinhu chiri mune rimwe gwaro. Semuenzaniso, pane chimwe chiratidzo kana peji rewebhu.
• Rudzi rwemukati. Inoshandiswa kutungamira kune chimwe chinhu chiri mubhuku rimwechete rebasa. Nekutadza, ivo vanoshandiswa muchimiro cheiyo opareta kukosha kana ebetsero zvinhu zvefomati. Inoshandiswa kutsanangura zvinhu zvakananga mukati megwaro. Izvi zvinongedzo zvinogona kutungamira zvese kune zvinhu zvepepa rimwechete uye kune zvinhu zvemamwe mapepa ebasa egwaro rimwe chete.

Kune zvakawanda zvakasiyana-siyana zvekubatanidza kuvaka. Iyo nzira inofanirwa kusarudzwa, ichifunga nezvemhando yereferensi inodiwa mugwaro rekushanda. Ngationgororei nzira imwe neimwe zvakadzama.

Maitiro ekugadzira zvinongedzo pane imwechete sheet

Iyo yakapfava link ndeyekudoma kero dzeserura mune inotevera fomu: =B2.

Chiratidzo che "=" ndicho chikamu chikuru chekubatanidza. Mushure mekunyora uyu hunhu mumutsara wekupinda mafomula, spreadsheet ichatanga kuona kukosha uku sereferensi. Izvo zvakakosha kuisa nemazvo kero yesero kuitira kuti chirongwa chigadzirise ruzivo. Mumuenzaniso wakatariswa, kukosha "= B2" kunoreva kuti kukosha kubva muchitokisi B3 kuchatumirwa kumunda D2, umo takapinda mubatanidzwa.

Zvakakosha kucherechedza! Kana tikagadzirisa kukosha muB2, zvino ichachinja pakarepo muchitokisi D3.

Zvese izvi zvinokutendera kuti uite akasiyana e arithmetic mashandiro muspredishiti processor. Semuenzaniso, ngatinyorei inotevera fomula mumunda D3: =A5+B2. Mushure mekupinda iyi fomula, tinya "Enter". Nekuda kweizvozvo, tinowana mhedzisiro yekuwedzera masero B2 uye A5.

Mamwe maoparesheni e arithmetic anogona kuitwa nenzira yakafanana. Pane maviri makuru ekubatanidza masitaera muspredishiti:

1. Maonero akajairwa - A1.
2. Format R1C Chiratidzo chekutanga chinoratidza nhamba yemutsara, uye yechipiri inoratidza nhamba yekoramu.

Nzira yekushandura nzira yekubatanidza ndeyotevera:

1. Isu tinotamira kune "Faira" chikamu.

2. Sarudza "Sarudzo" chinhu chiri muzasi kuruboshwe chikamu chehwindo.

3. Hwindo rine zvingasarudzwa rinoonekwa pachiratidziri. Tinoenda kune chikamu chinonzi "Formulas". Isu tinowana "Kushanda nemafomula" uye isa chiratidzo padivi pechinhu "Reference style R1C1". Mushure mekuita zvese manipulations, tinya pakanzi "OK".

Kune marudzi maviri ezvekubatanidza:

• Absolute reva nzvimbo yechinhu chakati, zvisinei nechinhu chine chakapihwa.
• Relative inoreva nzvimbo yezvikamu zvine chekuita nesero rekupedzisira rine chirevo chakanyorwa.

Teerera! Mune mareferensi akakwana, chiratidzo chedhora "$" chinopihwa pamberi pezita rekoramu uye nhamba yemutsara. Somuenzaniso, $B $3.

Nekumisikidza, zvese zvakawedzerwa zvinongedzo zvinoonekwa sehukama. Chimbofunga muenzaniso wekugadzirisa hukama hwehukama. Walkthrough:

1. Isu tinosarudza sero uye tinoisa chinongedzo kune imwe sero mairi. Somuenzaniso, ngatinyore: =V1.

2. Mushure mekuisa chirevo, tinya "Enter" kuratidza yekupedzisira mhedzisiro.

3. Fambisa cursor kukona yekurudyi kwesero. Iyo pointer inotora chimiro chediki dema plus chiratidzo. Bata LMB uye dhonza kutaura pasi.

4. Fomula yacho yakakopwa kumaseru epasi.

5. Tinocherechedza kuti mumasero ezasi iyo yakapinda link yakashanduka nechinzvimbo chimwe nekuchinja kwedanho rimwe. Mhedzisiro iyi imhaka yekushandiswa kwereferensi yehukama.

Zvino ngatitarisei muenzaniso wekushandisa mareferensi akakwana. Walkthrough:

1. Tichishandisa chiratidzo chedhora "$" tinogadzirisa kero yesero pamberi pezita rekoramu uye nhamba yemutsara.

2. Isu tinotambanudza, semumuenzaniso wepamusoro, fomula pasi. Tinocherechedza kuti masero ari pasi apa ane zviratidzo zvakafanana nezviri musero rekutanga. Mhedziso yereferensi yakagadzirisa maseru kukosha, uye ikozvino haashanduke kana fomula yachinjwa.

Mukuwedzera, mune spreadsheet, unogona kushandisa chinongedzo kune huwandu hwemasero. Chekutanga, kero yekumusoro kuruboshwe yesero inonyorwa, kozoita sero rezasi rekurudyi. Colon ":"" inoiswa pakati pezvirongwa. Semuenzaniso, mumufananidzo uri pazasi, huwandu hweA1: C6 hunosarudzwa. Chirevo chechikamu ichi chinoita senge: =A1:C6.

Gadzira chinongedzo kune rimwe pepa

Zvino ngatitarisei maitiro ekugadzira zvinongedzo kune mamwe mapepa. Pano, kuwedzera kune kurongeka kwesero, kero yerimwe pepa rebasa inowedzerwa. Mune mamwe mazwi, mushure mechiratidzo che "="", zita repepa rekushanda rinopinda, ipapo chiratidzo chekudaidzira chinonyorwa, uye kero yechinhu chinodiwa inowedzerwa pamagumo. Semuenzaniso, chinongedzo chesero C5, chiri papepa rebasa rinonzi "Sheet2", rinotaridzika seizvi: = Sheet2! C5.

Kufamba:

1. Enda kune sero yaunoda, isa chiratidzo "=". Dzvanya LMB pazita rebepa, iro riri pazasi peiyo spreadsheet interface.

2. Taenda kupepa rechipiri regwaro. Nekudzvanya bhatani rekuruboshwe rembeva, tinosarudza sero yatinoda kupa kune formula.

3. Mushure mekuita zvese manipulations, tinya "Enter". Takazviwana tiri papepa rekutanga rekushanda, umo chiratidzo chekupedzisira chatove charatidzwa.

Link yekunze kune rimwe bhuku

Funga nzira yekushandisa kunze link kune rimwe bhuku. Semuenzaniso, tinoda kushandisa kugadzirwa kwekubatanidza kune cell B5, iri papepa rekushanda rebhuku rakazaruka "Links.xlsx".

Kufamba:

1. Sarudza sero paunoda kuwedzera fomula. Isa chiratidzo "=".

2. Tinoenda kubhuku rakazaruka umo sero iripo, iyo link yatinoda kuwedzera. Dzvanya pane pepa rinodiwa, uye ipapo pane sero yaunoda.

3. Mushure mekuita zvese manipulations, tinya "Enter". Takaguma papepa rekutanga rekushanda, umo mugumisiro wekupedzisira watove wakaratidzwa.

Batanidza kune faira pane server

Kana gwaro racho riripo, semuenzaniso, mune yakagovaniswa folda yekambani server, saka inogona kutaurwa seizvi:

Kureva dzinza rine zita

Iyo spreadsheet inokutendera iwe kuti ugadzire rengedzo kune yakapihwa renji, inoshandiswa kuburikidza ne "Zita Maneja". Kuti uite izvi, iwe unongoda kuisa zita reiyo renji mune iyo link pachayo:

Kuti utsanangure chinongedzo kune yakapihwa renji mugwaro rekunze, unofanirwa kutsanangura zita rayo, pamwe nekutsanangura nzira:

Batanidza kune smart tafura kana zvinhu zvayo

Uchishandisa HYPERLINK opareta, unogona kubatanidza kune chero chidimbu chetafura "smart" kana tafura yese. Zvinoita seizvi:

Kushandisa INDIRECT opareta

Kuita mabasa akasiyana siyana, unogona kushandisa yakakosha INDIRECT basa. Maonero ese emushandisi: =INDIRECT(Sero_reference,A1). Ngationgororei mushandisi zvakadzama tichishandisa muenzaniso chaiwo. Walkthrough:

1. Isu tinosarudza sero inodiwa, uye tinya pane "Isert Function" chinhu, chiri pedyo nemutsara wekupinda mafomula.

2. Hwindo rakanzi "Insert Function" rairatidzwa pachiratidziri. Sarudza chikamu che "References uye Arrays".

3. Dzvanya pane INDIRECT element. Mushure mekuita zvese manipulations, tinya pakanzi "OK".

4. Chiratidziro chinoratidza hwindo rekupinza nharo dzemushandisi. Mumutsara we "Link_to_cell" isa kurongeka kwesero kwatinoda kureva. Mutsetse "A1" unosiiwa usina chinhu. Mushure mekuita zvese manipulations, tinya bhatani "OK".

5. Ready! Sero rinoratidza mhedzisiro yatinoda.

Chii chinonzi hyperlink

A hyperlink chidimbu chegwaro rinoreva chinhu chiri mugwaro rimwe chete kana kune chimwe chinhu chiri pa hard drive kana pacomputer network. Ngatitarisei zvakanyanya maitiro ekugadzira hyperlink.

Gadzira hyperlink

Hyperlink inobvumira kwete chete "kuburitsa" ruzivo kubva kumaseru, asi zvakare kufamba uchienda kune inotaridzwa chinhu. Nhanho nhanho gwara rekugadzira hyperlink:

1. Pakutanga, iwe unofanirwa kupinda mune yakakosha hwindo iyo inobvumidza iwe kugadzira hyperlink. Pane zvakawanda zvingasarudzwa zvekuita chiito ichi. Kutanga - tinya-kurudyi pane sero rinodiwa uye sarudza chinhu che "Link ..." mumenu yemukati. Chechipiri - sarudza sero yaunoda, enda kune "Insert" chikamu uye sarudza "Link" chinhu. Chechitatu - shandisa kiyi yekubatanidza "CTRL + K".

2. Hwindo rinoonekwa pachiratidziro rinokutendera kuti umise hyperlink. Pane sarudzo yezvinhu zvakati wandei pano. Ngatitarisei zvakanyanya pane imwe neimwe sarudzo.

Maitiro ekugadzira hyperlink muExcel kune rimwe gwaro

Kufamba:

1. Isu tinovhura hwindo kuti tigadzire hyperlink.
2. Mumutsara we "Link", sarudza chinhu che "Faira, peji rewebhu".
3. Mumutsara we "Tsvaga mukati" tinosarudza folda iyo faira iripo, iyo yatinoronga kuita chinongedzo.
4. Mumutsara we "Text" tinoisa ruzivo rwemavara runozoratidzwa panzvimbo yekubatanidza.
5. Mushure mekuita zvese manipulations, tinya pakanzi "OK".

Maitiro ekugadzira hyperlink muExcel kune peji rewebhu

Kufamba:

1. Isu tinovhura hwindo kuti tigadzire hyperlink.
2. Mumutsara we "Link", sarudza chinhu che "Faira, peji rewebhu".
3. Dzvanya bhatani re "Internet".
4. Mumutsara we "Kero" tinotyaira mukero yeInternet peji.
5. Mumutsara we "Text" tinoisa ruzivo rwemavara runozoratidzwa panzvimbo yekubatanidza.
6. Mushure mekuita zvese manipulations, tinya pakanzi "OK".

Maitiro ekugadzira hyperlink muExcel kune imwe nzvimbo mune yazvino gwaro

Kufamba:

1. Isu tinovhura hwindo kuti tigadzire hyperlink.
2. Mumutsara we "Link", sarudza chinhu che "Faira, peji rewebhu".
3. Dzvanya pa "Bookmark ..." uye sarudza pepa rekushanda kuti ugadzire chinongedzo.
4. Mushure mekuita zvese manipulations, tinya pakanzi "OK".

Maitiro ekugadzira hyperlink muExcel kune bhuku idzva rebasa

Kufamba:

1. Isu tinovhura hwindo kuti tigadzire hyperlink.
2. Mumutsara we "Link", sarudza chinhu che "New Document".
3. Mumutsara we "Text" tinoisa ruzivo rwemavara runozoratidzwa panzvimbo yekubatanidza.
4. Mumutsara "Zita regwaro idzva" isa zita regwaro idzva respredishiti.
5. Mumutsara we "Nzira", tsanangura nzvimbo yekuchengetedza gwaro idzva.
6. Mumutsara wekuti "Nguva yekugadzira dhizaini nyowani", sarudza iyo yakakunakira sarudzo iwe pachako.
7. Mushure mekuita zvese manipulations, tinya pakanzi "OK".

Maitiro ekugadzira Hyperlink muExcel Kugadzira Email

Kufamba:

1. Isu tinovhura hwindo kuti tigadzire hyperlink.
2. Mumutsara we "Batanidza", sarudza chinhu che "Email".
3. Mumutsara we "Text" tinoisa ruzivo rwemavara runozoratidzwa panzvimbo yekubatanidza.
4. Mumutsara "Email address. mail” tsanangura kero yeemail yeanogamuchira.
5. Isa zita reemail mumutsara wenyaya
6. Mushure mekuita zvese manipulations, tinya pakanzi "OK".

Maitiro ekugadzirisa hyperlink muExcel

Zvinowanzoitika kuti iyo yakagadzirwa hyperlink inoda kugadziridzwa. Zviri nyore kuita izvi. Walkthrough:

1. Isu tinowana sero ine yakagadzirira hyperlink.
2. Isu tinodzvanya pairi RMB. Menyu yemukati inovhura, umo isu tinosarudza chinhu "Shandura hyperlink ...".
3. Muhwindo rinoonekwa, tinoita zvose zvinodiwa kugadzirisa.

Maitiro ekugadzira hyperlink muExcel

Nekusagadzika, zvese zvinongedzo muspredishiti zvinoratidzwa semavara ebhuruu akaiswa mutsetse. Chimiro chinogona kuchinjwa. Walkthrough:

1. Isu tinotamira ku "Kumba" uye sarudza chinhu "Cell Styles".

2. Dzvanya pane chinyorwa "Hyperlink" RMB uye tinya pane chinhu "Hora".
3. Muhwindo rinoonekwa, tinya bhatani re "Format".

4. Unogona kushandura mafomati muzvikamu zveFont uye Shading.

Maitiro ekubvisa hyperlink muExcel

Nhanho nhanho gwara rekubvisa hyperlink:

1. Tinya-kurudyi pachitokisi pachiri.
2. Mune menyu yemukati inovhura, sarudza iyo "Delete hyperlink" chinhu. Ready!

Kushandisa mavara asina mwero

Pane zviitiko apo mushandisi weHYPERLINK anogona kusanganiswa neSYMBOL isiri-standard yekubuda kwemavara. Maitirwo acho anoshandisa kutsiviwa kwemavara akajeka ezvekubatanidza nemavara asina mwero.

mhedziso

Takaona kuti muExcel spreadsheet kune nhamba huru yenzira dzinokutendera kuti ugadzire chinongedzo. Pamusoro pezvo, takadzidza kugadzira hyperlink inotungamira kune zvakasiyana zvinhu. Izvo zvinofanirwa kucherechedzwa kuti zvichienderana nerudzi rwakasarudzwa rwekubatanidza, maitiro ekushandisa anodiwa anochinja.