Abin da za a yi idan mashaya dabara a cikin Excel ya ɓace

A cikin tsarin dubawa na shirin Excel, ɗayan mahimman wuraren yana shagaltar da ma'aunin dabarar, wanda ke ba ku damar dubawa da canza abubuwan da ke cikin sel. Har ila yau, idan tantanin halitta ya ƙunshi dabara, zai nuna sakamakon ƙarshe, kuma ana iya ganin tsarin a cikin layi na sama. Don haka, amfanin wannan kayan aiki a bayyane yake.

A wasu lokuta, masu amfani na iya fuskantar cewa mashaya dabara ta ɓace. A cikin wannan labarin, za mu dubi yadda za a mayar da shi zuwa wurinsa, da kuma dalilin da ya sa hakan zai iya faruwa.

Magani 1: Kunna Nuni akan Ribbon

Mafi sau da yawa, rashi na dabara bar shi ne sakamakon gaskiyar cewa an cire alamar ta musamman a cikin saitunan kintinkiri na shirin. Ga abin da muke yi a wannan harka:

1. Canja zuwa shafin "Duba". Anan a cikin rukunin kayan aiki "Nuna" duba akwatin kusa da zabin "Formula Bar" (idan bai dace ba).
2. Sakamakon haka, sandar dabara za ta sake bayyana a cikin taga shirin.

Magani 2: Yin canje-canje ga saituna

Hakanan za'a iya kashe sandar dabara a cikin zaɓuɓɓukan shirin. Kuna iya kunna shi baya ta amfani da hanyar da aka bayyana a sama, ko amfani da tsarin aikin da ke ƙasa:

1. Bude menu "Fayil".
2. A cikin taga da yake buɗewa, a cikin lissafin hagu, danna kan sashin "Parameters".
3. A cikin sigogi, canza zuwa ƙaramin sashe "Ƙari". A cikin babban ɓangaren taga a hannun dama, gungura cikin abubuwan da ke ciki har sai mun sami shingen kayan aiki "Nuna" (a cikin sigar farko na shirin, ƙungiyar na iya samun sunan "Allon"). Neman zaɓi "Nuna dabara bar", sanya kaska a gabansa kuma tabbatar da canjin ta latsa maɓallin OK.
4. Kamar yadda a cikin hanyar da aka tattauna a baya don magance matsalar, layin zai koma wurinsa.

Magani 3: Mayar da aikace-aikacen

A wasu lokuta, sandar dabara ta daina nunawa saboda kurakurai ko faɗuwar shirin. Farfadowa na Excel na iya taimakawa a cikin wannan yanayin. Lura cewa matakan da ke ƙasa don Windows 10 ne, duk da haka, a cikin sigogin da suka gabata na tsarin aiki, kusan iri ɗaya ne:

1. Bude Control panel a kowace hanya mai dacewa, misali, ta hanyar Bincike neman.
2. Bayan da aka saita kallo a cikin nau'in gumaka manya ko ƙanana, je zuwa sashin "Shirye-shiryen da Features".
3. A cikin uninstall da canza shirye-shirye taga, nemo kuma yi alama a layi "Microsoft Office" (ko "Microsoft Excel"), sannan danna maballin "canji" a cikin taken lissafin.
4. Bayan tabbatar da canje-canje, shirin dawo da taga zai fara. A mafi yawan lokuta, ana iya magance matsalolin da "Mayarda Sauri" (ba tare da haɗawa da hanyar sadarwa ba), saboda haka, barin shi, danna maɓallin "Sake kafa".lura: Zabi na biyu shine "Mayar da hanyar sadarwa" yana buƙatar ƙarin lokaci, kuma ya kamata a zaɓa idan hanyar farko ba ta taimaka ba.
5. Maido da shirye-shiryen da aka haɗa a cikin samfurin da aka zaɓa zai fara "Microsoft Office". Bayan an kammala aikin cikin nasara, yakamata a warware matsalar mashaya.

Kammalawa

Don haka, bai kamata ku damu ba idan ba zato ba tsammani mashaya dabarar ta ɓace daga Excel. Mai yuwuwa an kashe shi a cikin saitunan da ke kan ribbon ko a cikin zaɓuɓɓukan aikace-aikacen. Kuna iya kunna shi da dannawa kaɗan kawai. A lokuta da ba kasafai ba, dole ne ku koma kan hanyar dawo da shirin.