Waxaa laga yaabaa inaad qof ka heshay faylka Excel , laakiin ma awoodid inaad wax ka beddesho ogeysiis la yaab leh Akhri-kaliya . ^(Read-only)Waxaa jira dhowr siyaabood oo lagu xallin karo dhibaatadan, iyo sida had iyo jeer, waxaan dooneynaa inaan uga hadalno waxoogaa. Akhriska-kaliya waa mid aad u badan oo macnaheedu yahay isticmaaluhu inuu awoodo inuu akhriyo oo keliya faylka oo aanu wax isbeddel ah ku samayn.

Sida Akhri-kaliya looga saaro Microsoft Excel

Haddii aad rabto inaad wax ka beddesho ama aad wax ka beddesho dukumeentiga Excel , waxaad ka saari kartaa sifada Read-kaliya adoo raacaya mid ka mid ah hababkan:

1. Isticmaal badhanka Edit Anyway
2. Kaydi faylka
3. Akhri-kaliya lagula taliyay iyo quful erayga sirta ah
4. Go'yaal la ilaaliyo.

1] Wax ka beddel si kastaba

Khaladka caadiga ah ee akhrinta-kaliya wuxuu si fudud uga baahan yahay isticmaaluhu inuu gujiyo badhanka leh Edit Anywa y . Marka taas la sameeyo, isticmaaluhu hadda wuxuu awoodi doonaa inuu isbeddel ku sameeyo dukumeentiga si kasta oo ay u arkaan inay ku habboon tahay. Aad u toosan oo barta. Iyadoo laga yaabo in tani aysan shaqeynin mar walba waa waxa ugu horreeya ee ay tahay inaad isku daydo. Tani ma shaqayn karto haddii sirta ah la ilaaliyo -

2] Keydi faylka

OK, markaa habka xiga ee lagu hagaajin karo dhibka akhris-kaliya, waa in la kaydiyo faylka. Riixitaanka badhanka Save ee sare ma shaqayn doono, sidaa awgeed, waa inaan ka faa'iidaysanayna Save As function. Dukumeentiga Excel , dooro File , halkaasna, dhagsii Save As .

Dooro meesha aad rabto inaad ku kaydiso dukumeentiga Excel waana taas, waad dhammaatay. Horey u soco oo fur dukumeentiga cusub ee la keydiyay ee Excel waana inaad awood u leedahay inaad wax ka beddesho oo aad sameyso isbedel kasta.

Tani waxay sidoo kale shaqeysaa haddii aad hesho qalad adigoo dhahaya Faylka Excel waa xaddidan yahay^{(The Excel File Is Restricted)} . Kaliya raac tillaabooyinka waana inaad fiicnaataa inaad tagto.

3] Akhri-kaliya lagula taliyay iyo quful erayga sirta ah

Haddii aad ku sugan tahay xaalad uu dukumeentiga oo dhan wada xidhan yahay oo uu u baahan yahay furaha sirta ah si loo furo, markaa tani way ku caawin kartaa. Tani waxay sidoo kale shaqayn doontaa haddii akhris-kaliya lagu taliyay marka la furayo dukumeenti Excel ah, markaa sii wad akhrinta.

OK, marka waxa ugu horeeya ee aad u baahan doonto inaad samayso halkan waa, guji File , ka dibna u keydi sida^{(Save As)} . Intaa ka dib, dhagsii Ikhtiyaarada badan^{(More Options)} , ka dibna laga bilaabo daaqada soo muuqata, hoos ka eeg Qalabka^(Tools) .

Dooro, oo isla markaaba waa inaad aragto ikhtiyaarka aad ku dari karto erayga sirta ah si aad u furto faylka ama calaamadda ka saar sanduuqa Read-only.

4] Xaashidda la ilaaliyo

Waa suurtagal in lagu ilaaliyo xaashida Microsoft Excel . Waxaan tan ku samayn karnaa annagoo midigta gujinaya magaca xaashida, ka dib dooro Sheet Protect^{(Protect Sheet)} oo hubi inaad ku darto furaha sirta ah. Xaashida la ilaaliyo macnaheedu waa qofna ma awoodi doono inuu wax ka beddelo dukumeentiga, sidaas darteed, isticmaalayaasha ugu dambeeya waa inay yaqaanaan erayga sirta ah ka hor intaanay horay u socon.

Markaa, si aad wax ugu soo celiso wadadii saxda ahayd, ku dhufo midig, ka dibna dooro Sheet Unprotect^{(Unprotect Sheet)} , oo ku dar furaha sirta ah si aad u furto.

Hadda, maadaama aan isticmaaleyno nooca Office 365 ee Excel , kaas oo ah nooca cusub ee aaladda, gaaritaanka meelaha qaar ayaa laga yaabaa inay aad uga duwanaato marka la barbardhigo noocyadii hore.

How to remove Read only from an Excel document?

You mаy have gotten an Excel file from someone, but you’re not able to edit it due to a strange Read-only notification. There are several ways to get around this problem, and like always, we are going to talk about it in a bit. Read-only is very common and means that the user is able to only read the file and not make any changes to it.

How to remove Read-only from Microsoft Excel

If you wish to edit or make changes to the Excel document, you can remove Read-only attribute by following any one of these methods:

1. Use Edit Anyway button
2. Save the file
3. Read-only recommended and password lock
4. Protected sheets.

1] Edit Anyway

The typical read-only error simply requires the user to click on a button that says Edit Anyway. Once that is done, the user will now be able to make changes to the document in any way they see fit. Very straightforward and to the point. While this may not work all the time it is the first thing you should try. This may not work if it is password protected –

2] Save the file

OK, so the next way to fix the read-only problem, is to save the file. Clicking on the Save button above won’t work, therefore, we have to take advantage of the Save As function. In your Excel document, select File, and from there, click on Save As.

Choose where you’d want to save the Excel document and that’s it, you’re done. Go ahead and open the newly saved Excel doc and you should have the ability to edit and make whatever changes.

This also works if you get an error saying The Excel File Is Restricted. Just follow the steps and you should be good to go.

3] Read-only recommended and password lock

If you are in a situation where the entire document is locked and requires a password to unlock, then this may help you. This will also work if read-only is recommended when opening an Excel document, so keep reading.

OK, so the first thing you will need to do here is, click on File, then Save As. After that, click on More Options, then from the window that appears, look below for Tools.

Select it, and right away you should see the option to add a password to open the file or uncheck the Read-only box.

4] Protected Sheet

It is possible to protect a sheet in Microsoft Excel. We can do this by right-clicking on the name of the sheet, then select Protect Sheet and make sure to add a password. A protected sheet means no one will be able to edit the document, therefore, the end-users must know the password before going forward.

So, to get things back on track, right-click, then select Unprotect Sheet, and add the password to unlock it.

Now, since we are using the Office 365 version of Excel, which is the newer version of the tool, getting to certain areas might be much different when compared to older versions.

Related posts

• Sida loo isticmaalo Percentile.Exc function gudaha Excel

• Sida loo isticmaalo shaqada NETWORKDAYS gudaha Excel

• Sida loo tiriyo lambarka Haa ama Maya ee Excel

• Excel, Word ama PowerPoint ma bilaabi karaan markii ugu dambeysay

• Sida loo isticmaalo sifada Nooca Xogta tooska ah ee Excel

• Sida loo isticmaalo shaqada ISODD ee Excel

• Sida loo isticmaalo shaqada COOSE ee Excel

• Sida loo isticmaalo OR shaqada Excel si loo go'aamiyo haddii xaaladdu run tahay

• Sida loo geliyo shaxda firfircoon ee xaashida Excel

• Sida loo beddelo qaabka faylka caadiga ah ee lagu kaydiyo Word, Excel, PowerPoint

• Xisaabi leexashada caadiga ah iyo khaladka caadiga ah ee macnaha Excel

• Sida loo tiriyo qiyamka nuqul ka mid ah tiirka Excel

• Sida loo isticmaalo INT iyo Functions LCM gudaha Excel

• Sida loogu daro Koodhka Dalka ama Goobta Liiska Lambarka Taleefanka ee Excel

• Sida loo isticmaalo Rept Function gudaha Excel

• Sida loogu isticmaalo DEC2Bin gudaha Excel si loogu beddelo nambarka jajab tobanle ee binary

• Sida loo midoobo oo loo kala saaro unugyada Excel

• Sida looga soo saaro magacyada domain URL-yada Microsoft Excel

• Microsoft Excel waxay sababtaa isticmaalka CPU sare marka uu socdo Windows 10

• Sida loo isticmaalo shaqada HLOOKUP ee Microsoft Excel