Yadda ake kunna duban haruffa a cikin Excel

Wadanda suka yi aiki a editan rubutu na MS Word sun ga yadda jajayen layi ke bayyana lokacin da aka yi kuskuren rubuta kalmomi ko kuma aka yi rubutu. Abin takaici, a cikin aikace-aikacen MS Excel, irin wannan aikin ba shi da ƙarancin gaske. A bayyane yake cewa kowane nau'i na gajarta, gajarta da sauran haruffan kalmomi a cikin hanyar da aka gyara na iya batar da shirin, kuma zai ba da sakamakon da ba daidai ba. Duk da wannan, irin wannan aikin yana nan, kuma zaka iya amfani da shi.

Saita tsoho harshe zuwa

Ana kunna gyara ta atomatik na rubutun rubutu da kalmomin da ba daidai ba, amma shirin yana da matsalolin wani tsari na daban. Lokacin duba takardu a yanayin atomatik, a cikin 9 cikin 10, shirin yana mayar da martani ga rubutattun kalmomin Ingilishi da ba daidai ba. Me yasa hakan ke faruwa da kuma yadda za a gyara shi, bari mu yi ƙoƙari mu gano shi:

1. A saman panel, danna maɓallin "File" kuma bi hanyar haɗin "Zaɓuɓɓuka".

2. Zaɓi "Harshe" daga lissafin hagu.
3. The next language settings window has two settings. In the first “Selecting Editing Languages” you can see that is set by default.

Idan, saboda wasu dalilai, kun fi son Ingilishi (Amurka) don yin aiki tare da takardu, to kuna buƙatar yin maye gurbin ta kunna layin tare da zaɓin harshe kuma danna maɓallin "Default" wanda ke haskakawa.

4. Na gaba, mun gangara zuwa abu "Zaɓin harsuna don dubawa da taimako". Anan, ta tsohuwa, kamar yadda kuke gani, an saita ƙirar zuwa harshen Microsoft Windows, kuma don tunani, yaren dubawa.

5. Wajibi ne a yi maye gurbin . Kuna iya yin hakan ta ɗayan hanyoyi masu zuwa: danna kan layin “” kuma danna maɓallin “Default” da ke ƙasa, ko danna maɓallin aiki tare da kibiya ƙasa.
6. Ya rage kawai don yarda ta danna kan "Ok". Taga zai bayyana tare da shawarwarin sake kunna shirin don canje-canje suyi tasiri. Mun yarda kuma mun sake yin aiki a yanayin hannu.

After restarting, the program should automatically make the main language.

Abin da kuke buƙatar kunna rubutu a cikin Excel

Wannan saitin bai ƙare ba, kuma kuna buƙatar yin wasu ƴan matakai:

• A cikin sabon ƙaddamar da aikace-aikacen, sake zuwa "Fayil" kuma buɗe "Zaɓuɓɓuka".
• Na gaba, muna sha'awar kayan aikin Rubutu. Kunna bude taga ta danna kan layin LMB.
• Mun sami layin "AutoCorrect Options ..." kuma danna kan shi LMB.

• Muna zuwa taga wanda ya buɗe, inda kake buƙatar kunna ginshiƙin "AutoCorrect" (a matsayin mai mulkin, yana kunna lokacin buɗe taga).
• A cikin taken "Nuna maɓallan don zaɓuɓɓukan da suka dace" mun sami ayyukan da aka haɗa. Anan, don dacewa da aiki tare da tebur, ana bada shawara don kashe ayyuka da yawa, alal misali, "Yi haruffan farko na jimloli a manyan" da "Rubuta sunayen kwanaki tare da babban harafi".

Bayani daga gwani! Since the language does not provide for writing the days of the week with a capital letter, you can uncheck this line. It is also worth noting that capitalizing the first letters of a sentence does not make sense, since working with tables involves constant abbreviations. If you leave a check mark on this item, then after each point in the abbreviated word, the program will react and correct the misspelled word.

Mun gangara ƙasa kuma mu ga cewa a cikin wannan taga dubawa akwai kuma jerin kalmomin da suka dace. A gefen hagu, ana gabatar da bambance-bambancen kalmomin da ba daidai ba, kuma a dama, zaɓuɓɓukan gyara su. Tabbas, wannan jeri ba za a iya kiransa cikakke ba, amma har yanzu manyan kalmomin da ba a rubuta ba suna nan a cikin wannan jeri.

A saman akwai filayen shigar da kalmomi don bincike. Misali, bari mu rubuta “machine”. Shirin zai ba da shawarar kalma ta atomatik don gyara kai tsaye a filin hagu. A cikin yanayinmu, wannan shine "inji". Hakanan yana yiwuwa kalmar ba za ta kasance a cikin ƙamus ɗin da aka tsara ba. Sannan zaku buƙaci shigar da madaidaicin rubutun da hannu sannan ku danna maɓallin “Ƙara” da ke ƙasa. Wannan yana kammala saitunan, kuma zaku iya ci gaba da ƙaddamar da duban haruffa ta atomatik a cikin Excel.

Gudanar da Mai duba Haruffa ta atomatik

Bayan tattara tebur da yin rikodin duk bayanan da ake buƙata, ya zama dole don duba rubutun rubutun. Don yin wannan, kuna buƙatar aiwatar da jerin ayyuka masu zuwa:

• Idan kana buƙatar duba sashin rubutun kawai, sannan zaɓi wanda yake buƙatar dubawa. In ba haka ba, babu buƙatar haskaka rubutu.
• A saman shirin, nemo kayan aikin Bita.
• Na gaba, a cikin abin “Haruffa”, sami maɓallin “Haruffa” kuma danna kan shi tare da LMB.

• Za a buɗe taga inda za a tambaye ku don ci gaba da duba haruffa daga farkon takardar. Danna maɓallin "Ee".
• Bayan kayan aiki ya sami kalmar da ba daidai ba, akwatin maganganu zai fito tare da kalmar da shirin ke tsammanin an yi kuskure.

• A cikin sashin “Zaɓuɓɓuka”, zaɓi kalmar da ta dace kuma danna “Maye gurbin” idan kalmar nan ɗaya ce kawai a cikin rubutun, ko kuma “Maye gurbin Duka” idan wataƙila kalmar da aka zaɓa ta bayyana sau da yawa.

Bayanan kula daga gwani! Hakanan kula da sauran abubuwan da ke hannun dama. Idan kun tabbata cewa kalmar an rubuta daidai, to kuna buƙatar zaɓar "Tsalle" ko "Tsalle duka". Hakanan, idan kun tabbata cewa kalmar ba ta da kuskure, zaku iya kunna "AutoCorrect". A wannan yanayin, shirin zai canza duk kalmomin da kansa ta atomatik. Akwai ƙarin abu ɗaya "Ƙara zuwa ƙamus". Ya zama dole don ƙara kalmomin da za ku iya yin kuskure sau da yawa.

Kammalawa

No matter how expert in you are, you can never be completely sure of the correctness of the written text. The human factor involves the assumption of various kinds of errors. Especially for this case, MS Excel offers a spell check tool, by running which you can correct misspelled words.