Da zarar kun gama gyara littafin aikin, zaku iya sanya takunkumin karantawa kawai akansa kuma duk wanda kuka raba dashi zai iya karanta shi, amma ba za su iya gyara takaddar ta kowace hanya ba. Koyaya, yin amfani da karanta-kawai na iya zama cikas lokacin da gaske kuna buƙatar yin canje-canje ga takaddar. Wataƙila aboki ko abokin aiki sun raba littafin aikin Excel mai karantawa kawai tare da ku kuma sun manta da su raba tare da ku yadda ake cire wannan ƙuntatawa.
Ana iya saita Excel zuwa karanta-kawai tare da zaɓuɓɓuka da yawa. A cikin wannan labarin, mun lissafa duk abubuwan da za a iya yi da kuma hanyoyin magance su don ku sani yadda ake cire karatu daga excel a lokuta da dama.
Excel ana yin karatu-kawai ta amfani da “Mark as Final”
Ɗaya daga cikin dalilan da ya sa takardar Excel ɗin da kuke da ita ake karantawa-kawai ita ce editan ya yi mata alama ta ƙarshe. Idan haka ne, ya kamata ku ga saƙo a saman takardar yana cewa "An yi alama a matsayin ƙarshe."
Da zarar takarda ta yi alama ta ƙarshe, ba zai yuwu a yi canje-canje gare ta ba. Ba za ku iya rubuta, gyara ko ma gwada daftarin aiki a cikin wannan jihar ba. Amma kuma yana da sauƙin cirewa. Kawai danna maɓallin "Edit ko ta yaya" a ƙarshen saƙon kuma zaku iya kashe fasalin karantawa kawai a cikin Excel.
Fayil na Excel ya zama fayil ɗin karantawa kawai shawarar "Ajiye As"
Wani yanayi don sanin cewa takaddar Excel tana cikin yanayin karantawa kawai shine cewa za a sa ka buɗe takaddar a yanayin karantawa kawai sai dai idan kana buƙatar yin canje-canje a cikinta. Idan ba kwa son yin canje-canje ga takaddar, kawai danna "Ee." Idan kuma kuna son gyara takardar, kawai danna "A'a" don buɗe ta.
Idan kuna son buɗe fayil ɗin Excel mai karantawa kawai, bi waɗannan matakai masu sauƙi:
Mataki 1: Lokacin da ka fara buɗe daftarin aiki na Excel kuma ka karɓi saƙon yana baka zaɓuɓɓuka uku don buɗe takaddar karanta kawai, kawai danna “Ee” don buɗe fayil ɗin a yanayin karantawa kawai.
Mataki na 2: Idan kun yi wasu canje-canje ga abun ciki na takaddar kuma kuyi ƙoƙarin adana canje-canje, sabon saƙo ya bayyana yana tambayar ku da ku ajiye kwafin fayil ɗin kuma ku sake suna. Danna "Ok" don buɗe akwatin maganganu "Ajiye As", sannan danna "Kayan aiki> Zaɓuɓɓuka Gabaɗaya."
Mataki na 3: A cikin akwatin maganganu na “Gaba ɗaya Zaɓuɓɓuka” da ke bayyana, cire alamar zaɓin “An ba da shawarar karantawa kawai” kuma danna “Ok.”
Mataki na 4: Komawa cikin akwatin maganganu "Ajiye As", danna "Ajiye." Wannan zai yi kwafin ainihin fayil ɗin Excel. Fayil ɗin da aka kwafi ba za a karanta shi kaɗai ba kuma za ku iya ci gaba da gyara shi yadda kuke so.
Wannan zai cire ƙuntatawa-karanta kawai daga takaddar Excel.
Tsarin zanen gadon Excel da littattafan aiki yana kulle kuma ana karantawa kawai
Idan fayil ɗin Excel yana cikin yanayin karantawa kawai saboda takardar aiki ko tsarin littafin aiki yana kulle, ƙila za ku iya cire ƙuntatawar karantawa kawai na Excel idan kun san kalmar sirri. Ga yadda kuke yi:
Mataki 1: Bude fayil ɗin Excel mai kariya, don haka zaku iya ganin duk takaddun aiki da abun ciki.
Mataki na 2: Danna "Bita" a cikin babban menu sannan zaɓi "Sheet mara tsaro" a ƙarƙashin "Changes." Shigar da kalmar wucewa don kammala tsari.
Mataki na 3 : Idan tsarin littafin aikin ne aka kiyaye, danna "Unprotect Workbook" sannan shigar da kalmar wucewa don cire ƙuntatawa.
Ajiye daftarin aiki kuma za a cire ƙuntatawa-karanta kawai.
Fayil na Excel kalmar sirri ne ƙuntatawa azaman karantawa kawai
Wani lokaci idan ka buɗe fayil ɗin Excel da aka rufaffen, za a umarce ka ka shigar da kalmar sirri don samun damar rubutawa ko buɗe shi karantawa kawai. Danna kan zaɓin "Karanta kawai" kuma fayil ɗin Excel zai iyakance don gyarawa da karantawa. Bi waɗannan matakan don buɗe fayil ɗin Excel mai karantawa:
Mataki na 1. Ajiye fayil ɗin Excel na yanzu karanta-kawai ta danna Fayil> Ajiye As.
Mataki na 2. Kawai ajiye shi azaman takaddar Excel daban kuma danna "Ajiye" don ci gaba.
Yanzu zaku iya buɗe kwafin fayil ɗin Excel kuma ku canza shi.
Tukwici Bonus: Cire Karatun Excel Kawai Ba tare da Kalmar wucewa ba (Ga Duk Abubuwan Sama)
Idan kuna son cire yanayin "karanta-kawai" na Excel saita ta duk zaɓuɓɓuka a danna daya kawai ba tare da kalmar sirri ba , to ɗayan mafi kyawun hanyoyin yin hakan shine ta amfani da kayan aikin cire kalmar sirri na Excel kamar Fasfo don Excel .
Fasfo don Excel kayan aiki ne wanda ke ba ku damar cire saitunan karantawa kawai ta amfani da Alama azaman Karshe da Ajiye As, cire ƙuntatawa akan tsarin zanen Excel da littattafan aiki, da cire kalmar sirrin buɗewa akan kowane takaddar Excel ta kulle.
Don haka, kayan aiki ne mai fa'ida sosai lokacin da ba za ku iya buɗewa ko gyara takaddar Excel mai karantawa kawai ba. Ga wasu daga cikin siffofinsa:
Fasfo don Excel: Cire karatun Excel a cikin daƙiƙa 2:
- Dukkan lamuran sun shafi: Cire ko kashe karatun Excel a duk lokuta masu yiwuwa.
- Matsakaicin ƙimar nasara: Algorithm na ci gaba yana ba da garantin a 100% yawan cirewa .
- Sauƙi don amfani : Hakanan yana da sauƙin amfani. Tare da shi, zaku iya dawo da kalmar wucewa ta buɗewa a cikin ƴan matakai masu sauƙi kuma cire hani a cikin dannawa ɗaya.
Yadda ake Buše Fayilolin Excel Karatu-kawai tare da Fasfo don Excel
Anan ga yadda ake amfani da Fasfo don Excel don cire ƙuntatawa-karanta kawai daga takaddar Excel:
Mataki 1: Zazzage kuma shigar Fasfo don Excel a kan kwamfutarka sannan ka bude shi. A cikin babban taga, zaɓi “Cire ƙuntatawa «.
Mataki na 2: Danna "Ƙara" don shigo da ƙayyadaddun daftarin aiki zuwa Fasfo.
Mataki na 3: Da zarar an yi nasarar ƙara daftarin aiki zuwa shirin, danna "Kawar da »kuma duk wani ƙuntatawa na karantawa kawai akan takaddar Excel za'a cire shi cikin nasara.
Tips: Kamar yadda muka ambata a baya, Fasfo don Excel kuma ana iya amfani da su don dawo da kalmomin shiga na buɗewa. Idan kun rasa kalmar sirri don buɗe fayil ɗin Excel ɗinku ko kuma idan kun karɓi fayil ɗin Excel da aka kare tare da kalmar sirri ta buɗewa, kuna iya gwadawa.
Kammalawa
Abubuwan da ke sama sune mafi kyawun hanyoyi 5 a gare ku idan ba ku sani ba yadda ake cire karatu daga excel . Da fatan za a lura cewa akwai dalilai da yawa da ya sa ba za ku iya samun dama ga takaddar Excel ba, kodayake ɗayan mafi yawanci shine lokacin da takaddar ta kasance "alama ta ƙarshe." Fasfo don Excel yana ba ka damar samun dama ga takaddar cikin sauƙi ba tare da la'akari da hane-hane da aka ƙulla ba, gami da takaddun da ke kare kalmar sirri.
