Ba wani sirri bane cewa Microsoft Excel shine mafi kyawun aikin aiki mai dacewa da dacewa. Tabbas, tebur sun fi sauƙin yin daidai a cikin Excel fiye da kalmar da aka yi niyya don wasu dalilai. Amma, wani lokacin tebur da aka yi a cikin wannan editan maƙunsar yana buƙatar canja shi zuwa daftarin rubutu. Bari mu ga yadda za a canja wurin tebur daga Microsoft Excel zuwa Magana.
Kwafe mai sauki
Hanya mafi sauki don canja wurin tebur daga wannan tsarin Microsoft zuwa wani shine kawai kwafa da liƙa shi.
Don haka, buɗe teburin a cikin Microsoft Excel, kuma zaɓi gaba ɗaya. Bayan haka, muna kiran menu na mahallin tare da maɓallin linzamin kwamfuta na dama kuma zaɓi abu "Kwafi". Hakanan zaka iya latsa maɓallin ƙarƙashin sunan guda akan kintinkiri. A madadin haka, zaka iya buga gajerar hanya ta Ctrl + C.
Bayan an kwafa teburin, buɗe shirin Microsoft Word. Wannan na iya zama cikakkiyar takarda mara amfani ko takarda tare da rubutun da aka riga aka rubuta inda ya kamata a saka teburin. Zaɓi wurin da za a saka, danna-dama a kan wurin da za mu saka teburin. A cikin menu na mahallin da ke bayyana, zaɓi abu a cikin zaɓin abin "Saka bayanai na ainihi". Amma, kamar yadda yake a kwafa, zaku iya liƙa ta danna maɓallin dacewa a kan kintinkiri. Ana kiran wannan maballin "Manna", kuma yana a farkon farkon tef. Hakanan, akwai wata hanya don liƙa tebur daga allon rubutu ta hanyar buga maɓallin gajeriyar hanya Ctrl + V, har ma mafi kyau - Shiaura + Sakawa.
Rashin dacewar wannan hanyar ita ce idan teburin ya yi faɗi sosai, to, watakila ba zai dace da kan iyakokin takardar ba. Sabili da haka, wannan hanyar ta dace da tebur-masu dacewa kawai. A lokaci guda, wannan zaɓi yana da kyau a cikin cewa zaku iya ci gaba da shirya teburin yadda kuke so, kuma kuyi canje-canje a ciki, ko da bayan an ɗora shi a cikin Rubutun Magana.
Kwafi ta amfani da liƙa
Wata hanyar da zaku iya canja wurin tebur daga Microsoft Excel zuwa Magana ita ce ta shigar da ta musamman.
Mun buɗe teburin a cikin Microsoft Excel, kuma kwafe shi a cikin ɗayan hanyoyin da aka nuna a cikin zaɓin canji na baya: ta hanyar menu na mahallin, ta maɓallin akan kintinkiri, ko ta latsa maɓallin keɓaɓɓiyar keyboard Ctrl + C.
Bayan haka, buɗe takaddar Kalmar a cikin Microsoft Word. Zaɓi wurin da kake son saka tebur. To, danna kan maballin jerin abubuwan da aka saukar karkashin maballin "Saka" a kan kintinkiri. A cikin jerin zaɓi, zaɓi "Manna na musamman".
Taga na musamman na buɗe. Muna sauyawa canjin zuwa matsayin "Haɗin", kuma daga zaɓin shigar da aka zaɓa, zaɓi abu "Microsoft Excel worksheet (abu)". Latsa maɓallin "Ok".
Bayan wannan, an saka teburin a cikin Microsoft Word document kamar hoto. Wannan hanyar tana da kyau a cikin cewa koda teburin yana da fadi, an matsa zuwa girman shafi. Rashin dacewar wannan hanyar hada da cewa Magana ba zata iya shirya teburin ba saboda an saka ta azaman hoto.
Saka bayanai daga fayil
Hanya ta uku bata ƙunshi buɗe fayil a Microsoft Excel ba. Nan da nan muka fara Magana. Da farko dai, kuna buƙatar zuwa shafin "Saka". A kan kintinkiri a cikin toshe kayan "Rubuta", danna maɓallin "Object".
Insert Object taga yana buɗewa. Je zuwa shafin "Createirƙira daga fayil", kuma danna maɓallin "Bincika".
Wani taga yana buɗewa inda kuke buƙatar nemo fayil ɗin a cikin Tsarin Excel, teburin da kake son sakawa. Bayan kun samo fayil ɗin, danna shi kuma danna maɓallin "Saka".
Bayan haka, mun sake komawa zuwa taga "Saka Abin da ke ciki". Kamar yadda kake gani, adireshin fayil ɗin da ake so an riga an shigar da shi a cikin madaidaicin tsari. Dole ne mu danna maɓallin "Ok".
Bayan haka, ana nuna tebur a cikin Microsoft Word document.
Amma, kuna buƙatar la'akari da cewa, kamar yadda a cikin yanayin da ya gabata, an saka tebur azaman hoto. Bugu da kari, sabanin zabin da ke sama, an shigar da duk abubuwan cikin fayil ɗin gaba ɗayansa. Babu wata hanyar da za a nuna wani takamaiman tebur ko iyaka. Saboda haka, idan akwai wani abu ban da tebur a cikin fayil ɗin Excel wanda ba ku son ganin bayan canja wurin zuwa Tsarin Kalma, kuna buƙatar gyara ko share waɗannan abubuwan a cikin Microsoft Excel kafin fara jujjuya teburin.
Mun rufe hanyoyi da yawa don canja wurin tebur daga fayil ɗin Excel zuwa takaddar Word. Kamar yadda kake gani, akwai wasu yan hanyoyi daban-daban, dukda cewa ba dukkaninsu sun dace ba, yayin da wasu kuma ke iyakance. Sabili da haka, kafin zaɓin takamaiman zaɓi, kuna buƙatar yanke hukunci game da abin da kuke buƙatar teburin da aka canjawa wuri, ko kuna shirin shirya shi a cikin Magana, da sauran lambobi. Idan kawai kuna son buga takarda tare da teburin da aka saka, to sakawa azaman hoto zai yi kyau sosai. Amma, idan kuna shirin canza bayanai a cikin tebur riga a cikin takaddar Maganar, to a wannan yanayin, tabbas kuna buƙatar canja wurin teburin a cikin tsari mai daidaituwa.
