Kamar yadda zaparoleny Excel-fayil, da kuma cire kariya

Yau za mu tattauna yadda zaparoleny Excel-fayil. Wannan kayan aiki ne wani ɓangare na Microsoft Office. Excel shirin ba ka damar haifar alluna na sãɓãwar launukansa wuya, da yin amfani da dabarbari, kazalika da mutum zane. All halin yanzu version na aikace-aikace na goyon bayan kalmar sirri sanyi.

umurci

Mu ci gaba da lokaci na aiwatar bayanin yadda za a dawo da rikodin Excel-fayil. Wannan damar da aka bayar a cikin fayil format * .xls, kamar wani Microsoft Office takardun, ciki har da Kalma da kuma Access. Saboda haka, bayan ƙarshen daftarin aiki latsa maballin "File", wanda aka located a cikin menu a saman Microsoft Excel taga. A cikin jerin da ya bayyana, to, ka ga "Ajiye As" ta danna kan shi da zarar tare da hagu linzamin kwamfuta button. A maganganu akwatin ajiye daftarin aiki, akwai wani menu "Tools", danna inverted alwatika, sa'an nan kuma amfani da sabon aiki "General saituna".

gyara

Mu ci gaba da gaba da mataki na shata yadda zaparoleny Excel-fayil. "Janar Saituna" sashe ya bayyana a allon. Ga dole ne ka shigar da kalmar sirri don canza ko bude wani daftarin aiki. Bugu da kari, idan ka kunna aikin "Karanta Kawai" a lokacin da kokarin bude da kalmar sirri-kare Excel fayil, da toolbar zai tsoho to naƙasasshe.

Idan ka shigar da kariya kawai don gudanar da daftarin aiki, wani request domin shigar da zai bayyana duk lokacin da ka bude wani tebur. A wannan yanayin, duk masu amfani wanda zai san sirrin hade, za su iya žiržira da shirya data iri-iri. A cikin tambaya na yadda za a bude da kalmar sirri-kare fayil Excel, idan kariya an saita zuwa canza kaya, da jefa zai faru kamar yadda misali, ba tare da wani queries. Duk da haka, idan ka ƙara zuwa teburin sabon data da kuma kokarin ceton wani daftarin aiki, da app zai tambaye ga m hade.

Lokacin da iri kalmomin shiga, da ake bukata biyu shigarwa a lokacin farawa da kashewa da kayan. Yana da muhimmanci a san cewa za ka iya saita daban-daban kalmomin shiga domin gyara da kuma bude fayil.

Koma zuwa saitin. Lokacin da wata kalmar sirri (ko tururi) an saita, danna a cikin "General saituna" button «OK». A Windows Explorer, da daftarin aiki sunan da aka shiga, ajiye fayil ta amfani da ya dace aiki.

cire kariya

Next, mun tattauna yadda da kalmar sirri da aka rufe a Excel. Don magance matsalar ba ya bukatar wani ƙarin software, saboda aikin da aka bayar da gina-in kayan aikin aikace-aikace.

Run Excel. Bude da daftarin aiki kana so mu rabu da kalmar sirri kariya. "File" menu amfani. Saka "Ajiye As", sa'an nan kuma bude menu "Service". Ka je wa "General Saituna", amfani da linzamin kwamfuta danna sau biyu a kan asterisks a kalmar sirri da sauri. Yi amfani da «Del» button for ake so mataki. Mun tabbatar da aiki ta latsa «OK» button. Danna "Save" sa'an nan "I" a cikin wani sabon taga.

Wannan duk a cikin wani Excel Kundin kalmar sirri cire. Tare da duk takardar faruwa a irin wannan hanya. Bude menu "Tools", amfani da umurnin "Buše". Don tabbatar da sokewa mataki dole ka shigar da baya sanya kalmar sirri. Yanzu ka san yadda za zaparoleny Excel-fayil, kazalika da soke kariya, idan ya cancanta.