Hloov lo lus ntaub ntawv rau Microsoft Excel

Muaj ntau lub sijhawm thaum cov ntawv lossis cov ntxhuav ntaus hauv Microsoft Word yuav tsum hloov dua siab tshiab rau Excel. Hmoov tsis lo lus tsis muab cov cuab yeej tsim los rau cov kev hloov pauv ntawd. Tab sis, tib lub sijhawm, muaj ntau txoj hauv kev los hloov cov ntaub ntawv hauv qhov kev taw qhia no. Thov peb cov neeg no yuav ua tau li cas.

Txoj Kev Sib Hloov Yooj Yim

Muaj peb txoj hauv kev los hloov Lo Lus rau Excel:

• cov ntaub ntawv yooj yim theej;
• kev siv ntawm cov neeg thib peb cov ntawv thov tshwj xeeb;
• siv cov kev pabcuam tshwj xeeb online.

Txoj Kev 1: luam cov ntaub ntawv

Yog tias koj tsuas luam cov ntaub ntawv los ntawm Lo Lus rau hauv Excel, cov ntsiab lus ntawm daim ntawv tshiab yuav tsis saib zoo heev. Txhua pawg lus yuav raug muab tso rau hauv lwm kem. Yog li ntawd, tom qab cov ntawv luam tau theej, koj yuav tsum ua haujlwm ntawm cov qauv heev ntawm nws qhov kev tso kawm ntawm Excel nplooj ntawv. Ib qhov teeb meem sib cais yog theej cov ntxhuav.

1. Xaiv qhov xav tau ntawm cov ntawv lossis tag nrho cov ntawv nyeem hauv Microsoft Word. Peb muaj txoj cai nyem, uas coj lub ntsiab lus teb ua zaub mov. Xaiv cov khoom LuamCov. Hloov chaw siv ntawm cov ntawv qhia zaub mov, tom qab xaiv cov ntawv nyeem, koj tuaj yeem nyem lub khawm Luamuas muab tso rau hauv lub tab "Tsev" hauv lub thawv Ntawv Los Teev CiaCov. Lwm qhov kev xaiv yog xaiv cov kev sib txuas ntawm cov yawm sij ntawm cov keyboard tom qab xaiv cov ntawv sau Ctrl + C.



2. Qhib qhov kev pab cuam Microsoft Excel. Peb nyem kwv yees li ntawm qhov chaw ntawm nplooj ntawv uas peb tab tom yuav ntxig rau cov ntawv nyeem. Txoj cai-nias rau ntawm lub ntsiab lus teb ntawv qhia zaub mov. Hauv nws, hauv "Insertion Options" block, xaiv tus nqi "Khaws Cia Cia Li Hom Thawj".

   Tsis tas li, es tsis txhob ua cov haujlwm no, koj tuaj yeem nyem lub pob nyem Muab tshuaj txhuam, uas yog nyob rau ntawm sab laug kiag ntawm daim kab xev. Lwm qhov kev xaiv yog mus nias tus yuam sij ua ke Ctrl + V.

Raws li koj tuaj yeem pom, cov ntawv sau tau ntxig, tab sis nws, raws li tau hais los saum no, muaj qhov tsos tsis nthuav tawm.

Txhawm rau nws kom coj daim ntawv uas peb xav tau, peb nthuav tawm cov hlwb mus rau qhov xav tau dav. Yog tias tsim nyog, ntxiv rau tsim nws.

Txoj Kev 2: Ua Ntaub Ntawv Dua Lawm

Muaj lwm txoj hauv kev los hloov cov ntaub ntawv los ntawm Lo Lus rau Excel. Yog lawm, nws muaj ntau yam nyuaj dua li cov qauv dhau los, tab sis tib lub sijhawm, xws li kev hloov chaw feem ntau yog cov muaj tseeb.

1. Qhib cov ntaub ntawv hauv Lo Lus. Nyob hauv kab "Tsev"nyem rau ntawm qhov icon "Pom txhua tus cim", uas yog nyob rau ntawm daim xov hauv cov pawg lus qhia. Hloov chaw ntawm cov haujlwm no, koj tsuas tuaj yeem nias ib qho kev sib txuas tseem ceeb Ctrl + *.



2. Kev khij tshwj xeeb yuav tshwm sim. Qhov kawg ntawm txhua kab lus yog phiaj xwm. Nws yog qhov tseem ceeb los teev cia tias tsis muaj kab lus hais tsis sau, txwv tsis pub hloov pauv yuav tsis raug. Yuav tsum muab cov lus pov tseg ntawd tshem tawm.



3. Mus rau hauv lub tab Cov ntaub ntawv.



4. Xaiv cov khoom Txuag Raws Li.



5. Cov ntaub ntawv txuag qhov rai qhib. Hauv parameter Hom Ntawv xaiv tus nqi Lub tiaj ntawv nyeemCov. Nyem rau feem khawm Txuag.



6. Nyob rau hauv cov ntaub ntawv hloov pauv qhov rai uas qhib, tsis muaj kev hloov pauv yog tsim nyog. Tsuas nias lub pob "OK".



7. Qhib qhov kev pab cuam Excel hauv lub tab Cov ntaub ntawvCov. Xaiv cov khoom "Qhib".



8. Nyob rau hauv lub qhov rai "Qhib daim ntawv" nyob rau hauv cov ntaub ntawv qhib parameter, teeb tus nqi "Txhua cov ntaub ntawv"Cov. Xaiv cov ntawv uas yav tas los tau khaws tseg rau hauv Lo Lus, ua cov ntawv nyeem. Nyem rau feem khawm "Qhib".



9. Cov Ntawv Sau Lub Cev Khoom Siv Xov Xwm yuav qhib. Qhia cov hom ntaub ntawv Sib caisCov. Nyem rau feem khawm "Tom ntej".



10. Hauv parameter "Tus yam ntxwv cais yog" taw qhia tus nqi CommaCov. Tsis kos tag nrho lwm cov khoom yog tias muaj. Nyem rau feem khawm "Tom ntej".



11. Ntawm qhov rais kawg, xaiv cov ntaub ntawv hom. Yog tias koj muaj cov ntawv yooj yim, nws raug nquahu kom xaiv hom ntawv "General" (teeb tsa los ntawm lub neej ntawd) lossis "Ntawv"Cov. Nyem rau feem khawm Ua li cas.



12. Raws li koj tuaj yeem pom, tam sim no txhua kab lus yog ntxig tsis yog nyob rau hauv ib kem, nrog rau cov qauv dhau los, tab sis ntawm kab sib cais. Tam sim no koj yuav tsum nthuav cov kab no kom tsis txhob poob siab cov lus ntawm ib tus neeg. Tom qab ntawd, koj tuaj yeem tsim hom ntawv ntawm lub hlwb raws li koj txiav txim siab.

Txog tib lub tswvyim, koj tuaj yeem luam lub rooj ntawm Lo Lus rau Excel. Qhov tsis zoo ntawm cov txheej txheem no tau piav qhia hauv nyias ib zaj lus qhia.

Tshooj: yuav ua li cas ntxig ib lub rooj ntawm Lo Lus rau Excel

Txoj Kev 3: siv hloov cov ntawv thov siv

Lwm txoj hauv kev los hloov Lo Lus rau Excel yog siv cov ntawv tshwj xeeb rau kev hloov cov ntaub ntawv. Ib qho ntawm cov yooj yim ntawm lawv yog kev pab cuam Abex Excel rau Lo Lus Hloov.

1. Qhib cov nqi hluav taws xob. Nyem rau feem khawm "Ntxiv Cov Ntaub Ntawv".



2. Hauv qhov rai uas qhib, xaiv cov ntaub ntawv yuav tsum hloov dua siab tshiab. Nyem rau feem khawm "Qhib".



3. Ntawm kev thaiv "Xaiv tso zis ntau hom ntawv" xaiv ib qho ntawm peb qhov Excel:
   • xls;
   • xlsx;
   • xlsm.



4. Hauv cov chaw thaiv "Tsim tawm chaw" xaiv qhov chaw uas cov ntawv yuav hloov dua siab tshiab.



5. Thaum tag nrho cov kev teeb tsa tau taw qhia, nyem rau ntawm lub pob "Hloov".

Tom qab no, txheej txheem hloov dua siab tshiab yuav siv sijhawm. Tam sim no koj tuaj yeem qhib cov ntaub ntawv hauv Excel, thiab txuas ntxiv ua haujlwm nrog nws.

Txoj Kev 4: Hloov Siv Online Cov Kev Pab

Yog tias koj tsis xav teeb tsa software ntxiv rau hauv koj lub PC, koj tuaj yeem siv cov kev pabcuam online tshwj xeeb los hloov cov ntaub ntawv. Ib qho ntawm cov neeg siv online hloov dua siab tshiab yooj yim nyob rau hauv cov lus ntawm Word - Excel yog lub ntsiab lus Convertio.

Convertio online hloov ua lwm yam

1. Peb mus rau lub Convertio lub vev xaib thiab xaiv cov ntaub ntawv rau hloov dua siab tshiab. Qhov no tuaj yeem ua raws li hauv qab no:
   • Xaiv los ntawm lub computer;
   • Tsav los ntawm qhib qhov rai Explorer Windows;
   • Rub tawm los ntawm Dropbox;
   • Rub tawm los ntawm Google Drive;
   • Rub los ntawm txoj kab txuas.



2. Tom qab cov ntaub ntawv tawm yog xa mus rau ntawm tus xaib, xaiv hom ntawv khaws tseg. Txhawm rau ua qhov no, nyem rau ntawm daim ntawv nco-tseg rau sab laug ntawm pob zeb "Npaj"Cov. Mus rau kis "Cov ntaub ntawv", thiab mam li xaiv cov xls lossis xlsx format.



3. Nyem rau feem khawm Hloov siab.



4. Tom qab hloov dua siab tshiab yog ua tiav, nyem rau ntawm lub pob Rub.

Tom qab ntawv, daim ntawv nyob hauv hom ntawv Excel yuav muab rub tawm rau koj lub khoos phis tawm.

Raws li koj tuaj yeem pom, muaj ob peb txoj hauv kev los hloov Lo Lus rau Excel. Thaum siv cov phiaj xwm tshwj xeeb lossis cov hloov online, kev hloov pauv tshwm sim hauv qee lub clicks. Nyob rau tib lub sijhawm, phau ntawv theej, txawm hais tias nws siv sijhawm ntev dua, tab sis tso cai koj los kho cov ntawv kom yog raws li qhov koj xav tau.