Yadda za a kulle saituna da kuma kare kayan aiki a Excel

Don hana canje-canje na bazata ko kuma da gangan ga wasu abubuwa a cikin takarda ko littafi , Excel yana da kayan aikin kare wasu takardun aiki waɗanda za a iya amfani dashi tare da ko ba tare da kalmar sirri ba.

Kare bayanan daga canji a cikin takardar aiki na Excel abu ne na biyu.

1. Kulle / buɗewa ko ƙayyadaddun ƙwayoyin ko abubuwa, kamar sigogi ko graphics, a cikin takarda.
2. Yin amfani da Takardar Shafin Tsare - har sai mataki na 2 ya kammala, duk abubuwan da ke aiki da bayanai sun kasance masu sauƙi don canjawa.

Lura : Kare fayilolin aikin aikin kada ya dame shi tare da tsaro na kalmar sirri-rubutu, wanda yayi babban matakin tsaro kuma za'a iya amfani dashi don hana masu amfani su bude fayil gaba daya.

Mataki na 1: Kulle / Buše Cells a Excel

Ta hanyar tsoho, duk kullun a cikin takardar aikin Excel suna kulle. Wannan yana da sauƙi don kare duk bayanan da tsarawa a cikin takarda ɗaya kawai ta hanyar amfani da nau'in takardar tsaro.

Don kare bayanan a cikin dukkanin takardun shaida a cikin takarda, dole ne a yi amfani da zaɓi na takardar kare takardun zuwa kowane takarda takamaimai.

Budewa ƙayyadadden ƙwayoyin suna bada izinin canje-canje da za a yi wa wadannan kwayoyin bayan an riga an amfani da wani zaɓi na tsare-tsare / littafin aiki.

Za a iya buɗe salula ta amfani da zaɓi na Lock Cell. Wannan zabin yana aiki kamar sauya fasalin - yana da jihohi biyu ko matsayi - ON ko KASHE. Tun da an rufe dukkanin sel a cikin takardun aiki, danna kan wani zaɓi ya buɗe dukkanin waɗanda aka zaɓa.

Wasu ƙwayoyin a cikin takardun aiki za a iya bar su a bude don sabunta sababbin bayanai za a iya canzawa ko bayanan data kasance.

Sulfofin dauke da ƙididdiga ko wasu muhimman bayanai suna kiyaye su don haka idan an yi amfani da zaɓi na kayan tsaro / littafin aiki, waɗannan kwayoyin ba za a iya canza ba.

Misali: Buše Cells a Excel

A cikin hoto a sama, ana amfani da kariya ga sel. Matakan da ke ƙasa da alaka da misalin aikin aiki a cikin hoto a sama.

A wannan misali:

• An cire sakonni I6 zuwa J10 don bada damar bada bayanai ko gyara kamar yadda ya kamata.
• Sel na I10 da J10, wanda ya ƙunshi siffofi don lissafin yawan kudin shiga, an rufe su.
• An kunna zaɓi zaɓi na tsare-tsare don wannan takarda.

Matakai don kulle / buɗewa kwayoyin:

1. Gano sassa I6 zuwa J10 don zaɓar su.
2. Danna kan shafin shafin.
3. Zaɓi Zaɓin Zabin a kan rubutun don buɗe jerin abubuwan da aka sauke.
4. Danna maɓallin Lock Cell a kasa na jerin.
5. An cire kullun Siffofin I6 zuwa J10 a yanzu.

Buše Charts, Textboxes, da kuma Hotuna

Ta hanyar tsoho, duk sigogi, akwatunan rubutu, da abubuwa masu zane - kamar hotuna, zane-zane, siffofi, da kuma Smart Art - gabatarwa a cikin takardun aiki suna kulle kuma, sabili da haka, ana kiyaye su lokacin da ake amfani da Zaɓin Shee t.

Don barin irin waɗannan abubuwa a buɗe don su canza sau ɗaya bayan an kare takardar:

1. Zaɓi abin da za a bude; yin haka ƙara da Format shafin zuwa kintinkiri.
2. Danna Maɓallin shafin.
3. A cikin Ƙungiyar Ƙungiya a gefen dama na rubutun, danna maɓallin maganin maganin maganin (ƙananan arrow arrow arrow) kusa da Maganin Girma don buɗe aikin ɗawainiya (Tsarin maganganun Hotuna a Excel 2010 da 2007)
4. A cikin sassan Properties na ɗawainiyar ɗawainiya, cire alamar rajistan shiga daga akwatin akwati Kulle, kuma idan an aiki, daga akwatin rajistan rubutu.

Mataki na 2: Aiwatar da Takardar Bayar da Takarda a Excel

Mataki na biyu a cikin tsari - kare dukkanin takardun aiki - ana amfani da shi ta amfani da akwatin maganin Protect Sheet.

Akwatin maganganun ta ƙunshi jerin zabin da za su iya ƙayyade abubuwan da za a iya canzawa ta aiki. Wadannan abubuwa sun hada da:

• Ƙara kalmar sirri don hana kullun aiki daga kashewa.
• Zaɓin kullun da aka buɗe.
• Shirya, motsi, ko share bayanai.
• Ƙara / share layuka da ginshiƙai .
• Ajiyewa ko ɓangaren haɓakawa da layuka.
• Canza canjin lamba - alamomin kuɗi, kashi alamomi, yawan wuraren wurare, da dai sauransu.
• Canza tsarin tsarawa - ƙara / cire kan iyakoki , cell ko launin launin launi, musayar rubutu , da dai sauransu.

Lura : Ƙara kalmar sirri ba ta hana masu amfani su buɗe aikin aiki da kallon abinda ke ciki ba.

Idan zaɓuɓɓuka guda biyu da suka ba da damar mai amfani don haskaka ɗakin kulle da buɗewa an kashe, masu amfani baza su iya yin canje-canje a cikin takardun aiki ba - koda kuwa yana dauke da Kwayoyin da ba a kulle ba.

Sauran sauran zaɓuɓɓuka, irin su tsara kwayoyin halitta da kuma rarraba bayanai, ba duka suna aiki ba. Alal misali, idan an cire maɓallin zaɓuɓɓukan tsarin lokacin da aka kare takardar, ana iya tsara dukkan kwayoyin halitta.

Ainihin zaɓi, a gefe guda, yana ba da damar kawai a kan waɗancan sel waɗanda aka buɗe kafin a kare kundin don a ware.

Misali: Aiwatar da Takardar Bayyana Takarda

1. Bude ko kulle sel da ake so a cikin aikin aiki na yanzu.
2. Danna kan shafin shafin.
3. Zaɓi Zaɓin Zabin a kan rubutun don buɗe jerin abubuwan da aka sauke.
4. Danna Maɓallin Shafin Shafin a kasa na jerin don buɗe akwatin maganganun Tsare-tsare.
5. Bincika ko cire abubuwan da ake so.
6. Danna Ya yi don rufe akwatin maganganu da kuma kare takaddun aiki.

Kashe Kariyar Kayan aiki

Don hana kullun aiki don kare dukkanin kwayoyin halitta:

1. Danna kan shafin shafin.
2. Zaɓi Zaɓin Zabin a kan rubutun don buɗe jerin abubuwan da aka sauke.
3. Danna kan Zaɓin Takardar Wallafa a kasan lissafin don kare tsarin.

Lura : Dakatar da takardun aiki ba shi da tasiri a kan ƙwayoyin kulle ko ƙulle.