Maitiro ekubatanidza mufananidzo kune sero mune excel spreadsheet

Paunenge uchigadzira matafura muExcel, zvinowanzodikanwa kuisa mufananidzo mune imwe sero. Pane nzira dzakati wandei dzekuita basa riripo. Iwo makuru achakurukurwa munyaya ino.

Zvimiro zvekubatanidza mifananidzo

Usati watumira mafoto muExcel, zvakakosha kuti udzidze akati wandei maitiro eiyo maitiro:

1. Mufananidzo urikuda kuisa mushandisi unofanirwa kunge uri pahard drive kana midhiya inobvisika yakabatana nePC.
2. Mufananidzo wakaiswa muExcel hauzongobatanidzwa pakarepo pane imwe sero, asi uchange uri papepa rebasa.
3. Mamwe mafoto anogona kurasikirwa nemhando mushure mekuiswa mundiro.

Maitiro ekuisa mufananidzo muExcel

Chokutanga pane zvose, unofanira kuisa mufananidzo wakasarudzwa mumunda wekushanda wepurogiramu, wozoisunga kune chimwe chinhu chetafura. Pakutanga, unofanira kuita zvinotevera:

1. Sarudza mufananidzo uye uise chero paPC yako.
2. Vhura Microsoft Office Excel.
3. Dzvanya LMB pane chinhu chaunoda kuisa mufananidzo.
4. Enda kuchikamu che "Insert" uye tinya pashoko rekuti "Mufananidzo".

5. Rondedzera nzira inoenda kunzvimbo yemufananidzo pakombuta nekusarudza yakakodzera disk partition pahwindo rinovhura, uye wobva wadzvanya bhatani rekuti "Isa".

6. Ita shuwa kuti chifananidzo chakaiswa uye chinotora imwe nzvimbo yechirongwa chebasa.

Teerera! Panguva ino, mufananidzo hausati wabatanidzwa kune chimwe chinhu chetafura yetafura.

Maitiro ekugadzirisa dhizaini

Iye zvino iwe unofanirwa kugadzirisa iyo foto yakaiswa muExcel, uuye nayo kune "yakafanira" fomu. Iwe unofanirwa kuita seizvi:

1. Tinya-kurudyi pese pamufananidzo wakamboiswa uye mune yemukati menyu, tinya pane "Size uye zvivakwa" mutsara.
2. Muhwindo rinoonekwa, unogona kushandura maparamendi echifananidzo, kudyara, kushandisa maitiro akasiyana-siyana, etc. Pano mushandisi anoita zviito pakuda kwake.

3. Vhara hwindo "Size uye zvivakwa" uye tinya pane chinyorwa "Shanda nemifananidzo" mubharu repamusoro rechirongwa.
4. Iye zvino zvakakosha kuderedza mifananidzo yemifananidzo kuitira kuti ienderane musero rakasarudzwa retafura yetafura. Nechinangwa ichi, miganhu yemufananidzo inogona kuchinjwa neLMB.

Maitiro ekubatanidza mufananidzo kune cell

Mushure mekugadzirisa saizi, chifananidzo hachisati chabatanidzwa kune tafura array element. Kugadzirisa mufananidzo, iwe uchafanirwa kuita akati wandei mamwe manipulations. Tevere, isu tichatarisa nzira dzakajairika dzekubatanidza foto kune sero muMicrosoft Office Excel.

Zvinokosha! Nzira imwe neimwe yakakosha kune chero shanduro yepurogiramu.

Sheet Protection

Pepa rekushanda muExcel rinogona kuchengetedzwa kubva kune shanduko, uye ipapo chifananidzo chichagadziriswa mune imwe nzvimbo. Iyo nzira ndeyekutevera matanho ari nyore:

1. Fambisa iyo yakagadziridzwa foto kune iyo tafura element neLMB.

2. Tinya-kurudyi pamufananidzo uye tinya pamutsara "Size uye zvivakwa".
3. Mu "Size" menyu, tarisa marongero. Maitiro avo haafanire kudarika saizi yesero. Iwe unofanirwawo kutarisa mabhokisi ari pedyo nemitsetse "Chengetedza zviyero" uye "Zvinoenderana nehukuru hwepakutanga".

4. Pinda iyo "Properties" tab. Pano iwe unofanirwa kuisa switch yekuchinja padivi pemutsara "Fambisa uye shandura chinhu pamwe nemaseru." Kupesana ne "Chinhu Chakachengetedzwa" uye "Printa chinhu" paramita, unofanirawo kutarisa mabhokisi.

5. Vhara hwindo, sarudza nzvimbo yese yekushandira uchishandisa Ctrl + A musanganiswa wemabhatani uye enda kuchikamu cheFormat Cells nekudzvanya chero paRMB sheet.

6. Muhwindo idzva muchikamu che "Protection", uncheck bhokisi "Protected cell", wozosarudza sero rine mufananidzo wakaiswa uye tarisa bhokisi iri zvakare.

Mamwe Mashoko! Mushure mekuita manipulations akadaro, chifananidzo chichagadziriswa mune chimwe chinhu chetafura yetafura uye kuchengetedzwa kubva kune chero shanduko.

Kuisa mufananidzo mune chinyorwa

Mufananidzo wakaiswa muExcel noti unozongonamirwa kuchitokisi. Iyo nzira inoshandiswa sezvinotevera:

1. Tinya-kurudyi pane chaunoda uye unongedza kune iyo "Isert Note" sarudzo mumenyu.
2. Muhwindo rekurekodha, tinya-kurudyi zvakare uye nongedzera kumutsara wekuti "Note Format".

3. Muhwindo rinoonekwa, enda kuchikamu che "Mavara neMitsetse", wobva wawedzera "Ruvara" tebhu uye tinya bhatani re "Zadza Nzira".

4. Rimwe hwindo rinovhurika raunofanirwa kudzvanya pane yekupedzisira tebhu mune rondedzero yezvishandiso kumusoro uye tinya pane izwi rekuti "Drawing".

5. Taura nzira inoenda kunzvimbo yemufananidzo paPC uye tinya pashoko rekuti "Isa".

6. Iye zvino mufananidzo wacho uchawedzerwa ku "Zadza Nzira" hwindo. Mushandisi achafanirwa kutarisa bhokisi riri padivi pechinhu "Chengetedza zviyero zvemufananidzo" uye tinya "OK".

7. Dzokera ku "Note format" hwindo uye mu "Kudzivirira" chikamu, uncheck mutsara we "Chinhu chichaonekwa".

8. Muhwindo rimwe chete, enda kune "Properties" tab uye isa shanduko mu "Fambisa uye shandura chinhu pamwe chete nemasero", wobva wadzvanya "OK".

Teerera! Iyo yakatariswa nzira inosunga chifananidzo kune imwe sero, asi inoisa huwandu hwezvirambidzo pane chinhu chetafura array.

mhedziso

Saka, iwe unogona kukurumidza kugadzirisa mifananidzo muExcel maseru uchishandisa zvishandiso zvakavakwa muchirongwa. Nzira dzekubatanidza dzakakurukurwa pamusoro dzichabatsira kudzivirira matambudziko pakuita basa.