Akwai yanayi lokacin da rubutu ko allunan da aka buga a cikin Microsoft Word suke buƙatar jujjuya su zuwa Excel. Abin baƙin ciki Magana ba ta samar da kayan aikin ginannun kayan aikin ba. Amma, a lokaci guda, akwai hanyoyi da yawa don sauya fayiloli a cikin wannan shugabanci. Bari mu bincika yadda ake yin wannan.
Hanyoyin Musanyawa na asali
Akwai manyan hanyoyi guda uku da za a iya sauya fayilolin Kalma zuwa Excel:
- kwafin bayanai mai sauƙi;
- yin amfani da aikace-aikace na musamman na ɓangare na uku;
- amfani da sabis na kan layi na musamman.
Hanyar 1: bayanan kwafi
Idan kawai kwafar bayanai daga takaddar kalma zuwa kalma ta Excel, abubuwan da ke cikin sabon takaddar ba za su yi kyau sosai ba. Kowane sakin layi za'a sanya shi a cikin sel daban. Sabili da haka, bayan da aka kwafa rubutun, kuna buƙatar aiki akan ainihin tsarin sa a kan takardar aikin Excel. Wani batun daban shine kwafin allunan.
- Zaɓi rubutun da ake so ko duk rubutun a cikin Microsoft Word. Mun danna-dama, wanda ya kawo menu na mahallin. Zaɓi abu Kwafa. Madadin yin amfani da menu na mahallin, bayan zabar rubutu, zaku iya danna maballin Kwafawanda aka sanya a cikin shafin "Gida" a cikin akwatin kayan aiki Clipboard. Wani zaɓi kuma zaɓi zaɓi haɗin maɓallan akan maballin bayan zaɓin rubutu Ctrl + C.
- Bude aikin Microsoft Excel. Mun danna kusan wannan wurin akan takarda inda zamu shigar da rubutun. Danna-dama akan menu na mahallin. A ciki, cikin "Zaɓuɓɓukan Saka", zaɓi ƙimar "Ajiye Tsarin Tsararren".
Hakanan, maimakon waɗannan ayyukan, zaku iya danna maballin Manna, wanda yake a gefen hagu na gefen tef. Wani zabin shine danna maɓallin kewayawa na Ctrl + V.
Kamar yadda kake gani, an saka rubutu, amma, kamar yadda aka ambata a sama, yana da bayyanar da ba za a iya bayyanawa ba.
Domin shi ya dauki hanyar da muke buƙata, muna faɗaɗa sel zuwa faɗin da ake buƙata. Idan ya cancanta, a ƙari kuma shirya shi.
Hanyar 2: Yin Bayani Na Ci Gaba
Akwai wata hanyar sauya bayanai daga Kalma zuwa Excel. Tabbas, yana da rikitarwa sosai fiye da sigar da ta gabata, amma a lokaci guda, irin wannan canja wuri yafi dacewa.
- Bude fayil a cikin Kalma. Kasancewa a cikin shafin "Gida"danna alamar "Nuna duk haruffa", wanda yake akan haƙarƙan kwalin sakin layi. Madadin waɗannan ayyuka, zaka iya danna maɓallin maɓalli Ctrl + *.
- Alamar ta musamman zata bayyana. A ƙarshen kowane sakin layi alama ce. Yana da mahimmanci a waƙa cewa babu madaidaicin sakin layi, in ba haka ba sauyawar ba daidai bane. Irin waɗannan sakin layi ya kamata a share su.
- Je zuwa shafin Fayiloli.
- Zaɓi abu Ajiye As.
- Fayil na ajiye fayil yana buɗewa. A cikin siga Nau'in fayil zaɓi darajar Rubutun rubutu. Latsa maballin Ajiye.
- A cikin taga juyawa wanda yake buɗewa, baku buƙatar yin canje-canje. Kawai danna maɓallin "Ok".
- Bude shirin Excel a cikin shafin Fayiloli. Zaɓi abu "Bude".
- A cikin taga "Bude daftarin aiki" a cikin fayilolin fayiloli da aka buɗe, saita darajar "Duk fayiloli". Zaɓi fayil ɗin da aka adana a baya cikin Kalma, azaman bayyanai. Latsa maballin "Bude".
- Wajan shigo da Rubutun yana buɗe. Tace tsarin data An ware. Latsa maballin "Gaba".
- A cikin siga "Halin raba kayan shine" nuna darajar Takaice. Cire duk sauran abubuwa idan akwai. Latsa maballin "Gaba".
- A taga na karshe, zabi tsarin data. Idan kana da rubutu mara kyau, ana bada shawara don zaɓar tsari "Janar" (saita ta tsohuwa) ko "Rubutu". Latsa maballin Anyi.
- Kamar yadda kake gani, yanzu kowane sakin layi an saka shi a cikin sel daban, kamar yadda yake a hanyar da ta gabata, amma a kan layi daban. Yanzu kuna buƙatar fadada waɗannan layin domin kada kalmomin mutum su rasa. Bayan haka, zaku iya tsara sel a yadda kuke so.
Game da tsari iri ɗaya, zaku iya kwafin tebur daga Kalma zuwa Excel. An bayyana yanayin wannan hanyar a cikin wani darasi na daban.
Darasi: yadda ake saka tebur daga Magana zuwa Excel
Hanyar 3: yi amfani da aikace-aikacen juyawa
Wata hanyar sauya takardu na Word zuwa Excel shine amfani da aikace-aikace na musamman don sauya bayanai. Ofayan mafi dacewa daga cikinsu shine shirin Abex Excel zuwa Word Converter.
- Bude kayan aiki. Latsa maballin "Sanya fayiloli".
- A cikin taga da ke buɗe, zaɓi fayil ɗin da za a juya. Latsa maballin "Bude".
- A toshe "Zaɓi tsarin fitarwa" zabi daya daga cikin siffofin Excel guda uku:
- xls;
- xlsx;
- xlsm.
- A cikin toshe saitin "Saitin fitarwa" zabi wurin da za'a canza fayil din.
- Lokacin da aka nuna duk saitunan, danna maballin "Maida".
Bayan wannan, ana jujjuyawar hanya. Yanzu zaku iya buɗe fayil ɗin a cikin Excel, kuma ci gaba da aiki tare da shi.
Hanyar 4: Maimaita Amfani da Ayyukan kan layi
Idan baku son shigar da ƙarin software a PC ɗinku ba, zaku iya amfani da sabis na kan layi na musamman don sauya fayiloli. Ofayan mafi sauƙin sauyawa akan layi akan kwatance na Kalmar - Excel ita ce hanya mai jujjuyawa.
Mai sauya layi akan layi
- Mun je gidan yanar gizo na Convertio kuma muna za thei fayiloli don juyawa. Ana iya yin wannan ta hanyoyi masu zuwa:
- Zaɓi daga kwamfuta;
- Ja daga taga Windows Explorer bude;
- Saukewa daga Dropbox;
- Zazzage daga Google Drive;
- Zazzage daga hanyar haɗin yanar gizon.
- Bayan an loda fayil ɗin tushen zuwa shafin, zaɓi tsarin adana. Don yin wannan, danna jerin zaɓi ƙasa zuwa hagu na rubutun "An shirya". Je zuwa nuna "Rubutun takardu", sannan zaɓi zaɓi na xls ko xlsx.
- Latsa maballin Canza.
- Bayan an gama juyawar, danna maballin Zazzagewa.
Bayan haka, za a saukar da daftarin cikin tsarin Excel zuwa kwamfutarka.
Kamar yadda kake gani, akwai hanyoyi da yawa don sauya fayilolin Kalma zuwa Excel. Lokacin amfani da tsare-tsare na musamman ko masu sauyawa akan layi, canjin yana faruwa a cikin kaɗan. A lokaci guda, yin kwafin manual, kodayake yana ɗaukar tsawon lokaci, amma yana ba ku damar tsara fayil ɗin daidai gwargwadon buƙata gwargwadon bukatunku.
