Ntau zaus, muaj qhov yuav tsum tau hloov cov ntaub ntawv tabular los ntawm Microsoft Word rau cov ntawv ntawm Microsoft Excel cov ntaub ntawv. Lub rooj tuaj yeem theej tawm, tab sis ob peb cov lus txib yuav tsum ua kom tiav cov ntaub ntawv kom raug.
Nws yog qhov tsim nyog
- - Ib lub koos pis tawj;
- - ntsia Microsoft Office pob.
Cov Lus Qhia
Kauj ruam 1
Qhib cov ntawv tsim nyob rau hauv Microsoft Lo Lus uas koj xav hloov lub rooj rau Microsoft Excel. Nyem rau ntawm lub rooj nrog tus nas laug khawm, xaiv "Mloog" - "Xaiv cov lus" los ntawm cov ntawv qhia zaub mov.
Kauj ruam 2
Nias tus yuam sij ua ke Ctrl + C (los yog cov ntawv qhia zaub mov "Kho kom raug" - "Luam"; khawm ntawm lub cuab tam). Tom ntej no, mus rau ntawm nplooj ntawv ua haujlwm ntawm phau ntawv ua haujlwm hauv Microsoft Excel, xaiv qhov chaw uas kab ntawv sab saud sab saum toj ntawm lub rooj yuav nyob, nyem Ctrl + V los luam cov lus rau Excel.
Kauj ruam 3
Nco ntsoov tias thaj chaw uas koj xav theej lub rooj hauv Excel yog qhov khoob, vim tias cov ntaub ntawv los ntawm Lo Lus yuav hloov tag nrho cov ntaub ntawv nyob hauv cov hlwb ntawm tsab ntawv khom nqi uas nyob hauv thaj tsam ntxig. Txheeb xyuas qhov ntev ntawm cov lus tso. Tom qab ntawd nyem qhov "Ntxig" khawm.
Kauj ruam 4
Txhawm rau kho cov ntaub ntawv ntawm lub rooj, nyem rau Paste xaiv khawm uas nyob ib sab ntawm cov ntaub ntawv yav dhau los. Yog tias koj xav siv hom ntawv uas tau thov rau hauv cov kab ntawv hauv daim ntawv khom nqi, nyem qhov kev xaiv siv Kev Ncig Xyuas Cell Xaiv. Yog tias koj xav khaws daim tseem rooj nthuav dav, ces nyem rau "xaiv thawj hom ntawv" xaiv.
Kauj ruam 5
Kho kom raug qhov raug qhov teeb meem yog hais tias lub rooj cov ntsiab lus raug cais los ntawm tabs lossis qhov chaw. Txhawm rau ua qhov no, xaiv lub rooj, mus rau ntawm Ntawv qhia zaub mov, xaiv Cov Ntawv Sau los ntawm Txhua hais kom ua nyob ntawd.
Kauj Ruam 6
Xaiv Xaiv Delimited, nyem Next. Xaiv cov cim xav tau (thaj chaw lossis tab) raws li kev sib cais, nyem lub "Finish" khawm. Qee zaum tom qab tso cov ntaub ntawv, koj yuav tsum qhia meej nws thiaj li tuaj yeem siv cov ntaub ntawv kev ua haujlwm xam hauv Excel. Piv txwv li, cov chaw tsis tsim nyog yuav tshwm sim hauv hlwb, cov lej yuav tso rau hauv cov ntawv nyeem es tsis yog suav cov lej. Nws kuj tseem tuaj yeem ua rau pom tsis zoo ntawm cov hnub tim. Txhawm rau txhim kho qhov no, xaiv cov ntaub ntawv nyob hauv tib hom ntawv, sab xis thiab xaiv Hom Cell. Hauv seem "Tooj", teeb tsa cov ntaub ntawv xav tau cov ntaub ntawv (naj npawb, txiaj, hnub, thiab lwm yam).
