Hloov cov ntaub ntawv rau Microsoft Excel

Muaj ntau zaus thaum ntawv los yog cov ntxhuav hauv Microsoft Word xav kom hloov mus rau Excel. Hmoov tsis, Lo Lus tsis muaj cuab yeej ua rau yus hloov tau. Tab sis tib lub sij hawm, muaj ntau txoj hauv kev los hloov cov ntaub ntawv hauv qhov no. Cia peb saib seb qhov no yuav ua li cas.

Cov kev hloov yooj yim

Muaj peb lub ntsiab txoj hauv kev los hloov cov ntaub ntawv rau Excel:

  • cov ntaub ntawv yooj yim luam;
  • siv cov kev pabcuam thib peb tshwjxeeb;
  • siv cov kev pabcuam hauv online.

Txoj kev cai 1: Luam Ntaub Ntawv

Yog tias koj tsuas yog luam cov ntaub ntawv los ntawm cov ntaub ntawv Lo Lus mus rau Excel, ces cov ntsiab lus ntawm daim ntawv tshiab yuav tsis saib zoo heev. Txhua pawg ntawv yuav tsum muab tso rau hauv ib lub xov tooj ntawm tes. Yog li, tom qab cov ntawv luam tau theej, koj yuav tsum tau ua haujlwm ntawm tus qauv ntawm nws qhov kev tso kawm ntawm cov ntawv Excel. Ib lo lus nug yog luam tawm ntxhuav.

  1. Xaiv qhov seem ntawm cov ntawv nyeem lossis tag nrho cov ntawv hauv Microsoft Word. Peb nias lub khawm txoj kev nas, peb hu lub ntsiab lus teb cov lus qhia. Xaiv ib yam khoom "Daim qauv". Siv lub ntsiab lus teb, tom qab xaiv cov ntawv nyeem, koj tuaj yeem nias ntawm khawm "Daim qauv"uas yog muab tso rau hauv tab "Tsev" nyob rau hauv lub block ntawm cov cuab yeej "Ntawv Teev Npe". Lwm qhov kev xaiv yog tom qab xaiv cov ntawv nyeem nias khawm ua ke ntawm cov keyboard Ctrl + C.
  2. Qhib cov kev pab cuam Microsoft Excel. Peb nias roughly ntawm qhov chaw ntawm daim ntawv uas peb tab tom yuav muab cov ntawv nyeem. Txoj cai-nias lub pob hu lub ntsiab lus teb ntawv qhia zaub mov. Hauv nws, nyob hauv "Insertion options" block, xaiv tus nqi "Txuag Thawj Qhia Tshab".

    Tsis tas li ntawd xwb, txhob siv cov kev ua no, koj tuaj yeem nias ntawm lub pob Muab tshuaj txhuamuas yog nyob ntawm sab ntug ntawm daim kab xev. Lwm qhov kev xaiv yog nias rau qhov tseem ceeb ua ke Ctrl + V.

Raws li koj tau pom, cov ntawv nyeem yog ntxig, tab sis, raws li tau hais los saum toj no, nws muaj ib qho tsis pom kev.

Nyob rau hauv kev txiav txim tias nws yuav siv daim ntawv peb xav tau, peb tsiv mus rau lub hlwb mus rau qhov yuav tsum tau dav. Yog tias tsim nyog, ntxiv nws.

Txoj kev 2: Cov Ntaub Ntawv Loj Hloov Siab

Muaj lwm txoj hauv kev hloov cov ntaub ntawv los ntawm Lo Lus mus rau Excel. Ntawm chav kawm, nws yog ib qho nyuab dua li yav dhau los, tab sis, tib lub sij hawm, kev hloov pauv no feem ntau yog lawm.

  1. Qhib cov ntaub ntawv hauv Lo Lus. Nyob hauv tab "Tsev", nyem rau ntawm lub cim "Qhia tag nrho cov paib"uas yog muab tso rau ntawm txoj hlua hauv cov pawg ntawv toolbar. Siv cov kev ua no, koj tuaj yeem nias qhov sib lawv liag Ctrl +.
  2. Ib qho cim tshwj xeeb yuav tshwm sim. Qhov kawg ntawm txhua nqe lus yog qhov kos npe. Nws yog ib qho tseem ceeb kom ntseeg tau tias tsis muaj cov ntsiab lus npliag, txwv tsis pub qhov hloov dua tshiab yuav tsis muaj tseeb. Xws li cov nqe lus yuav tsum muab tshem tawm.
  3. Mus rau lub tab "Cov Ntaub Ntawv".
  4. Xaiv ib yam khoom "Tseg Rau".
  5. Qhov qhib qhov rais qhib qhov rais. Nyob rau hauv lub parameter "Cov Ntaub Ntawv Siv" xaiv tus nqi "Cov Ntawv Sau Txog". Peb nias lub khawm "Txuag".
  6. Hauv cov ntaub ntawv hloov qhov rai uas qhib, yuav tsum tsis txhob hloov. Cia li nias lub khawm "OK".
  7. Qhib Excel program hauv lub tab "Cov Ntaub Ntawv". Xaiv ib yam khoom "Qhib".
  8. Nyob rau hauv lub qhov rais "Qhib Cov Ntaub Ntawv" hauv qhov parameter ntawm cov ntaub ntawv qhib teev tus nqi "Txhua Ntaub Ntawv". Xaiv cov ntaub ntawv uas tau sau tseg cia hauv Lo Lus, raws li cov ntawv nyeem. Peb nias lub khawm "Qhib".
  9. Cov Ntawv Sau Ntawv Wizard qhib. Qhia kom meej rau cov ntaub ntawv "Delimited". Peb nias lub khawm "Tom ntej".
  10. Nyob rau hauv lub parameter "Tus cwj pwm tsis zoo yog" qhia cov nqi "Ntsuag". Nrog rau tag nrho lwm cov ntsiab lus peb tshem tawm cov zuam, yog tias muaj. Peb nias lub khawm "Tom ntej".
  11. Hauv lub qhov kawg, xaiv cov hom ntawv. Yog tias koj muaj cov ntawv nyeem, nws pom zoo kom xaiv ib hom ntawv. "General" (teem ntawm lub neej ntawd) lossis "Cov ntawv nyeem". Peb nias lub khawm "Ua li cas".
  12. Raws li peb pom, tam sim no txhua pawg lus yog tso rau hauv ib qho kev cais ntawm tes, raws li nyob rau hauv txoj kev dhau los, tab sis mus rau hauv ib txoj kab sib txawv. Tam sim no peb yuav tsum nthuav cov kab no kom txhua tus neeg cov lus tsis ploj. Tom qab ntawd, koj tuaj yeem tsim lub hlwb rau ntawm koj qhov kev pom zoo.

Kwv yees raws li tib lub tswv yim, koj tuaj yeem luam daim ntawv ntawm Word to Excel. Lub nuances ntawm cov txheej txheem no yog piav qhia hauv ib qho kev qhia tshwj xeeb.

Tshooj: yuav ua li cas mus ntxig rau ib lub rooj ntawm lo lus rau Excel

Method 3: Siv Cov Ntawv Sib Txawv Tebchaws Txuj Ci

Lwm txoj kev los hloov cov lus rau Excel cov ntaub ntawv yog siv cov ntawv thov tshwj xeeb rau cov ntaub ntawv tawm tswv yim. Ib qho ntawm feem ntau yooj yim ntawm lawv yog Abex Excel rau Word Converter.

  1. Qhib cov dej taws. Peb nias lub khawm "Ntxiv cov ntaub ntawv".
  2. Hauv qhov rais qhib, xaiv cov ntaub ntawv kom hloov dua siab tshiab. Peb nias lub khawm "Qhib".
  3. Hauv kev thaiv "Xaiv cov zis tawm tswv yim" Xaiv ib qho ntawm peb hom Excel ntawv:
    • xls;
    • xlsx;
    • xlsm
  4. Nyob hauv lub thawv ntawv "Qhov chaw tawm" xaiv qhov chaw uas cov ntaub ntawv yuav hloov dua siab tshiab.
  5. Thaum txhua qhov chaw teev, nyem rau ntawm lub pob. "Hloov siab".

Tom qab qhov no, qhov kev hloov dua tshiab yuav tsum ua. Tam sim no koj tuaj yeem qhib cov ntaub ntawv hauv Excel, thiab ua haujlwm nrog nws.

Method 4: Hloov Siv Cov Kev Pabcuam Online

Yog tias koj tsis xav kom nruab ib qho software ntxiv hauv koj lub PC, koj tuaj yeem siv cov kev pab tshwj xeeb hauv online los hloov cov ntaub ntawv. Ib qho ntawm cov neeg siv internet uas yooj yim tshaj plaws nyob rau hauv cov kev qhia ntawm Lo Lus - Excel yog qhov chaw Transertio.

Online Converter Hloov tshiab

  1. Mus rau hauv lub website Convertio thiab xaiv cov ntaub ntawv rau kev hloov dua siab tshiab. Qhov no tuaj yeem ua tau raws li hauv qab no:
    • Xaiv los ntawm lub computer;
    • Luag tawm ntawm lub qhov rais qhib ntawm Windows Explorer;
    • Download tau los ntawm Dropbox;
    • Download ntawm Google Drive;
    • Download los ntawm kev siv.
  2. Tom qab tau muab cov ntaub ntawv xa mus rau lub vev xaib, xaiv hom kev cawm nyiaj. Ua li no, nyem rau ntawm daim ntawv teev npe mus rau sab laug ntawm kab ntawv "Npaj". Mus rau kis "Cov ntaub ntawv"thiab ho xaiv cov hom ntawv xls lossis xlsx.
  3. Peb nias lub khawm "Hloov siab".
  4. Tom qab qhov ua tiav tiav lawm, nias lub khawm. "Download".

Tom qab ntawd, daim ntawv Excel yuav muab luam tawm rau koj lub computer.

Raws li koj tau pom, muaj ob peb txoj hauv kev hloov cov ntaub ntawv rau Excel. Thaum siv cov khoos kas tshwj xeeb los sis cov neeg siv tshuab hluav taws xob, cov kev hloov pom tshwm sim nyob rau hauv ib txhia ntawm cov khauj. Tib lub sij hawm, phau ntawv luam, tab txawm nws siv sijhawm ntev dua, tabsis cia koj hloov cov ntaub ntawv kom meej meej kom haum rau koj cov kev xav tau.