Hanyoyi 5 don Sauya Waƙafi tare da Digi a cikin Excel

A cikin aikin shirin Excel, komai yana aiki daidai da ka'idoji da ayyuka da aka tsara. Ko da saboda digo ɗaya ko waƙafi, duk ajiyar ajiyar na iya gazawa. Kuma wannan yana nufin cewa zai zama da amfani ga kowane mai amfani da shirin ya koyi yadda ake sauri gano kuskuren da kuma gyara shi.

Hanyar sauyawa

A cikin sigar Excel, ana amfani da waƙafi don nuna juzu'i na goma, amma a cikin shirin Ingilishi, ana amfani da ɗigo. Sau da yawa wannan kuskure yana faruwa saboda aiki da harsuna biyu ko kuma saboda rashin ilimi.

Da farko, yana da kyau a yanke shawarar dalilan da ya sa ya zama dole don maye gurbin waƙafi tare da digo. A wasu lokuta, wannan yana faruwa saboda mafi kyawun nunin gani fiye da buƙatun aiki. Amma idan buƙatar ƙididdige abin da ake buƙata na maye gurbin, to, zaɓin hanyar maye gurbin waƙafi tare da dige ya kamata a ɗauka da mahimmanci. Dangane da manufar maye gurbin, hanyar za ta bambanta.

Hanyar 1: Yi amfani da Nemo da Sauya Kayan aiki

Ɗaya daga cikin mafi sauƙi kuma sanannun hanyoyin maye gurbin waƙafi tare da digo shine amfani da kayan aiki mai suna Nemo da Sauya. Abin takaici, wannan hanyar ba ta dace da ɓangarorin aiki ba. Lokacin maye gurbin waƙafi da digo ta amfani da wannan hanya, ƙimar tantanin halitta za a rikiɗa zuwa tsarin rubutu. Yi la'akari da tsarin Nemo da Sauya hanyar:

1. Muna zaɓar takamaiman kewayon sel waɗanda ke buƙatar maye gurbinsu. Lokacin da ka danna dama akan yankin da aka zaɓa, menu yana buɗewa. Anan za mu zaɓi abu mai suna "Format Cells". Ana iya kiran wannan aikin ta hanyar gajeriyar hanyar keyboard Ctrl+1.
2. Lokacin da aka kunna "Format Cells", taga mai tsarawa yana buɗewa. A cikin sigar "Lambar", zaɓi ma'aunin "Text". Don ajiye canje-canjen da aka yi, tabbatar da danna "Ok". Idan kawai ka rufe taga tsarawa, to duk canje-canje za su rasa tasirin su.
3. Mu ci gaba zuwa mataki na gaba. Kuma, zaɓi adadin da ake buƙata na sel. A cikin aiki shafin "Gida" muna samun toshe ayyuka "Editing", zaɓi "Nemo kuma zaɓi". A cikin menu wanda ya bayyana bayan wannan, zaɓin "Maye gurbin" ya kamata a kunna.

4. Bayan haka, taga mai suna "Find and Replace" yana buɗewa don cike sigogin "Nemo" guda biyu - an shigar da haruffa, kalma ko lamba, kuma a cikin "Maye gurbin da" ya kamata ku ƙayyade hali, kalma ko lambar da za a maye gurbinsu. sanya. Don haka, a cikin layin "Nemo" za a sami "," alama, kuma a cikin layin "Maye gurbin da" - ".".
5. Bayan cika sigogi, danna "Maye gurbin Duk". Bayan haka, ƙaramin saƙo zai bayyana game da adadin maye gurbin da aka yi. Danna "Ok".

Wannan hanyar tana ba ku damar maye gurbin duk waƙafi tare da lokaci a cikin yankin da aka zaɓa na sel. Hanyar yana da sauƙi da sauri. Rashin lahani na wannan hanyar shine maye gurbin tsarin tare da rubutu daya, wanda ke cire duk wani ƙarin ƙididdiga.

Hanyar 2: Yi amfani da Ayyukan MUSA

Hanyar ta dogara ne akan amfani da aikin da ya dace na wannan sunan. Lokacin zabar wannan hanyar, ya zama dole a canza bayanan tantanin halitta, sannan a kwafa su a liƙa a madadin ainihin bayanan.

1. Ta zaɓar tantanin halitta mara komai, kusa da tantanin halitta wanda ke iya canzawa. Kunna "Saka aikin" - alamar a cikin layin ayyuka "fx".
2. A cikin taga wanda ya bayyana tare da ayyukan da ake da su, mun sami sashin "Text". Zaɓi tsarin da ake kira "Masanya" kuma ajiye zaɓi ta danna maɓallin "Ok".

3. Taga yana bayyana don cika sigogin da ake buƙata - "Text", "Tsohon rubutu" da "Sabon rubutu". Ma'aunin "Text" ya ƙunshi shigar da adireshin tantanin halitta tare da ainihin ƙimar. Layin “Tsohon rubutu” an yi nufin nuna halin da za a maye gurbinsa, wato, “,” kuma a cikin ma’aunin “Sabon rubutu” mun shigar da “.” Lokacin da aka cika duk sigogi, danna Ok. Mai zuwa zai bayyana a cikin tantanin halitta mai aiki: = MUSAM (C4; ","; ".").

4. Sakamakon haka, ana canza ƙimar tantanin halitta cikin nasara. Ya kamata a maimaita waɗannan magudin don duk sauran sel.
5. Wannan hanya kuma tana da babban hasara. Idan kawai 'yan dabi'u ne kawai za a maye gurbinsu, to maimaita matakan ba zai dauki lokaci mai yawa ba. Amma menene idan kuna buƙatar canza manyan bayanai masu yawa. Zaka iya, misali, amfani da alamar cika tantanin halitta.
6. Don aiwatar da wannan abu, dole ne ka saita siginan kwamfuta zuwa kusurwar dama ta ƙasa na tantanin halitta mai aiki tare da aikin da aka riga aka shigar. A wannan yanayin, giciye zai bayyana - abin da ake kira alamar cikawa. Ta danna maɓallin linzamin kwamfuta na hagu, ya kamata ka ja wannan giciye tare da ginshiƙi tare da ƙimar da ake buƙatar canzawa.
7. Sakamakon haka, an riga an canza dabi'u za su bayyana a cikin ginshiƙi da aka zaɓa - maimakon waƙafi a cikin juzu'i na ƙima, yanzu akwai dige. Yanzu kuna buƙatar kwafi da canja wurin duk abubuwan da aka canza canjin zuwa sel na ainihin lambobin. Hana sel da aka canza. Danna maɓallin "Copy" a cikin shafin "Babban".
8. Lokacin da ka danna linzamin kwamfuta dama a kan sel da aka zaɓa, menu yana bayyana tare da nau'in "Zaɓuɓɓukan Manna", nemo kuma zaɓi sigar "Dabi'u". A tsari, ana nuna wannan abu azaman maɓalli "123".
9. Za a matsar da ƙimar da aka canza zuwa sel masu dacewa. Don cire ƙimar da ba dole ba a cikin menu iri ɗaya, zaɓi nau'in "Clear contents".

Don haka, an aiwatar da maye gurbin waƙafi na wasu lokuta a cikin kewayon ƙimar da aka zaɓa, kuma an cire ƙimar da ba dole ba.

Hanyar 3: Daidaita Zaɓuɓɓukan Excel

Ta hanyar daidaita wasu sigogi na shirin Excel, zaku iya cimma maye gurbin alamar "," tare da "." A wannan yanayin, tsarin sel zai kasance mai lamba, kuma ba zai canza zuwa rubutu ba.

1. Ta hanyar kunna shafin "Fayil", zaɓi toshe "Zaɓuɓɓuka".
2. Ya kamata ku je sashin "Babba" kuma ku nemo "Zaɓuɓɓukan Gyara". Cire alamar akwatin kusa da ma'aunin "Yi amfani da masu raba tsarin". A cikin layin "Masu raba lamba da sassan sassa" muna canza ɗigon, wanda shine ta tsohuwa, zuwa waƙafi.

Bayan canje-canjen da aka yi a cikin saitunan shirye-shiryen Excel, mai iyakance don nuna juzu'i yanzu lokaci ne.

Hanyar 4: Yi amfani da Macro na Musamman

Wata hanyar maye gurbin semicolons a cikin Excel ta ƙunshi amfani da macro. Amma kafin amfani da su, ya kamata ka yi la'akari da gaskiyar cewa macros suna kashe ta tsohuwa a cikin shirin. Don haka, don farawa, kuna buƙatar kunna shafin “Developer” kuma kunna macros.

Ana kunna yanayin "Developer" ta hanyar saitunan shirin. A cikin sashin da ake kira "Customize the ribbon", sannan a cikin rukunin "Main tabs" mun sami abu "Developer", a gabansa mun sanya alamar. Ana kunna saitunan bayan danna maɓallin "Ok".

1. Tab "Developer" → toshe "Code", danna maɓallin da ake kira "Visual Basic".
2. Tagan editan macro zai buɗe. A cikin wannan taga, kuna buƙatar shigar da lambar shirin mai zuwa:

A wannan mataki, muna kammala aikin a cikin edita ta hanyar rufe taga editan kawai.

3. Zaɓi sel waɗanda za a yi canje-canje a cikinsu. Latsa maɓallin "Macros", wanda ke cikin akwatin kayan aiki.
4. Taga yana bayyana yana nuna macro da ke akwai. Zaɓi sabon macro da aka ƙirƙira. Tare da macro da aka zaɓa, danna "Run" don kunna shi.

5. Ana yin maye gurbin - ɗigogi sun bayyana maimakon waƙafi.

Yin amfani da wannan hanyar yana buƙatar kulawa ta musamman. Bayan kunna macro, ba zai yiwu a dawo da komai ba. Lokacin zabar sel masu wasu ƙima, kuna buƙatar tabbatar da cewa za a yi canje-canje ga waɗannan bayanan da suke buƙatar gaske kawai.

Hanyar 5: Canja saitunan tsarin kwamfuta

Wannan hanyar ba ta zama gama gari ba, duk da haka, ana kuma amfani da ita don maye gurbin waƙafi tare da lokuta lokacin yin ƙididdigewa a cikin takaddun Excel. Za mu canza saitunan kai tsaye a cikin software. Yi la'akari da wannan tsari ta amfani da misalin Windows 10 Pro software.

1. Muna zuwa "Control Panel", wanda za a iya kira ta hanyar "Fara".

2. A cikin "Lokaci da Harshe", zaɓi zaɓi "Yanki".
3. Bayan haka, taga zai buɗe. Anan muna kunna "Ƙarin zaɓuɓɓuka don kwanan wata, lokaci, yanki".

4. Wani sabon taga zai buɗe, wanda a ciki za mu je "Ka'idodin Yanki".

5. Yanzu je zuwa shafin "Formats" kuma a kasa na taga kunna "Advanced zažužžukan ...".

6. Na gaba, a cikin nau'in "Lambobi", ƙididdige halayen da ake buƙata a cikin layin "Masu raba lamba da sassa." Bayan yin canje-canje, danna "Ok".

Sakamakon aikinmu, waƙafi a cikin sassan sel-kwayoyin tebur na Excel da ke cike da ƙimar lambobi za a canza su ta atomatik zuwa lokaci. A wannan yanayin, tsarin tantanin halitta ba shi da mahimmanci, ko "Gabaɗaya" ko "Lambobi".

Muhimmin! Lokacin canja wurin fayil zuwa wata kwamfuta tare da daidaitattun saituna, matsaloli tare da tsarin lissafi na iya faruwa.

Ƙarin Hanyar: Sauya ɗigo tare da waƙafi a cikin Excel ta amfani da Notepad

Software na Windows yana da shirin Notepad wanda ke aiki akan mafi ƙarancin adadin ayyuka da saituna. "Notepad" za a iya amfani da shi azaman mai shiga tsakani don kwafi, samfoti da bayanai.

1. Kuna buƙatar zaɓar kewayon sel da ake so kuma ku kwafi shi. Buɗe Notepad kuma liƙa ƙimar da aka kwafi a cikin taga da ke buɗewa.

2. A cikin "Edit" tab, zaɓi "Maye gurbin" category. A matsayin maɓallan zafi, ana amfani da haɗin "CTRL + H". Wani taga yana bayyana wanda muke cika filayen. A cikin layin "Menene" shigar da ",", a cikin layin "Menene" - "." Lokacin da filayen suka cika, danna "Maye gurbin Duk".

Bayan waɗannan magudin a cikin rubutun da aka saka, duk waƙafi an canza su zuwa lokaci. Yanzu ya rage kawai don kwafin ƙimar juzu'i da aka canza uXNUMXbuXNUMXbagain kuma liƙa su cikin tebur na takaddar Excel.

Kammalawa

Labarin ya bincika mafi inganci kuma shahararrun hanyoyin maye gurbin haruffan waƙafi a cikin juzu'i na decimal tare da dige a cikin maƙunsar bayanai na Excel. Mafi sau da yawa, masu amfani sun fi son ginanniyar Nemo da Sauya kayan aiki don kyan gani na ƙimar ƙima, kuma ana amfani da aikin SUBSTITUTE don yin lissafi.