Nthawi zina simukufuna kuti ma cell ena amasamba anu a Excel asinthe. Mutha kuchita izi pophunzira kutseka kapena kumasula ma cell mu Excel.
Microsoft Excel imatipatsa njira yabwino kwambiri yosungira deta yathu m'mawonekedwe olembedwa komanso okonzedwa. Koma deta iyi ikhoza kusinthidwa ikagawidwa pakati pa anthu ena. Ngati mukufuna kuteteza deta yanu kuti isasinthidwe mwadala, ndiye kuti mutha kuteteza mapepala anu a Excel powatseka. Koma, ichi ndi sitepe yonyanyira yomwe singakhale yabwino. M'malo mwake, mutha kutsekanso ma cell, mizere, ndi mizati. Mwachitsanzo, mutha kulola ogwiritsa ntchito kuti alowetse deta inayake koma atseke ma cell ndi chidziwitso chofunikira. M'nkhaniyi tiona njira zosiyanasiyana Tsekani kapena tsegulani ma cell mu Excel.
Zamkatimu[ kubisa ]
- Momwe Mungatsegule Kapena Kutsegula Maselo mu Excel?
- Momwe mungatsekere ma cell onse mu Excel?
- Momwe Mungatseke ndi Kuteteza Maselo Payekha mu Excel?
- Momwe Mungatsegule ndi Kuteteza Maselo mu Excel Sheet?
- Momwe Mungatsegule Maselo Ena Pamapepala Otetezedwa?
Momwe Mungatsegule Kapena Kutsegula Maselo mu Excel?
Mutha kutseka pepala lonse kapena kungosankha ma cell amodzi malinga ndi zomwe mwasankha.
Momwe mungatsekere ma cell onse mu Excel?
Kuteteza ma cell onse Microsoft Excel , muyenera kungoteteza pepala lonse. Maselo onse omwe ali papepala adzatetezedwa kuti asalembe kapena kusintha mwachisawawa.
1. Sankhani ' Tetezani Mapepala ' kuchokera pansi pa chinsalu mu ' Tsamba la Ntchito ' kapena mwachindunji kuchokera ku ' Ndemanga Tabu ' mu Zosintha gulu .
2. The Tetezani Mapepala ’ bokosi la zokambirana likuwonekera. Mutha kusankha kuteteza pepala lanu la Excel ndi mawu achinsinsi kapena kusiya ' password tetezani pepala lanu la Excel ’ munda wopanda kanthu.
3. Sankhani zochita pamndandanda womwe mukufuna kuloleza patsamba lanu lotetezedwa ndikudina 'Chabwino.'
4. Ngati mwasankha kulowa mawu achinsinsi, a ' Tsimikizani Mawu Achinsinsi ' bokosi la zokambirana lidzawoneka. Lembani mawu achinsinsi anu kachiwiri kuti mumalize ndondomekoyi.
Werenganinso: Momwe Mungachotsere Mawu Achinsinsi pa Fayilo ya Excel
Momwe Mungatseke ndi Kuteteza Maselo Payekha mu Excel?
Mutha kutseka ma cell amodzi kapena ma cell angapo potsatira njira zomwe zili pansipa:
1. Sankhani ma cell kapena magawo omwe mukufuna kuwateteza. Mutha kuchita ndi mbewa kapena kugwiritsa ntchito makiyi osinthira ndi mivi pamawu anu osakira. Gwiritsani ntchito Ctrl kiyi ndi mbewa kusankha maselo osakhala moyandikana ndi ma range .
2. Ngati mukufuna kutseka mzati wonse ndi mizere, mutha kusankha podina gawo lawo kapena chilembo chamzere. Mutha kusankhanso magawo angapo oyandikana nawo podina kumanja pa mbewa kapena kugwiritsa ntchito kiyi yosinthira ndi mbewa.
3. Muthanso kusankha ma cell okha omwe ali ndi ma formula. Patsamba la Kunyumba, dinani Gulu lokonza Kenako ' Pezani ndi Sankhani '. Dinani pa Pitani ku Special .
4. Mu zokambiranabokosi, sankhani a Ma formula njira ndikudina Chabwino .
5. Mukasankha ma cell omwe mukufuna kuti atsekedwe, dinani Ctrl + 1 pamodzi. ‘ Maselo a Format ' bokosi la zokambirana lidzawoneka. Mukhozanso dinani kumanja pamaselo osankhidwa ndikusankha Maselo a Format kuti mutsegule bokosi la zokambirana.
6. Pitani ku ' Chitetezo ' tabu ndipo fufuzani ' zokhoma ' option. Dinani pa Chabwino , ndipo ntchito yanu yatha.
Zindikirani: Ngati mukuyesera kutseka ma cell pa pepala lotetezedwa kale la Excel, muyenera kutsegula pepalalo kaye kenako ndikuchita zomwe zili pamwambapa. Inu imatha kutseka kapena kumasula ma cell mu Excel mumitundu ya 2007, 2010, 2013, ndi 2016.
Momwe Mungatsegule ndi Kuteteza Maselo mu Excel Sheet?
Mutha kutsegula mwachindunji pepala lonse kuti mutsegule ma cell onse mu Excel.
1. Dinani pa ' Mapepala Osatetezedwa ' pa' Ndemanga tabu ' mu zosintha gulu kapena dinani njirayo podina pomwe pa Mapepala tabu.
2. Tsopano mukhoza kupanga kusintha kulikonse kwa deta m'maselo.
3. Mukhozanso kutsegula pepala pogwiritsa ntchito ' Maselo a Format' bokosi la zokambirana.
4. Sankhani maselo onse papepala Ctrl + A . Kenako dinani Ctrl + 1 kapena dinani kumanja ndikusankha Maselo a Format . Mu ' Chitetezo ' tabu la bokosi la zokambirana la Format Cells, sankhani ' Zokhoma ' njira ndikudina Chabwino .
Komanso Werengani: Konzani Excel ikuyembekezera pulogalamu ina kuti imalize OLE
Momwe Mungatsegule Maselo Ena Pamapepala Otetezedwa?
Nthawi zina mungafune kusintha ma cell ena papepala lanu lotetezedwa la Excel. Pogwiritsa ntchito njirayi, mutha kutsegula ma cell papepala lanu pogwiritsa ntchito mawu achinsinsi:
1. Sankhani ma cell kapena magawo omwe mukufuna kuti mutsegule papepala lotetezedwa ndi mawu achinsinsi.
2. Mu ' Ndemanga ' tabu, dinani ' Lolani ogwiritsa ntchito kusintha Masanjidwe ' option. Muyenera kutsegula pepala lanu kaye kuti mupeze mwayi.
3. The 'Lolani owerenga Kusintha Ranges' kukambirana bokosi likuwonekera. Dinani pa ' Zatsopano ' option.
4. A' Mtundu Watsopano ' bokosi la zokambirana likuwoneka ndi Mutu, Amatanthauza ma cell, ndi Mawu achinsinsi munda.
5. M'munda wa Mutu, perekani dzina kumagulu anu . Mu ' Amatanthauza cell ' munda, lembani mndandanda wa ma cell. Ili ndi kale magulu osankhidwa mwachisawawa.
6. Lembani mawu achinsinsi m'munda wa Achinsinsi ndipo dinani Chabwino .
7. Lembaninso mawu achinsinsi mu ' Tsimikizani Mawu Achinsinsi ' bokosi la zokambirana ndikudina Chabwino .
8. Mndandanda watsopano udzawonjezedwa . Mutha kutsatiranso masitepe kuti mupange mipata yambiri.
9. Dinani pa ' Tetezani Mapepala ' batani.
10. Lembani mawu achinsinsi pawindo la 'Tetezani Mapepala' pa pepala lonse ndi sankhani zochita mukufuna kulola. Dinani Chabwino .
khumi ndi chimodzi. Lembaninso mawu achinsinsi pawindo lotsimikizira, ndipo ntchito yanu yatha.
Tsopano, ngakhale pepala lanu litetezedwa, ma cell ena otetezedwa adzakhala ndi mulingo wowonjezera wotetezedwa ndipo amatsegulidwa kokha ndi mawu achinsinsi. Muthanso kupatsa mwayi wofikira pazigawo popanda kuyika mawu achinsinsi nthawi zonse:
imodzi.Mukapanga mndandanda, dinani ' Zilolezo 'Choyamba choyamba.
2. Dinani pa Add batani pawindo. Lowetsani dzina la ogwiritsa ntchito mu ' Lowetsani mayina azinthu kuti musankhe ’ bokosi. Mutha kulemba dzina la munthu yemwe wasungidwa mudomeni yanu . Dinani pa Chabwino .
3. Tsopano tchulani chilolezo kwa wogwiritsa ntchito aliyense pansi pa ' Mayina a gulu kapena ogwiritsa ntchito ' ndipo onani Lolani njira. Dinani pa Chabwino , ndipo ntchito yanu yatha.
Alangizidwa:
- Momwe Mungasinthire Mizati kapena Mizere mu Excel
- Momwe mungasinthire fayilo ya Excel (.xls) kukhala fayilo ya vCard (.vcf)?
- Sinthani Mwamsanga Pakati pa Mapepala Ogwira Ntchito mu Excel
- Momwe Mungakonzere Zithunzi Za WhatsApp Zosawonetsedwa Mu Gallery
Izi zonse zinali njira zosiyanasiyana zomwe mungathe Tsekani kapena tsegulani ma cell mu Excel. Kudziwa momwe mungatetezere pepala lanu ndikofunikira kwambiri kuti muteteze ku kusintha kwangozi. Mutha kuteteza kapena kuteteza ma cell papepala la Excel nthawi imodzi kapena kusankha mtundu wina. Muthanso kupatsa ena ogwiritsa ntchito mwayi wokhala ndi mawu achinsinsi kapena opanda mawu achinsinsi. Tsatirani ndondomeko pamwambapa mosamala, ndipo musakhale ndi vuto.
Pete Mitchell Pete ndi Mlembi wamkulu wa ogwira ntchito ku Cyber S. Pete amakonda zinthu zonse zamakono komanso ndi DIYer wofunitsitsa pamtima. Ali ndi zaka khumi akulemba momwe-tos, mawonekedwe, ndi maupangiri aukadaulo pa intaneti.