Maye gurbin waƙafi tare da dige a cikin Excel: Hanyoyi 5

Don raba integer da juzu'i na lamba da aka wakilta azaman juzu'i na decimal, ana amfani da halayen rarrabewa na musamman: a cikin ƙasashen Ingilishi ɗigo ne, a cikin sauran kuma yawanci waƙafi ne. Saboda wannan bambance-bambance, masu amfani da Excel galibi suna fuskantar aikin maye gurbin wasu haruffa da waɗanda suke buƙata. Bari mu ga yadda zaku iya canza waƙafi zuwa dige a cikin shirin.

lura: idan aka yi amfani da waƙafi azaman mai rarrabawa, to shirin ba zai karɓi lambobi masu dige-dige a matsayin juzu'i na decimal ba, wanda ke nufin ba za a iya amfani da su cikin ƙididdiga ba. Wannan kuma gaskiya ne ga yanayin baya.

Hanyar 1: Yi amfani da Nemo da Sauya Kayan aiki

Wannan hanya ita ce mafi mashahuri kuma ta ƙunshi amfani da kayan aiki "Nemo kuma Sauya":

1. A kowace hanya mai dacewa, muna zaɓar kewayon sel waɗanda dole ne a maye gurbin duk waƙafi da dige-dige. A cikin babban shigarwar a cikin toshe "Edita" danna gunkin aikin "Nemo kuma zaɓi" kuma a cikin zaɓuɓɓukan da aka tsara mun tsaya a zaɓi - "Maye gurbin". Hakanan zaka iya amfani da gajeriyar hanyar keyboard don ƙaddamar da wannan kayan aiki. Ctrl + H.lura: idan ba ku yi zaɓi ba kafin amfani da kayan aiki, to za a yi bincike da maye gurbin waƙafi tare da lokaci a cikin abubuwan da ke cikin takardar, wanda ba koyaushe ake buƙata ba.
2. Wani ƙaramin taga aiki zai bayyana akan allon. "Nemo kuma Sauya". Ya kamata mu kasance a cikin shafin nan da nan "Maye gurbin" (idan saboda wasu dalilai wannan bai faru ba, muna canza shi da hannu). Anan muna cikin ƙimar siga "Nemo" saka alamar waƙafi don "Maye gurbinsa" – alamar digo. Danna maɓallin lokacin da aka shirya "Maye gurbin Duka"don amfani da kayan aiki zuwa duk zaɓaɓɓun sel.Danna maballin daya "Maye gurbin" zai yi bincike guda ɗaya kuma ya maye gurbin, farawa daga tantanin halitta na farko na kewayon da aka zaɓa, watau za a buƙaci a danna daidai sau da yawa kamar yadda akwai masu maye gurbin bisa ga sigogi da aka bayar.
3. Taga na gaba zai ƙunshi bayani game da adadin masu maye da aka yi.
4. Don haka, ba tare da ƙoƙari sosai ba, mun sami nasarar saka ɗigo maimakon waƙafi a cikin guntun da aka zaɓa na tebur.

Hanyar 2: Yi amfani da aikin "Masanya".

Tare da wannan aikin, zaku iya nema ta atomatik da maye gurbin ɗayan haruffa da wani. Ga abin da muke yi:

1. Muna tashi a cikin tantanin halitta mara komai kusa da wanda ke ɗauke da waƙafi (a cikin layi ɗaya, amma ba lallai ba ne a cikin na gaba). Sannan danna gunkin "Saka aikin" a gefen hagu na mashin dabara.
2. A cikin taga bude Abubuwan da ake sakawa danna kan rukunin yanzu kuma zaɓi "Rubutu" (kuma dace "Cikakken jerin haruffa"). A cikin lissafin da aka tsara, yiwa mai aiki alama "MADAMA", sannan latsa OK.
3. Wani taga zai bayyana wanda a cikinsa kake buƙatar cike mahaɗin aikin:
   • "Rubutu": Ƙayyade nuni ga ainihin tantanin halitta mai ɗauke da waƙafi. Kuna iya yin haka da hannu ta hanyar buga adireshin ta amfani da madannai. Ko, kasancewa a cikin filin don shigar da bayanai, danna kan abin da ake so a cikin tebur kanta.
   • "Tauraro_Text": nan, kamar yadda yake tare da aikin "Nemo kuma Sauya", nuna alamar da za a canza, watau waƙafi (amma wannan lokacin a cikin alamar zance).
   • "Sabon_rubutu": saka alamar digo (a cikin alamun zance).
   • "Lambar shigarwa" ba hujjar da ake bukata ba. A wannan yanayin, bar filin fanko.
   • Kuna iya canzawa tsakanin gardamar aiki ta danna cikin filin da ake so kawai ko amfani da maɓalli tab a kan madannai. Lokacin da komai ya shirya, danna OK.
4. Muna samun bayanan da aka sarrafa a cikin tantanin halitta tare da mai aiki. Don samun sakamako makamancin haka don sauran abubuwan ginshiƙi, yi amfani cika alama. Don yin wannan, shawagi a kan ƙananan kusurwar dama na tantanin halitta tare da aikin. Da zaran mai nuni ya canza zuwa alamar daɗaɗɗen baki (wannan shine Alamar), riže žasa maɓallin linzamin kwamfuta na hagu kuma ja shi zuwa ƙasa ta ƙarshe na ginshiƙi.
5. Ta hanyar sakin maɓallin linzamin kwamfuta, za mu ga sakamakon nan da nan. Ya rage kawai don matsar da sababbin bayanai zuwa cikin tebur, maye gurbin na asali tare da su. Don yin wannan, zaɓi sel tare da dabara (idan an cire zaɓin ba zato ba tsammani), danna-dama akan yankin da aka yiwa alama kuma zaɓi abu a cikin menu na mahallin da ya buɗe. “Kwafa”.Hakanan zaka iya amfani da maɓalli mai kama da ke cikin akwatin kayan aiki "Klipboard" a cikin babban shafin shirin. Ko kawai danna hotkeys Ctrl + C.
6. Yanzu mun zaɓi kewayon sel a cikin tebur ɗin kanta, inda yakamata mu liƙa bayanan da aka kwafi zuwa allo. Danna-dama akan yankin da aka zaɓa, a cikin menu da ke buɗewa "Zaɓuɓɓukan Manna" zaɓi gunkin tare da hoton babban fayil da lambobi 123, - umarni "Saka Dabi'u".lura: Maimakon zaɓar kewayon a cikin tebur mai tushe, kawai kuna iya matsawa zuwa mafi girman tantanin halitta (ko tantanin hagu na sama, idan muna magana ne game da yanki na ginshiƙai da layuka da yawa), farawa daga inda kuke so. manna bayanan da aka kwafi.
7. An maye gurbin duk waƙafi a cikin ginshiƙi da lokaci. Ba mu ƙara buƙatar ginshiƙin taimako, kuma za mu iya cire shi. Don yin wannan, danna kan sunan sa akan madaidaicin madaidaicin madaidaicin tare da maɓallin linzamin kwamfuta na dama kuma a cikin mahallin mahallin da ya buɗe, dakatar da umarnin. "Goge". Lokacin yin aikin, kuna buƙatar tabbatar da cewa babu wani bayanai masu mahimmanci a cikin layuka da ke ƙasan wannan shafi, waɗanda kuma za a goge su.Wata hanyar ita ce share abubuwan da ke cikin sel. Don yin wannan, zaɓi su, kira menu na mahallin ta danna-dama akan su kuma zaɓi umarnin da ya dace a cikin lissafin da ke buɗewa.

Hanyar 3: Daidaita Zaɓuɓɓukan Excel

Bari mu matsa zuwa hanya ta gaba, wanda ya bambanta da waɗanda aka tattauna a sama ta yadda za mu yi ayyuka ba a cikin yanayin aiki na shirin ba (a kan takarda), amma a cikin saitunan.

Ya kamata a lura cewa, a cikin abin da kake son yin maye gurbin, dole ne a zaba a matsayin Lambobi (ko Janar) domin shirin ya fahimci abubuwan da ke cikin su a matsayin lambobi kuma ya yi amfani da ƙayyadaddun saitunan zuwa gare su. Don haka bari mu fara:

1. Je zuwa menu "Fayil".
2. Zaɓi abu daga lissafin hagu "Parameters".
3. A cikin karamin sashe "Ƙari" cire alamar zaɓi "Yi amfani da tsarin separators" (parameter group "Zaɓuɓɓuka Gyara"), bayan haka an kunna kishiyar filin "Integer and fraction separator", wanda muke nuna alamar "point" kuma danna OK.
4. Don haka, za a maye gurbin waƙafi da dige-dige a cikin duk sel masu ɗauke da ƙimar lambobi. Za a yi aikin a cikin dukan littafin aikin, ba kawai a kan wannan takardar ba.

Hanyar 4: Yi amfani da Macro na Musamman

Ba za a iya kiran wannan hanya mai shahara ba, duk da haka, akwai, don haka za mu kwatanta shi.

Don farawa, muna buƙatar yin shiri na farko, wato, kunna yanayin developer (kashe ta tsohuwa). Don yin wannan, a cikin sigogin shirye-shiryen a cikin ƙaramin sashe "Kwasta Ribbon" a gefen dama na taga, duba akwatin kusa da abu "Developer". Tabbatar da canje-canje ta latsa maɓallin OK.

Yanzu bari mu gangara kan babban aikinmu:

1. Juyawa zuwa shafin da ya bayyana "Developer" danna gunkin gefen hagu na ribbon "Visual Basic" (rukunin kayan aiki "kodi na").
2. Taga zai bayyana akan allon. Editan Microsoft VB. A gefen hagu, danna sau biyu akan kowane takarda ko littafi. A cikin filin da yake buɗewa, liƙa lambar ƙasa kuma rufe editan.

   Sub Макрос_замены_запятой_на_точку()

   Zabi.Maye gurbin Me:=",", Sauyawa:=".", LookAt:=xlPart, _

   SearchOrder: = xlByRows, MatchCase: = Ƙarya, Tsarin Bincike: = Ƙarya, _

   Sauya Tsarin: = Ƙarya

   karshen Sub

3. Muna zaɓar sel ɗin da ke cikin abubuwan da kuke so ku canza su. Sannan danna gunkin "Macro".
4. A cikin taga da ya bayyana, yiwa macro alama kuma tabbatar da aiwatar da umarnin ta latsa maɓallin da ya dace. Lura cewa ba za a iya soke wannan aikin ba.
5. Sakamakon haka, duk waƙafi a cikin sel da aka zaɓa za a maye gurbinsu da dige-dige.

lura: Wannan hanya tana aiki ne kawai idan an yi amfani da batu azaman mai raba adadi a cikin shirin, watau zaɓi "Yi amfani da tsarin separators" (wanda aka tattauna a sama) ba shi da rauni.

Hanyar 5: Canja saitunan tsarin kwamfuta

Bari mu gama ta hanyar da ta ƙunshi yin canje-canje ga saitunan tsarin aiki da kanta (bari mu kalli misalin Windows 10).

1. Run Control panel (misali, ta hanyar layi search).
2. A cikin yanayin gani "Ƙananan/manyan gumaka" danna applet "Ka'idojin Yanki".
3. A cikin taga da ya buɗe, za mu sami kanmu a cikin shafin "Tsara"wanda muke danna maballin "Ƙarin zaɓuɓɓuka".
4. A cikin taga na gaba a cikin shafin "Lambobi" za mu iya ƙayyade halayen ƙayyadaddun da muke so mu saita a matsayin tsoho don tsarin da kuma shirin Excel musamman. A wajenmu, wannan batu ne. Danna lokacin da aka shirya OK.
5. Bayan haka, duk waƙafi a cikin sel na tebur waɗanda ke ɗauke da bayanan lamba (tare da tsari - Lambobi or Janar) za a maye gurbinsu da dige-dige.

Kammalawa

Don haka, akwai hanyoyi da yawa a cikin Excel waɗanda zaku iya amfani da su don maye gurbin waƙafi tare da lokaci a cikin sel tebur. Mafi sau da yawa, wannan shine amfani da kayan aiki Nemo da Sauya, da kuma aikin SAUKI. Ana buƙatar wasu hanyoyin a lokuta na musamman kuma ana amfani da su da ƙasa akai-akai.