Hanyoyi 6 don kashe karatu a cikin Excel 2016

Fayil ɗin Excel za a iya sanya shi cikin yanayin karantawa kawai lokacin da aka yiwa fayil ɗin alama a matsayin ƙarshe, lokacin da aka ajiye shi azaman karantawa kawai, ko lokacin da aka kulle maƙunsar rubutu ko tsarin littafin aiki, da sauransu. Duk da haka, kamar yadda karatu zai iya taimakawa, yana iya zama cikas, musamman ma lokacin da ba ku san yadda ake cire ƙuntatawa ba.

A cikin wannan labarin, za mu dubi wasu hanyoyin da za a bi kashe karatu a cikin Excel 2016 ko kuna da kalmar sirri ko a'a.

Sashe na 1. Hanyar gama gari don Kashe Karatu a cikin Excel 2016 Ba tare da Kalmar wucewa ba

Kashe fasalin karantawa kawai a cikin Excel na iya zama da wahala, ko da ba zai yiwu ba, lokacin da ba ku san kalmar sirri da aka yi amfani da ita don sanya ƙuntatawa ba. Koyaya, akwai wasu kayan aiki a kasuwa waɗanda zasu iya taimaka muku kawar da karatu a cikin Excel 2016 cikin sauƙi. Daya daga cikin mafi kyau shine Fasfo don Excel .

Waɗannan su ne wasu fasalulluka waɗanda Passper for Excel ke bayarwa:

• Yana goyan bayan cire duk nau'ikan daga yanayin karantawa kawai babu kalmomin shiga.
• Cire kalmomin shiga masu buɗewa kuma shafe kariya daga karanta kawai a ciki takardun aiki/littattafai Excel 2016 ba tare da shafar bayanan daftarin aiki ba.
• Buɗe takaddun Excel lokacin da kuka manta kalmar wucewa, ba za ku iya kwafin maƙunsar bayanai ko bayanan littafin aiki ba, ba za ku iya buga maƙunsar rubutu/littafin aiki ba, ko kuma ba za ku iya shirya abubuwan da ke cikin takaddar ba.
• Bugu da ƙari, shi ne mai sauqi don amfani , tunda yana ba ka damar goge karatun a dannawa ɗaya.
• Yana goyan bayan duk nau'ikan takaddun Excel, gami da Excel 96-Excel 2019.

Gwada shi kyauta

Anan ga yadda ake amfani da Fasfo don Excel don cire karatu a kowace takaddar Excel:

Mataki 1: Zazzage kuma shigar da Fasfo don Excel akan kwamfutarka sannan ka kaddamar da shirin.

Mataki na 2: Danna "Cire Ƙuntatawa" sannan danna "Ƙara" don nemo taƙaitaccen takaddun Excel a cikin shirin.

Mataki na 3: Lokacin da aka ƙara fayil ɗin zuwa shirin, danna "Share" kuma Fasfo don Excel nan da nan zai fara cire ƙuntatawa daga fayil ɗin. A cikin ƴan daƙiƙa kaɗan, zaku sami damar shiga takaddar Excel 2016 ba tare da wani hani ba.

Gwada shi kyauta

Sashe na 2. 5 Abubuwa daban-daban don Kashe Karatu a cikin Excel 2016

Akwai galibi lokuta daban-daban guda 5 inda aka yiwa Excel 2016 alama a matsayin karanta-kawai kuma madaidaicin maganin su shine kashe fasalin karantawa kawai.

Hali 1: Lokacin da aka yi daftarin aiki karanta-kawai yayin adanawa

Kuna iya amfani da fasalin "Ajiye As" kamar yadda ke ƙasa don kashe yanayin karatu a cikin Excel 2016:

Mataki 1: Fara da buɗe littafin aikin Excel sannan shigar da kalmar wucewa idan ya cancanta. Danna "Fayil> Ajiye As" sannan ka zaɓi wuri mai dacewa akan kwamfutarka don adana fayil ɗin.

Ya wuce 2: Danna kibiya mai saukewa kusa da maɓallin "Kayan aiki » sannan ka zaba “Zaɓuɓɓukan gama gari «.

Ya wuce 3: Share kalmar sirrin da ke bayyana a cikin akwatin "Passsword don gyarawa" kuma danna "Ok" don ɗaga ƙuntatawa-karanta kawai. Danna "Ok."

Ya wuce 4: A ƙarshe, danna "Ajiye" don kammala aikin.

Hali na 2: Lokacin da aka yiwa takaddar alama ta ƙarshe

Alama daftarin aiki na Excel 2016 a matsayin "Na ƙarshe" na iya sanya ƙuntatawa-karanta kawai akan takaddar. Anan ga yadda ake kashe wannan ƙuntatawa akan takaddar da aka yiwa alama ta ƙarshe.

Mataki 1: Bude ƙuntataccen takaddar Excel 2016 akan kwamfutarka.

Mataki na 2: A saman daftarin aiki, ya kamata ku ga maɓallin "A gyara komai «. Danna shi kuma za a ɗaga ƙuntatawa-karanta-kawai, yana ba ka damar gyara daftarin aiki.

Hali na 3: Lokacin da aka kulle maƙunsar rubutu ko tsarin littafin aiki

Hakanan ƙuntatawa na karantawa kawai na iya faruwa lokacin da marubucin takaddar Excel 2016 ya kulle tsarin aikin ko littafin aiki, yana hana a gyara takardar aikin. A wannan yanayin, zaku iya magance matsalar a cikin matakai masu sauƙi masu zuwa:

Mataki 1: Bude daftarin aiki na Excel tare da ƙuntatawa-karanta kawai, sannan danna «Bita > Takardun mara kariya «.

Mataki na 2: Shigar da kalmar wucewa a cikin akwatin da ya dace kuma danna "Ok" don ɗaga ƙuntatawa.

Hali na 4: Lokacin da takaddar tana da matsayin karanta-kawai

Ana iya kashe karatu a cikin Excel 2016 ta amfani da zaɓin Abubuwan Fayil a cikin Fayil ɗin Fayil ɗin Windows. Ga yadda kuke yi:

Mataki 1: A cikin Fayil Explorer, kewaya zuwa ƙayyadadden fayil ɗin Excel. Danna dama akan takardar, sannan zaɓi "Properties" daga cikin zabukan da aka gabatar.

Mataki na 2: Cire alamar zaɓi "Karanta kawai "a cikin rukuni “Halayen » kuma danna "Ok" don musaki ƙuntatawa-karanta kawai.

Case 5: Lokacin da takaddar Excel 2016 ke buƙatar kalmar sirri

Lokacin da kuke buƙatar shigar da kalmar wucewa don samun dama da gyara takaddun Excel 2016, kuna iya bin waɗannan matakai masu sauƙi don ɗaga wannan ƙuntatawa:

Mataki 1: Fara da buɗe takaddar Excel 2016 da kuke son kashe fasalin karantawa kawai.

Mataki na 2: Lokacin da akwatin kalmar sirri ya bayyana, danna "Karanta kawai » maimakon haka kuma takardar za ta buɗe a yanayin Karanta Kawai.

Mataki na 3: Yanzu danna "Taskar bayanai > Ajiye azaman »kuma shigar da sunan fayil daban. Danna" Ajiye »don ajiye sabon kwafin ainihin fayil ɗin.

Sabuwar fayil ɗin da aka ƙirƙira zai maye gurbin daftarin karatu kawai kuma ba zai sami kowane hani na asali ba.

Abubuwan da ke sama suna sauƙaƙa muku don musaki karantawa kawai a cikin Excel 2016 ko kuna da kalmar wucewa ko a'a. Zaɓi hanyar da ta fi dacewa da bukatun ku da kuma yanayin ku na musamman. Bari mu san idan kun sami damar ɗaga ƙuntatawa-karanta kawai a cikin sashin maganganun da ke ƙasa.

Gwada shi kyauta