Ba da kariya ga kalmar sirri ta Excel Zai iya zama tsari mai rikitarwa fiye da ƙasa dangane da dalilai daban-daban. Tsaron da Microsoft ke aiwatarwa a cikin ofishin Office shine ɗayan mafi aminci, wanda ya cancanci sakewa, tunda shine aikace-aikacen da akafi amfani dasu a duniya don ƙirƙirar takardu.
A lokacin kare takardu a cikin Excel da Kalma da PowerPoint, muna da hanyoyi daban-daban. Ba wai kawai za mu iya ƙara lambar samun dama ba, amma kuma za mu iya kare daftarin aiki yadda za a iya shirya shi kuma ta haka ne za a hana kofen daftarin aikin mu rarraba da gyare-gyaren da muka aiwatar.
Me zan iya karewa a cikin takaddar Excel
Excel tayi mana nau'i biyu don kare takardunmu:
- Kare littafi. An tsara wannan aikin don hana kowane mutum yin kowane irin canji a cikin duk zanen gado waɗanda suke ɓangare na takaddar Excel. .
- Kare takardar. Idan kawai muna so mu kare ɗayan zanen gado waɗanda suke ɓangare na fayil na Excel (kamar tushen asalin bayanai a cikin tebur) kuma mu bar sauran zanen gado a cikin buɗe fayil ɗin Excel, za mu iya yin hakan ta wannan aikin.
Dukansu ayyuka suna nan a cikin saman tef za optionsu options optionsukan, a cikin sashe Don dubawa, ya ja baya Kare.
Amma kuma, ba tare da la'akari da ɓangaren daftarin aikin da muke kiyayewa ba, za mu iya buɗe wasu fannoni don a canza su ta hanyar zaɓi Bada kewayon gyara.
Yadda zaka kiyaye takaddar Excel
Kamar yadda nayi tsokaci a sakin layi na baya, Excel na bamu hanyoyi guda biyu don kare takardun da muka ƙirƙira tare da wannan aikace-aikacen. Dogaro da hanyar da muka zaba, za mu iya samun dama ko a'a ga takaddar don mu duba ta kuma mu yi canje-canje.
Guji gyara takardar Excel
Idan abin da muke so shine hana masu karɓar takardar Excel ɗinmu yin gyare-gyare akanshi, dole ne muyi amfani da aikin Kare takardar. Ana samun wannan aikin a cikin babban rubutun zaɓuɓɓuka, a cikin ɓangaren Don dubawa, ya ja baya Kare.
Kafin zaɓar wannan zaɓi, dole ne mu zaɓi kewayon ƙwayoyin da muke son kiyayewa. Don yin wannan, dole kawai mu danna kan kusurwar hagu na sama kuma ba tare da sakin linzamin kwamfuta ba ya ja shi zuwa kusurwar dama ta ƙasa inda bayanan ke ciki.
Gaba, danna maɓallin Kare takardar zaɓi. Gaba, dole ne mu shigar da kalmar wucewa (Sau 2) wannan zai bamu damar gyara zangon sel da muka zaba.
Wasu lokuta ba wai kawai bayanan ke da mahimmanci ba ne, amma Har ila yau, da format. A cikin zaɓuɓɓukan don kare takardar, zamu iya hana masu karɓar takaddar aiwatar da tsarawa zuwa sel, ginshiƙai da layuka, saka ginshiƙai da layuka, saka hanyoyin haɗi, share layuka ko ginshiƙai ...
Guji gyara littafin aiki na Excel
Don hana kowa daga gyaggyara duk abubuwan da ke cikin takaddar Excel, dole ne mu sami damar ribbon na sama na zaɓuɓɓuka, a cikin ɓangaren Don dubawa, ya ja baya Kare kuma zaɓi Kare Littafin.
Gaba, dole ne mu shigar da kalmar wucewa (sau 2), kalmar wucewa ba tare da, babu wanda zai iya yin canje-canje ga ɗayan takardar, don haka dole ne koyaushe mu kasance da shi a hannu, rubuta shi a cikin aikace-aikacen sarrafa kalmar sirri da / ko raba shi ga mutanen da za su sami damar zuwa daftarin aiki.
Yadda ake kalmar sirri kare bayanan Excel
Kada ku dame kare daftarin aiki daga gyare-gyare tare da ɓoye takardu tare da kalmar wucewa ta yadda kwata-kwata babu wanda bashi da kalmar wucewa da zai iya shiga ta. Lokacin ɓoye takardu tare da kalmar wucewa, idan ba mu san ta ba, ba za mu taɓa samun damar shiga abubuwan da ke ciki ba.
Ayyukan kalmar sirri ta ɓoye wani daftarin aiki Kuna iya haɗa ayyukan da ke ba mu damar kare littafi ko takardar ɗaba'a, tunda su ayyuka ne masu zaman kansu gaba ɗaya kuma ba su da alaƙa da juna.
para ƙara kalmar sirri zuwa takaddar Excel dole ne muyi wadannan matakan:
- Na farko, danna kan Amsoshi don samun damar kaddarorin daftarin aiki da muke son kiyayewa.
- Gaba, danna kan Bayani.
- Sannan mun latsa Kare littafi kuma mun rubuta kalmar sirri (sau 2) wanda zai kare damar shiga littafin.
Ya kamata a tuna cewa wannan kalmar sirri dole ne mu rasa shi tunda zamu rasa zabin shiga ta.
Yadda ake buɗe Excel tare da kalmar wucewa
Buɗe Excel don gyarawa
- Abu mafi sauki da farko, ya wuce adana takaddun a cikin takaddun takarda lissafin wasu aikace-aikacen, kamar wanda LibreOffice ya bayar. Koyaya, ana kiyaye mu, dole ne mu shigar dashi kafin aiwatar da jujjuyawar.
- Tsarin kawai da zamu iya fitarwa tebur don shirya shi daga baya (ba zai iya ɗaukar isasshen lokaci ba) shine PDF. Ta hanyar fitar dashi zuwa wannan PDF daga baya zamu iya ƙirƙirar sabon daftarin aiki na Excel tare da aikin da zai bamu damar sanin tebur daga hotuna.
- Kwafa da liƙa shine mafita mafi sauƙi. Kodayake yana iya zama wawanci, hanyar da za a sami damar samun damar abun cikin da aka kare kan gyara a cikin fayil ɗin Excel shine a kwafa da liƙa abun ciki a cikin sabon takarda, matuƙar ba a kashe wannan aikin daga zaɓuɓɓukan aikin ba don kare ta.
Buɗe Excel don karanta shi
A ɓoye ɓoyayyen ɓoyayyiyar da Microsoft ke amfani da ita don kare takaddun da muka ƙirƙira don kada kowa ba tare da mabuɗin ba zai iya samun damar yin hakan ba zai yiwu a fasa ba, sai dai bari muyi amfani da shirye-shiryen zalunci waɗanda aka keɓe don gwajin kalmomin shiga.
Amma saboda wannan, muna buƙatar lokaci mai yawa, tun da yawan adadin haɗuwa yana da yawa tun babu takurawa kan kalmomin shiga da muke amfani dasu dangane da tsayi (akan Windows), haruffa ko lambobi. Har ila yau, suna da lamuran shari’a. A kan Mac, iyakar girman kalmomin shiga da za mu iya amfani da su don kare daftarin aiki haruffa 15 ne.
Kada ku damu da neman mafita akan intanet. Idan baku san kalmar sirrin fayil ɗin ɓoyayyen ba, ba za ku taɓa samun damar shiga ba. Microsoft, kamar yadda aka bayyana a shafinsa na yanar gizo, ba zai iya taimaka maka cire katanga ga fayil ɗin ba, saboda dalilan da na bayyana a sakin layi na baya.