Akwai yanayi lokacin da rubutu ko ɗakunan da aka rubuta a cikin Microsoft Word ya buƙaci a tuba zuwa Excel. Abin takaici, Kalmar bata samar da kayan aikin ginawa don irin wannan canji ba. Amma a lokaci guda, akwai hanyoyi masu yawa don canza fayiloli a cikin wannan hanya. Bari mu gano yadda za ayi wannan.
Hanyar maɓallin tuba
Akwai hanyoyi guda uku don sauya fayilolin Fayil zuwa Excel:
- Daidaitaccen bayanan bayanai;
- amfani da aikace-aikace na musamman na wasu ɓangare na uku;
- amfani da ayyuka na kan layi na musamman.
Hanyar 1: Kwafi Data
Idan ka kawai kwafa bayanai daga Maganar Kalmar zuwa Excel, to, abinda ke cikin sabon takardun ba zai yi kyau sosai ba. Kowane sakin layi zai sanya shi a cikin tantanin salula. Saboda haka, bayan an kwafe rubutun, kana buƙatar yin aiki a kan ainihin tsari na sanya shi a takardar Excel. Tambayar da aka raba shi ne kwashe Tables.
- Zaɓi sashin da ake bukata na rubutu ko dukan rubutu a cikin Microsoft Word. Mun danna maɓallin linzamin linzamin dama, muna kira menu na mahallin. Zaɓi abu "Kwafi". Maimakon yin amfani da menu mahallin, bayan zaɓin rubutu, za ka iya danna maballin "Kwafi"wanda aka sanya a cikin shafin "Gida" a cikin asalin kayan aiki "Rubutun allo". Wani zaɓi shine bayan zaɓin rubutun da ke danna maɓallin haɗin kai a kan keyboard Ctrl + C.
- Bude shirin Microsoft Excel. Muna danna matukar akan wurin a kan takarda inda za mu danna rubutun. Danna dama don linzamin kwamfuta don kiran menu mahallin. A ciki, a cikin "Zaɓuɓɓukan zaɓi" block, zaɓi darajar "Ajiye Asali Tsarin".
Har ila yau, a maimakon waɗannan ayyuka, za ka iya danna kan maballin Mannawanda aka samo a gefen hagu na tef. Wani zaɓi shine don danna maɓallin haɗin Ctrl + V.
Kamar yadda kake gani, an saka rubutu, amma, kamar yadda aka ambata a sama, yana da ra'ayi mara kyau.
Domin ya dauki nau'in da muke buƙatar, muna motsa jikin zuwa buƙatar da ake bukata. Idan ya cancanta, kara tsara shi.
Hanyar 2: Advanced Data Copy
Akwai wata hanya don sauya bayanai daga Kalmar zuwa Excel. Tabbas, yana da mahimmancin rikitarwa fiye da ɓangaren da aka gabata, amma, a lokaci guda, irin wannan canja wuri sau da yawa ya fi daidai.
- Bude fayil a cikin Kalma. Da yake cikin shafin "Gida", danna kan gunkin "Nuna alamun"wanda aka sanya a kan rubutun a cikin sakin layi na sakin layi. Maimakon waɗannan ayyuka, zaka iya danna maɓallin haɗin kai kawai Ctrl * *.
- Alamar musamman za ta bayyana. A ƙarshen kowace sakin layi alama ce. Yana da mahimmanci don tabbatar da cewa babu wani sakin layi mara kyau, in ba haka ba fasalin zai kasance ba daidai ba. Wajibi ne a share su.
- Jeka shafin "Fayil".
- Zaɓi abu "Ajiye Kamar yadda".
- Fayil din fayil ɗin fayil yana buɗewa. A cikin saiti "Nau'in fayil" zabi darajar "Rubutun Bayyana". Muna danna maɓallin "Ajiye".
- A cikin maɓallin canza fayil ɗin wanda ya buɗe, babu canje-canje da za a yi. Kawai danna maballin "Ok".
- Bude shirin na Excel a shafin "Fayil". Zaɓi abu "Bude".
- A cikin taga "Bayanin budewa" a cikin saiti na bude fayilolin saita darajar "Duk fayiloli". Zaɓi fayil da aka ajiye a cikin Kalma, a matsayin rubutu mai haske. Muna danna maɓallin "Bude".
- Wizard ɗin Shigar da Rubutun ya buɗe. Saka tsarin tsarin bayanai "An ƙaddara". Muna danna maɓallin "Gaba".
- A cikin saiti "Maganin kyawawan dabi'un" saka adadi "Kayan". Tare da duk sauran maki mun cire tikitin, idan akwai. Muna danna maɓallin "Gaba".
- A karshe taga, zaɓi tsarin bayanai. Idan kana da rubutu mai mahimmanci, an bada shawara don zaɓar tsarin. "Janar" (saita ta tsoho) ko "Rubutu". Muna danna maɓallin "Anyi".
- Kamar yadda muka gani, yanzu kowane sakin layi an saka ba a cikin tantanin tantanin halitta ba, kamar yadda a cikin hanyar da ta wuce, amma a cikin layi. Yanzu muna buƙatar fadada waɗannan layi don kada kalmomin mutum su ɓace. Bayan haka, zaka iya tsara sel a hankali.
Kusan bisa ga wannan makirci, zaka iya kwafin tebur daga Kalmar zuwa Excel. An bayyana nuances na wannan hanya a darasi na daban.
Darasi: yadda za a saka tebur daga Maganar zuwa Excel
Hanyar 3: Yi amfani da Aikace-aikacen Saɓo
Wata hanyar da za a juya Kalma zuwa takardun Excel shine amfani da aikace-aikace na musamman don fasalin bayanai. Daya daga cikin mafi dacewa daga cikinsu shi ne Abex Excel zuwa Kalmar Kalmar.
- Bude mai amfani. Muna danna maɓallin "Ƙara Fayiloli".
- A cikin taga wanda ya buɗe, zaɓi fayil ɗin da za a canza. Muna danna maɓallin "Bude".
- A cikin toshe "Zaɓi tsarin fitarwa" Zaɓi daya daga cikin siffofin Excel guda uku:
- xls;
- xlsx;
- xlsm
- A cikin akwatin saitunan "Saitin fitarwa" zabi wurin da za a canza fayil ɗin.
- Lokacin da aka ƙayyade duk saituna, danna maballin. "Sanya".
Bayan haka, hanyar juyin juya hali ya faru. Yanzu zaka iya bude fayil a Excel, kuma ci gaba da aiki tare da shi.
Hanyar 4: Juyawa Yin Amfani da Ayyukan Lantarki
Idan ba ka so ka shigar da ƙarin software akan PC naka, zaka iya amfani da ayyukan layi na musamman don maida fayiloli. Ɗaya daga cikin masu jujjuyawar yanar gizo mafi dacewa cikin jagorancin Kalma - Excel shine mai juyayi.
Mai karfin Intanet mai sauyawa
- Je zuwa shafin yanar gizon canzawa kuma zaɓi fayiloli don fassarar. Ana iya yin wannan a cikin hanyoyi masu zuwa:
- Zaɓi daga kwamfutar;
- Jawo daga bude taga na Windows Explorer;
- Sauke daga Dropbox;
- Sauke daga Google Drive;
- Sauke da tunani.
- Bayan an shigar da fayiloli mai tushe zuwa shafin, zaɓi hanyar ajiya. Don yin wannan, danna kan jerin saukewa zuwa hagu na takardun "An shirya". Je zuwa maƙallin "Takardun"sa'an nan kuma zaɓi tsarin xls ko xlsx.
- Muna danna maɓallin "Sanya".
- Bayan hira ya cika, danna kan maballin. "Download".
Bayan haka, za a sauke takardun Excel zuwa kwamfutarka.
Kamar yadda kake gani, akwai hanyoyi da yawa don sauya fayilolin Word zuwa Excel. Lokacin amfani da shirye-shirye na musamman ko masu saitunan yanar gizo, canji yana faruwa ne kawai a danna kaɗan. A lokaci guda, kwafin kwafi, ko da yake yana daukan tsayi, amma yana ba ka damar tsara fayil din yadda ya dace don dace da bukatunku.
