Shafin Farko na Microsoft Excel

Lokacin da kake buga takardu daban-daban, zaka iya yin typo ko kuskure daga jahilci. Bugu da ƙari, wasu haruffa a kan keyboard ba su nan ba, amma ba kowa san yadda za a yi amfani da haruffa na musamman, da kuma yadda za a yi amfani da su ba. Saboda haka, masu amfani suna maye gurbin waɗannan alamu tare da mafi bayyane, a ra'ayi, analogues. Alal misali, maimakon "©" sun rubuta "(c)", kuma maimakon "€" - (e). Abin farin ciki, Microsoft Excel na da aikin AutoCorrect wanda ya maye gurbin samfurori na sama tare da matakan da ya dace, kuma ya gyara ƙananan kurakurai da rikici.

Ka'idojin AutoCorrect

Shirye-shiryen ƙwaƙwalwar Excel yana ɓoye kuskuren mafi yawan na rubutun kalmomi. Kowane irin kalma daidai yake da daidaitaccen wasa. Idan mai amfani ya shiga zabin ba daidai ba, saboda typo ko kuskure, to an yi amfani da aikace-aikacen ta atomatik tare da madaidaicin. Wannan shi ne ainihin ma'anar haɓaka.

Babban kuskuren da wannan gyare-gyare na aikin sun haɗa da haka: farkon jumla tare da wasikar ƙananan, haruffa biyu a cikin kalma a jere, ɓataccen layout Makullin caps, da dama wasu zane-zane da kurakurai.

Kashe kuma kunna AutoCorrect

Ya kamata a lura da cewa ta hanyar tsoho, An kunna AutoCore daidai. Sabili da haka, idan kullun ko dan lokaci bazai buƙatar wannan aikin ba, to, ya kamata a tilasta masa ƙarfi. Alal misali, wannan zai iya haifar da gaskiyar cewa sau da yawa kuna da gangan rubuta kalmomi tare da kurakurai, ko nuna haruffan da aka nuna Excel a matsayin ɓarna, kuma maye gurbin takalma akai-akai yana gyara su. Idan ka canza alamar da aka yi ta hanyar yin gyare-gyare zuwa wanda kake buƙatar, to ba'a sake gyarawa ba. Amma, idan akwai irin wannan shigarwar, to rubuta shi sau biyu, ka rasa lokaci. A wannan yanayin, ya fi dacewa don ƙuntata lokaci na atomatik ba daidai ba.

  1. Jeka shafin "Fayil";
  2. Zaɓi wani ɓangare "Zabuka".
  3. Na gaba, je zuwa kasan "Ƙamus".
  4. Danna maballin "Zaɓuɓɓukan Ajiyayyen AutoCorrect".
  5. A cikin matakan sigogi wanda ya buɗe, nemi abu "Sauyawa kamar yadda kake rubuta". Bude shi kuma danna maballin. "Ok".

Domin sake kunna AutoCorrect, bi da bi, duba akwatin kuma latsa maɓallin kuma. "Ok".

Matsala tare da kwanan wata

Akwai lokuta idan mai amfani ya shiga lamba tare da dige, kuma an gyara ta atomatik a kwanan wata, ko da yake bai buƙatar shi ba. A wannan yanayin, ba dole ba ne a cire musanyawa gaba daya. Don gyara wannan, zaɓi sashen sel wanda zamu rubuta lambobi tare da dige. A cikin shafin "Gida" Muna neman tsari na saitunan "Lambar". A cikin jerin layi da ke cikin wannan toshe, saita saitin "Rubutu".

Yanzu lambobi tare da dige ba za'a maye gurbinsu tare da kwanakin.

Shirya jerin abubuwan da ba daidai ba

Amma duk da haka, babban aikin wannan kayan aiki ba don tsoma baki tare da mai amfani ba, amma don taimaka masa. Bugu da ƙari, jerin jerin maganganun da aka tsara domin ƙwaƙwalwar ajiya ta hanyar tsoho, kowane mai amfani zai iya ƙara ƙauyukansu.

  1. Bude taga na sigogi Na'urar da ba a taɓa sani ba a gare mu.
  2. A cikin filin "Sauya" saka jerin halayen da za a gane ta hanyar shirin a matsayin kuskure. A cikin filin "A" Mun rubuta kalma ko alama don a maye gurbin. Muna danna maɓallin "Ƙara".

Saboda haka, zaka iya ƙara zaɓuɓɓukanka zuwa ƙamus.

Bugu da kari, a wannan taga akwai shafin "Alamomin Lissafi na Ƙarshe na Kai". A nan ne jerin dabi'u yayin da ake maye gurbin tare da alamomin lissafi, ciki har da wadanda aka yi amfani da su a cikin takaddun Excel. Lalle ne, ba kowane mai amfani zai iya shiga harafin alpha (alpha) a kan keyboard, amma kowa da kowa zai iya shigar da " alpha" darajar, wanda aka canza ta atomatik zuwa halin da aka so. Ta hanyar misali, beta ( beta), da sauran alamu an rubuta. A cikin wannan jerin, kowane mai amfani zai iya ƙara matakan da suka dace, kamar yadda aka nuna a cikin ƙamus.

Har ila yau, yana da sauƙi don cire duk wani rubutu a wannan ƙamus. Zaɓi abu don wanda ba mu buƙatar sauyawa na atomatik, kuma latsa maballin "Share".

Share za a yi nan take.

Basic sigogi

A cikin maɓallin tabbacin hanyoyin ƙaddamarwa akwai saitunan da ke cikin wannan aikin. Ta hanyar tsoho, ayyuka masu zuwa suna haɗawa: gyara manyan haruffa guda biyu a jere, saita harafin farko a cikin jumla na sama, sunaye na kwanakin mako tare da harafin harafi na sama, gyarawa ta latsa latsawa Makullin caps. Amma, duk waɗannan ayyuka, da kuma wasu daga cikinsu, za a iya kashe su ta hanyar saukewa da daidaitattun zaɓuɓɓuka kuma latsa maballin. "Ok".

Ban da

Bugu da ƙari, siffar AutoCorrect tana da ƙamus na kamfanoni. Ya ƙunshi waɗannan kalmomi da alamomin da ba za a maye gurbin su ba, koda kuwa ana bin doka a cikin saitunan gaba, wanda ke nufin cewa an ba da kalmar ko magana a maye gurbin.

Don zuwa wannan ƙamus ya danna maballin. "Banda ...".

Gidan da aka cire ya buɗe. Kamar yadda kake gani, tana da shafuka biyu. A cikin su na farko akwai kalmomi, bayan haka dot ba ya nufin ƙarshen jumla, kuma gaskiyar cewa kalma ta gaba dole ne ta fara da babban harafi. Wadannan su ne ƙananan raguwa (alal misali, "Rub."), ​​Ko kuma ɓangarorin maganganu masu mahimmanci.

Shafin na biyu ya ƙunshi ƙyama, wanda ba buƙatar ka maye gurbin manyan haruffa biyu a jere. Ta hanyar tsoho, kalma daya da aka gabatar a cikin wannan ɓangaren ƙamus yana "CCleaner". Amma, zaka iya ƙara yawan wasu kalmomin da maganganu marasa mahimmanci, a matsayin ƙyalle ga canzawa, kamar yadda aka tattauna a sama.

Kamar yadda kake gani, AutoCorrect abu ne mai matukar dacewa wanda zai taimaka wajen gyara kurakurai ta atomatik ko kurakuran rubutu da aka sanya lokacin shigar da kalmomi, alamomi ko maganganu a Excel. Lokacin da aka daidaita shi, wannan aiki zai zama mai taimako mai kyau, kuma zai bada damar adana lokaci a kan dubawa da kuma gyara kurakurai.