Kukhazikitsa mawu achinsinsi mu Microsoft Excel

Chitetezo ndi chitetezo cha data ndi njira imodzi yakukula kwamakono amakono azidziwitso. Kufunikira kwa vutoli sikukuchepa, koma kumakula kokha. Kuteteza deta ndikofunikira kwambiri pamafayilo amtundu, omwe nthawi zambiri amasunga zambiri zofunikira zamalonda. Tiphunzire momwe tingatetezere mafayilo a Excel achinsinsi.

Kukhazikitsa kwachinsinsi

Opanga pulogalamuyi adamvetsetsa bwino kufunika kwa kukhazikitsa mawu achinsinsi pamafayilo a Excel, chifukwa chake adakhazikitsa njira zingapo pochitira njirayi nthawi imodzi. Nthawi yomweyo, ndikotheka kukhazikitsa kiyi, yonse potsegula bukulo ndikusintha.

Njira 1: ikani mawu achinsinsi posunga fayilo

Njira imodzi ndikukhazikitsa chinsinsi pomwe mukupulumutsa buku la Excel.

1. Pitani ku tabu Fayilo Mapulogalamu a Excel.



2. Dinani pazinthuzo Sungani Monga.



3. Pa zenera lomwe limatsegula, sungani bukulo, dinani batani "Ntchito"ili pansi pomwe. Pazosankha zomwe zimapezeka, sankhani "Zosankha zambiri ...".



4. Windo lina laling'ono limatseguka. Monga momwemo mutha kufotokoza mwachinsinsi dzina la fayilo. M'munda "Chinsinsi choti mutsegule" lembani mawu ofunika omwe muyenera kufotokozera mukamatsegula bukulo. M'munda "Chinsinsi chosintha" lowetsani fungulo lomwe lifunika kulowa ngati mukufuna kusintha fayiloyi.

   Ngati mukufuna kulepheretsa anthu ena kuti asinthe fayilo yanu, koma mukufuna kusiya kuonera kwaulere, ndiye, lembani mawu achinsinsi oyamba okha. Ngati mafungulo awiri afotokozedwa, ndiye kuti mutatsegula fayilo, mudzakulimbikitsidwa kuti mulowetse onse awiri. Ngati wogwiritsa ntchito amangodziwa gawo loyambirira la iwo, ndiye kuti ndi owerengera okha omwe angapeze kwa iye, popanda kuthekera kosintha deta. M'malo mwake, amatha kusintha chilichonse, koma kusunga izi sikungathandize. Mutha kungopulumutsa ngati buku popanda kusintha chikalata choyambirira.

   Kuphatikiza apo, mutha kuwunika bokosi loyandikira "Tsimikizirani mwayi wowerenga pokha".

   Mwanjira iyi, ngakhale kwa wogwiritsa ntchito amene amadziwa mapasiwedi onse, fayilo idzatseguliridwa popanda chida. Koma, ngati angafune, nthawi zonse amatha kutsegula tsambali ndikudina batani lolingana.

   Pambuyo mawonekedwe onse pazenera lazonse atamalizidwa, dinani batani "Zabwino".



5. Windo limatseguka pomwe mukufunanso kulowa kiyi. Izi zimachitika kuti wosuta asamayankhe molakwika nthawi yoyamba yolakwika yolemba. Dinani batani "Zabwino". Ngati mawu osakira sagwirizana, pulogalamuyo imakulimbikitsani kuti mulowetsenso password.



6. Pambuyo pake, tibwereranso ku fayilo yopulumutsa. Apa mutha kusankha dzina lake ndikusankha komwe ikupezeka. Mukamaliza zonsezi, dinani batani Sungani.

Chifukwa chake, tidateteza fayilo ya Excel. Tsopano, kuti mutsegule ndikusintha, muyenera kuyika mapasiwedi oyenera.

Njira yachiwiri: ikani mawu achinsinsi mu "Zambiri"

Njira yachiwiri imaphatikizapo kukhazikitsa password pachigawo cha Excel "Zambiri".

1. Monga nthawi yotsiriza, pitani ku tabu Fayilo.
2. Mu gawo "Zambiri" dinani batani Tetezani Fayilo. Mndandanda wazosankha zoteteza ndi kiyi ya fayilo imatsegulidwa. Monga mukuwonera, apa mungathe kuteteza osati fayilo yonse, komanso pepala lolekanitsidwa, komanso kukhazikitsa chitetezo pakusintha kwa buku.



3. Ngati tiima "Sungitsa ndi password", zenera lidzatsegulidwa momwe muyenera kulowetsamo mawu osakira. Chinsinsi ichi chikufanana ndi kiyi yotsegulira bukuli, lomwe tidaigwiritsa ntchito momwe tidasungirako fayilo. Mukamalowetsa tsambalo, dinani batani "Zabwino". Tsopano, osadziwa fungulo, palibe amene angatsegule fayilo.



4. Mukamasankha chinthu Tetezani Mapepala Apa zenera lokhala ndi makonda ambiri lidzatsegulidwa. Palinso zenera lolowera achinsinsi. Chida ichi chimakuthandizani kuti muteteze pepala linalake kuti lisasinthe. Nthawi yomweyo, kusiyanitsa chitetezo chotchinga pakusintha, njirayi siyipereka mwayi wokhazikitsa pepala losinthidwa. Zochita zonse pa izi ndizotsekedwa, komabe buku lingathe kupulumutsidwa.

   Wogwiritsa ntchito amatha kukhazikitsa chitetezo chake pomenya zinthu zomwe zikugwirizana. Mwakusintha, pazakuchita zonse kwa wogwiritsa ntchito yemwe alibe dzina lachinsinsi, masankhidwe omwe amapezeka pa pepala okha. Koma, wolemba chikalatacho amatha kuloleza kupanga, kukhazikitsa ndi kuchotsa mizere, kukonza, kugwiritsa ntchito autofilter, kusintha zinthu ndi zolemba, ndi zina zambiri. Mutha kuchotsa chitetezo pazinthu zilizonse. Pambuyo pakusintha zoikamo, dinani batani "Zabwino".



5. Mukadina pachinthu "Tetezani kapangidwe ka buku" Mutha kukhazikitsa chitetezo cha mtunduwo. Zosungirazo zimapereka kusintha kwa mawonekedwe otchinga, zonse ndi mawu achinsinsi komanso popanda iwo. Poyamba, izi ndizomwe zimatchedwa "kutetezedwa kwa chitsiru," kutanthauza kuti sizichitika mwadala. Mlandu wachiwiri, izi ndizoteteza ku kusintha kwadala kwa dongosololi ndi ogwiritsa ntchito ena.

Njira 3: Ikani achinsinsi ndikuchotsa mu "ndemanga" tabu

Kutha kukhazikitsa chinsinsi mulinso tabu "Ndemanga".

1. Pitani pa tabu pamwambapa.



2. Tikuyang'ana chida chothandizira "Sinthani" pa tepi. Dinani batani Tetezani Mapepala, kapena Tetezani Buku. Mabatani awa amagwirizana kwathunthu ndi zinthuzo Tetezani Mapepala Apa ndi "Tetezani kapangidwe ka buku" mu gawo "Zambiri"zomwe tanena kale pamwambapa. Zochita zina ndizofanana kotheratu.



3. Kuti muchotse mawu achinsinsi, muyenera dinani batani Chotsani pepala " pa riboni ndikulowetsa mawu oyenera.

Monga mukuwonera, Microsoft Excel imapereka njira zingapo zotetezera fayilo ndi mawu achinsinsi, onse kubera kwachinsinsi komanso kuzichita mwadala. Mutha kuteteza ndi kutsegulira buku ndikusintha kapena kusintha magawo ake. Potere, wolemba akhoza kudziwunikira zomwe angasinthe pofuna kuteteza chikalatacho.