Sau da yawa, masu amfani da Microsoft Office aikace-aikace shi wajibi ne don canja wurin manyan-tebur da Tazarar data, Ya halitta a cikin MS Excel maƙunsar, daftarin aiki edita MS Word fayilolin rubutu. Alal misali, ka dafa a Word daftarin aiki ne a ci gaba da rahoton, da kuma dijital readouts aka kafa a Excel a matsayin tebur, da kuma wannan tebur wajibi ne a saka a cikin rubutu na da rahoto a Word. Sau da yawa, mutane da yawa kokarin da hannu haifar da wani tebur a wani rubutu daftarin aiki (Word ba irin wannan damar) da kuma bayanai daga Excel Kwayoyin kuma yi ƙaura zuwa wata tebur a wani Word manual. Amma da mafi daidai zai har yanzu matsar da shirye a Excel tebur a cikin rubutu a cikin Word. A lokaci guda ba da yawa gogaggen masu amfani akwai wata tambaya game da yadda za a motsa wani tebur daga Excel zuwa Word. Ka yi la'akari da yiwu amsoshin wannan tambaya a cikin mafi daki-daki.
A Hanyar kawai kwafan
Zai ze cewa wannan tambaya na yadda za a saka Excel a Word, a kan surface. Isar da shi a Excel haskaka da ake so sa yankin na tebur, zaɓi toolbar "Copy" panel, da tebur za a ajiye a allo mai rike takarda, sa'an nan zuwa wani daftarin aiki a Word, dom motsa kibiya zuwa wuri inda dole ne a saka a cikin tebur, da kuma danna "Manna" . A wata kalma daftarin aiki daga cikin allo mai rike takarda tebur bayyana, kuma duk data abin da yake a cikin sel a Excel, shi ma za a kofe kuma pasted, shi ke yi. Amma a gaskiya, kamar yadda mai mulkin, duk abin da yake mafi rikitarwa. Bayan duk, a sakamakon al'ada ayyukan "Copy / Manna" daga Excel tebur saka a cikin Word kawai "mummuna": girman maƙunsar iya da gaske wuce rubutu da wata kalma page kan iyaka, da kuma format na bayanai a Kwayoyin a sakamakon daban-daban daga format na rubutu a cikin Word. Saboda haka, matsalar - yadda za a motsa wani tebur daga Excel a cikin Word - Ya kamata a za'ayi da ɗan daban.
Saka a tebur a wani rubutu daftarin aiki a matsayin mai hoto abu
La'akari da zaɓi na kwafan tebur a Word a matsayin mai hoto abu. Kamar haka wajibi ne a yi la'akari da cewa a cikin wata kalma Excel an saka a matsayin hoto, watau. E. Lokacin gyara data a cikin tushen tebur Kwayoyin a Excel saka a cikin wani juna tebur a wata kalma ba ya canja. A amfani da wannan hanya shi ne cewa irin wannan tebur-zane za a iya koma cikin wani daftarin aiki, free to kwafa da manna guda kamar yadda sauran wurare a cikin rubutu, mayar da girman hoton, idan ya zama dole. Akwai wasu nuances wannan hanya, wanda bambanta dangane da version of MS Word ka shigar.
Yadda za a motsa wani tebur daga Excel a cikin Word MS Word 2003 version
Mun shiryar da siginan a kan wurin da rubutu inda kana so ka saka a tebur. A cikin toolbar drop-saukar menu a cikin "Saka" dole ne ka zaɓi "Object". A cikin maganganu akwatin ka bukatar ka danna "Create daga fayil," kuma ta latsa maballin "Browse" don zaɓar Excel fayil, wanda gidaje asali shirye don canja wurin tebur. Sa'an nan danna "Ok". A sakamakon haka, da tebur na fayil za a saka a cikin rubutu daftarin aiki a matsayin mai hoto abu.
MS Word 2007
Next, za mu nuna maka yadda za a motsa wani tebur daga Excel a cikin Word idan kana amfani da wani version na ofishin suite 2007. Har ila yau, ya sa siginan kwamfuta a cikin rubutu da hakkin wuri. A saman toolbar, zabi cikin shafin "Saka", da aka samu a cikin sashe "Text" button "Saka Object" maganganu akwatin kuma zaɓi shafin "Create daga fayil". Bugu da ari, kuma ta hanyar da "Browse" button to bude dole Excel, kuma danna "Ok".
Haxe Tables a Excel, kuma Word
Yadda za a canja wurin Excel zuwa Word, don haka da cewa data a cikin sel aka saka a cikin daftarin aiki a wani Word tebur ta atomatik canza, idan ka shirya akai-akai sabunta da data a cikin tushen tebur Kwayoyin a Excel. Za ka iya amfani da hanyar cudanya allunan lokacin pasting daga Excel zuwa rubutu a wani Word. Don yin wannan, dole ne ka kwafa da ake so tebur a Excel fayil. Bugu da ari, a wata kalma, da siginan tana wurinta a da ake so sa site, da toolbar a kan jinginar gida, "Home", zaɓi umurnin "Manna Special", canza zuwa abu "Sanya" a cikin "Yadda" zaɓi "Microsoft Excel List (abu)." A sakamakon zai iya hade Saka tebur. A lokacin da ka danna sau biyu a linzamin kwamfuta a kan tebur a wani Word za ta atomatik canzawa zuwa wannan tebur a Excel, za ka iya gyara. Har ila yau, idan ya cancanta, za a tilasta sabunta data a cikin Kwayoyin, domin wannan kana bukatar a kan tebur a wani Word, danna-dama kuma zaɓi "Update Link".
Idan ka zabi wannan hanya, dole ne ka duba ɗaya muhimmanci. A wannan yanayin, idan tsarin da alaka da tebur za baya canza (msl, yawan Lines da za a canja, share ginshikan da sauransu. D.), Sa'an nan kuma canjawa wuri a cikin wani Word Table da mutunci da aka keta, shi kawai "taso kan ruwa." Saboda haka, yana da muhimmanci cewa tushen tebur a Excel ya kafin kwafan da kuma dauri da aka yi tare da fayyace girma - tare da da wani yawan sel (layuka da kuma ginshikan), kuma kawai bayan tebur a so view, ka shirya don kwafa da manna ta ɗaurinSa. Yanzu da ka san yadda za a canja wurin Excel zuwa Word.