Kunna, kashe, da kuma saita AutoCorrect a cikin Excel

Yayin aiki a cikin maƙunsar bayanai na Excel, musamman ma lokacin da za ku yi hulɗa da adadi mai yawa na bayanai, akwai yuwuwar yin kuskure, kamar typo. Har ila yau, wasu masu amfani, saboda gaskiyar cewa ba su san yadda za a samu da kuma amfani da haruffa na musamman ba, sun yanke shawarar maye gurbin su da waɗanda za a iya fahimta da su. Misali, maimakon alamar "- – na kowa harafi "Da", ko a maimakon haka "$" Ba - a sauƙaƙe "S". Duk da haka, godiya ga kayan aiki na musamman "AutoCorrect" ana gyara irin waɗannan abubuwa kai tsaye.

Menene AutoCorrect

Excel yana adana a cikin ƙwaƙwalwar ajiyarsa jerin kurakurai na yau da kullun waɗanda za a iya yi. Lokacin da mai amfani ya shigar da kuskure daga wannan jerin, shirin zai maye gurbinsa ta atomatik tare da ƙimar daidai. Wannan shi ne ainihin abin da ake bukata Ba daidai ba, kuma haka yake aiki.

Wannan kayan aikin yana gyara manyan nau'ikan kurakurai masu zuwa:

• manyan haruffa guda biyu a jere a cikin kalma
• fara sabon jimla da ƙaramin harafi
• kurakurai saboda kunnan Kulle Caps
• sauran nau'ikan rubutu da kurakurai

Kunna kuma kashe gyara ta atomatik

A cikin shirin, an fara kunna wannan aikin, amma a wasu lokuta ana buƙatar kashe shi (na dindindin ko na ɗan lokaci). Bari mu ce muna bukatar mu yi kuskure musamman a wasu kalmomi ko kuma mu yi amfani da haruffan da shirin ya gane a matsayin kuskure kuma ya maye gurbinsu, ko da yake ba ma son hakan. Idan ka canza halin da ya gyara kai tsaye zuwa wanda muke buƙata, aikin ba zai sake yin canjin ba. Wannan hanyar tabbas ta dace da keɓance lokuta. In ba haka ba, don adana lokaci da ƙoƙari, mafi kyawun bayani shine kashe aikin "AutoCorrect".

1. Je zuwa menu "Fayil".
2. A cikin menu na gefen hagu, je zuwa "Parameters".
3. A cikin taga saitunan da ke buɗewa, danna kan ƙaramin sashe "Fassara". A gefen dama na taga, danna maɓallin "Zaɓuɓɓukan Gyara ta atomatik".
4. Za a nuna taga mai saitunan ayyuka akan allon. Cire alamar akwatin kusa da zaɓi "Maye gurbin kamar yadda kake bugawa", sannan danna OK.
5. Shirin zai dawo da mu zuwa babban taga tare da sigogi, inda muka sake danna maɓallin OK.

lura: don sake kunna aikin, mayar da alamar bincike zuwa wurinsa, bayan haka, kuma, ajiye canje-canje ta danna maɓallin OK.

Kwanan wata gyara ta atomatik da matsaloli masu yiwuwa

Wani lokaci yakan faru yayin shigar da lamba tare da ɗigogi, shirin yana gyara ta don kwanan wata. A ce mun shigar da lamba 3.19 zuwa wani fanko cell.

Bayan mun danna maɓallin Shigar, Samu bayanai a cikin nau'in wata da shekara.

Muna buƙatar adana ainihin bayanan da muka shigar a cikin tantanin halitta. A irin waɗannan yanayi, babu buƙatar kashe gyara ta atomatik. Ga abin da muke yi:

1. Da farko, zaɓi kewayon sel waɗanda muke son ƙara mahimman bayanai a cikin nau'in lambobi tare da dige-dige. Sa'an nan zama a cikin tab "Gida" je zuwa sashin kayan aiki "Lambar", inda muka danna kan zaɓin tsarin salula na yanzu.
2. A cikin jerin zaɓuka, zaɓi abu "Rubutu".
3. Yanzu za mu iya shigar da bayanai cikin aminci cikin sel ta hanyar lambobi masu dige-dige.lura: kana buƙatar tuna cewa lambobi a cikin sel tare da tsarin rubutu ba za su iya shiga cikin ƙididdiga ba, tun da shirin ya gane su ta wata hanya dabam kuma sakamakon ƙarshe zai gurɓata.

Gyara ƙamus ɗin da ya dace

Kamar yadda muka ambata a baya, manufar gyara ta atomatik shine don taimakawa gyara kurakurai ko buga rubutu. Shirin da farko yana ba da daidaitattun jerin kalmomi masu dacewa da alamomi don maye gurbin, duk da haka, mai amfani yana da damar da za a ƙara nasu zabin.

1. Muna sake shiga cikin taga tare da madaidaicin madaidaicin atomatik, jagorancin matakan da aka bayyana a sama (menu "Fayil" - sashe "Parameters" – karamin sashe "Fassara" - maballin "AutoCorrect Options").
2. a cikin "Maye gurbin" muna rubuta wata alama (kalma), wanda shirin zai kara gane shi a matsayin kuskure. A cikin filin "Kan" ƙayyade ƙimar da za a yi amfani da shi azaman madadin. Lokacin da aka shirya, danna maɓallin "Addara".
3. A sakamakon haka, za mu iya ƙara wa wannan ƙamus duk mafi yawan buga rubutu da kurakurai da muke yi (idan ba su cikin jerin asali), don kada mu ɓata lokaci a kan ƙarin gyara.

Maye gurbin atomatik tare da alamun lissafi

Jeka shafin suna iri ɗaya a cikin zaɓuɓɓukan gyara kai tsaye. Anan zamu sami jerin ƙimar da shirin zai maye gurbinsu tare da alamomin lissafi. Wannan zaɓin yana da matuƙar amfani lokacin da kake buƙatar shigar da haruffan da ba a kan madannai ba. Misali, don shigar da hali "α" (alfa), zai isa a buga "Alfa", Bayan haka shirin ya maye gurbin ƙimar da aka bayar tare da halin da ake bukata. Ana shigar da wasu haruffa ta hanya ɗaya.

Hakanan, zaku iya ƙara zaɓuɓɓukanku zuwa wannan jeri.

Cire haɗin haɗin kai daga gyarawa

Don cire haɗin kalmomi ko alamomin da ba dole ba daga lissafin da aka gyara, kawai zaɓi shi tare da danna linzamin kwamfuta, sannan danna maɓallin. "Goge".

Hakanan, ta hanyar haskaka wani wasa, maimakon share shi, zaku iya daidaita ɗaya daga cikin filayensa kawai.

Saita manyan sigogi na maye gurbin atomatik

Babban sigogi sun haɗa da duk saitunan da za a iya yi a cikin shafin "AutoCorrect". Zaɓuɓɓuka masu zuwa an fara kunna su a cikin shirin:

• gyaran manyan haruffa guda biyu a farkon kalma;
• yi girman harafin farko na jimla;
• yin manyan kwanakin mako;
• kawar da kurakuran da aka samu ta hanyar danna maɓallan bazata Kalli Caps.

Don kashe waɗannan zaɓuɓɓuka, kawai cire alamar akwatin da ke kusa da su, sannan danna maɓallin OK domin adana canje-canje.

Yin aiki tare da keɓancewa

Shirin yana da ƙamus na musamman wanda ke adana kalmomi da alamomi waɗanda aka gyara ta atomatik ba za su yi aiki ba, ko da an kunna wannan aikin kuma akwai madaidaicin dacewa a cikin manyan sigogi.

Don samun damar wannan ƙamus, danna maɓallin "Bambanta".

Tagan da ya bayyana yana da shafuka guda biyu:

Harafi na farko

• Ga jerin kalmomi da alamar ta biyo baya "point" (".") bai kamata shirin ya fassara shi a matsayin ƙarshen jimla ba, wanda ke nufin kalma ta gaba za ta fara da ƙaramin harafi. Ainihin, wannan ya shafi kowane nau'i na raguwa, misali, kg., g., rub., dan sanda. da dai sauransu.
• A cikin babban filin, za mu iya shigar da ƙimar mu, wanda za a ƙara zuwa jerin keɓancewa bayan danna maɓallin da ya dace.
• Hakanan, ta zaɓar takamaiman ƙima daga lissafin, zaku iya gyara ko share ta.

Manyan haruffa guda biyu

Ƙimar daga jeri a cikin wannan shafin, kama da jerin da ke cikin shafin "harafin farko", AutoCorrect ba zai shafe shi ba. Anan kuma zamu iya ƙara, gyara ko cire sabbin abubuwa.

Kammalawa

Godiya ga aikin "AutoCorrect" Aiki a cikin Excel yana haɓakawa sosai, saboda shirin yana gyara kuskuren kuskure da mai amfani ta atomatik. Wannan kayan aiki yana da mahimmanci musamman lokacin aiki tare da babban adadin bayanai. Sabili da haka, yana da matukar mahimmanci a irin waɗannan lokuta don samun damar yin amfani da daidai da daidaita sigogin da suka dace.