Nrhiav kom paub qhov version of DirectX nyob rau hauv lub qhov rais 10

Ntau cov neeg siv ntawm Excel yog ntsib nrog cov nqe lus nug ntawm kev hloov lub sij hawm nrog cov huab cua nyob rau hauv lub rooj. Qhov no feem ntau yog vim qhov tseeb uas nyob rau hauv cov lus Askiv hais lus yog kev cai cais cais cov zauv feem ntawm ib qho integer los ntawm ib qho chaw, thiab nyob rau hauv peb lub teb chaws - ib qho tsis nco qab. Worst ntawm tag nrho cov, cov zauv nrog ib teev yog tsis tau ntaus nqi ua lus Askiv ntawm hom lus Excel raws li hom ntawv numeric. Yog li no, qhov kev coj ntawm kev hloov tshiab yog li ntawd. Cia peb xav paub seb yuav hloov cov ntsiab lus rau leej twg hauv Microsoft Excel ntau txoj hauv kev.

Txoj kev hloov lub taw tes rau ib qho kev ua tsis tiav

Muaj ntau ntau txoj kev uas yuav hloov lub taw tes rau ib qho kev vam com hauv Excel. Qee yam ntawm lawv tau daws cov teebmeem ntawm kev ua haujlwm ntawm daim ntawv thov no, thiab kev siv lwm tus yuav tsum tau siv cov kev pabcuam thib peb.

Txoj kev 1: Nrhiav thiab Hloov Tuam

Qhov yoojyim tshaj plaws los hloov cov dots nrog spas yog coj kom zoo dua ntawm qhov ua tau muab los ntawm lub cuab yeej. "Nrhiav thiab hloov". Tab sis, thiab nrog nws koj xav kom coj zoo. Tom qab tag nrho, yog tias nws raug siv tsis raug, tag nrho cov ntsiab lus ntawm daim ntawv yuav raug hloov, txawm nyob hauv cov chaw uas lawv xav tau tiag tiag, piv txwv li, hauv cov hnub nyoog. Yog li, qhov no yuav tsum raug siv kom zoo.

1. Nyob hauv tab "Tsev"nyob rau hauv ib pawg ntawm cov cuab yeej Editing nyob rau hauv daim kab xev nyem rau ntawm lub pob "Nrhiav thiab pom tseeb". Nyob rau hauv cov ntawv qhia zaub mov uas tshwm, nyem qhov khoom "Hloov".



2. Qhov rais qhib "Nrhiav thiab hloov". Hauv teb "Nrhiav" ntxig rau daim ntawv kos npe (.). Hauv teb "Hloov" - cim kos npe (vi). Ndliv lub khawm "Kev xaiv".



3. Qhib ntxiv nrhiav thiab hloov chaw. Yam tsis txawv "Hloov nrog ..." nyem rau ntawm lub pob "Hom ntawv".



4. Lub qhov rais qhib hauv uas peb tuaj yeem tsim cov qauv ntawm lub xovtooj los hloov, xijpeem nws yuav ua ntej. Nyob rau hauv peb cov ntaub ntawv, qhov tseem ceeb tshaj plaws yog los muab cov qauv ntawv qhia tawm. Hauv tab "Tooj" ntawm cov teeb meem ntawm numeric hom xaiv yam khoom "Numeric". Peb nias lub khawm "OK".



5. Tom qab peb rov qab los rau ntawm qhov rais "Nrhiav thiab hloov", xaiv tag nrho cov hlwb ntawm daim ntawv, qhov koj yuav tsum tau ua dua ib qho chaw hloov dua tshiab los ntawm lub vev xaib. Qhov no tseem ceeb heev, vim yog tias koj tsis xaiv ib thaj tsam, ces ib qho kev hloov yuav tshwm sim rau tag nrho cov ntawv, uas tsis tas yuav tsim nyog. Tom qab ntawd, nyem rau ntawm lub pob "Hloov Tag Nrho".

Raws li koj pom, qhov hloov tau zoo.

Tshooj: hloov cov cim hauv Excel

Txoj kev 2: Siv cov haujlwm SUB

Lwm qhov kev xaiv los hloov qhov point nrog tus voj voog twg yog siv FIT. Txawm li cas los xij, thaum siv cov kev ua no, qhov hloov tsis tshwm nyob rau hauv lub hauv paus ntawm qhov chaw, tab sis tshwm nyob hauv ib kem.

1. Xaiv lub xovtooj ntawm tes uas yuav dhau los ua ntej hauv kem mus tso saib cov ntaub ntawv hloov. Ndliv lub khawm "Ntxig rau kev ua haujlwm"uas nyob rau sab laug ntawm qhov chaw ntawm txoj hlua kev ua haujlwm.



2. Pib kev ua haujlwm ua haujlwm. Nyob rau hauv daim ntawv teev npe nyob rau hauv lub qhov rais qhib, peb tab tom nrhiav rau ib tug muaj nuj nqi SUBMIT. Xaiv nws thiab nyem rau ntawm lub pob. "OK".



3. Qhov kev sib cav sib txawv yog qhib qhov rai. Hauv teb "Cov ntawv nyeem" koj yuav tsum nkag mus rau qhov chaw ntawm thawj lub xovtooj ntawm kab ntawv uas cov zauv nrog cov dots nyob. Qhov no yuav ua tau yooj yim los xaiv qhov ntawm tes ntawm daim ntawv nrog nas. Hauv teb "Star_text" insert point (.). Hauv teb "New_text" muab tso rau ib qho (vi). Teb "Naj Npawb Nkag Mus" tsis tas yuav sau. Qhov kev ua haujlwm nws tus kheej yuav muaj cov qauv hauv qab no: "= SUB (cell address;". ";", ",") ". Peb nias lub khawm "OK".



4. Raws li koj tau pom, hauv xov tooj tshiab, tus xov tooj twb muaj ib qho tsis tiav ib qho chaw. Tam sim no peb yuav tsum ua ib txoj haujlwm zoo sib xws rau txhua lub hlwb nyob rau sab. Qhov tseeb, koj tsis tas yuav nkag mus rau ib qho kev ua haujlwm rau txhua tus lej: muaj ntau txoj hauv kev los hloov dua siab tshiab. Peb ua nyob rau hauv qab txoj cai hauv qab ntawm tes uas muaj cov ntaub ntawv hloov dua siab tshiab. Tus cim kos npe tshwm. Tuav lub khawm laug nas, cab nws mus rau sab qis ntawm cheeb tsam uas muaj cov ntaub ntawv los hloov dua siab tshiab.



5. Tam sim no peb yuav tsum tau muab lub hlwb tso ntau hom. Xaiv qhov cheeb tsam ntawm cov ntaub ntawv hloov tshiab. Nyob rau ntawm txoj kab sib tw "Tsev" nrhiav ib ntu ntawm cov cuab yeej "Tooj". Hauv daim ntawv teev npe, peb hloov cov hom ntawv rau cov zauv.

Qhov no ua tiav cov ntaub ntawv hloov dua siab tshiab.

Method 3: Siv Macro

Koj tuaj yeem hloov lub sij hawm nrog lub caij nyoog hauv Excel los ntawm kev siv lub lag luam.

1. Ua ntej tshaj, koj yuav tsum tau pab kom cov macros thiab tab "Tsim tawm"yog tias lawv tsis koom nrog.



2. Mus rau lub tab "Tsim tawm".



3. Peb nias lub khawm "Nrig txog kev pom tseeb".



4. Ntxig txoj cai hauv qab no rau hauv qhov rais qhib:

   Sub Macro_substitution_complete ()
Xaiv Ua Dab Tsi: = "". ", Hloov: =", "
Kawg kawg

   Kaw cov editor.



5. Xaiv qhov chaw ntawm lub hlwb ntawm daim ntawv uas koj xav hloov siab. Hauv tab "Tsim tawm" nias lub khawm Macros.



6. Nyob rau hauv lub qhov rais qhib, ib daim ntawv teev cov macros. Xaiv los ntawm daim ntawv "Macro hloov greeting rau cov ntsiab lus". Peb nias lub khawm Khiav mus.

Tom qab ntawd, cov ntsiab lus yog hloov dua siab tshiab rau ib hnub ntawm ib qho kev xaiv ntawm cov hlwb.

Mloog zoo! Siv hom no zoo heev. Qhov teebmeem ntawm no macro yog irreversible, yog li xaiv cov hlwb uas koj xav siv nws.

Tshooj: Yuav ua li cas los tsim kom tau ib qho lag luam hauv Microsoft Excel

Method 4: Siv Notepad

Cov txheej txheem nram qab no yuav tsum luam cov ntaub ntawv rau hauv cov qauv ntaub ntawv editor hauv Windows Notepad, thiab hloov rau hauv qhov kev kawm no.

1. Xaiv nyob rau hauv Excel cheeb tsam ntawm lub hlwb uas koj xav hloov lub taw tes nrog ib qho tsis nco qab. Nyem txoj nas khawm. Hauv cov ntawv qhia zaub mov, xaiv cov khoom "Daim qauv".



2. Open Notepad. Ua ib nias nrog rau txoj kev nas khawm, thiab nyob rau hauv daim ntawv uas tshwm rau nias ntawm qhov khoom Muab tshuaj txhuam.



3. Nias rau ntawm daim ntawv qhia zaub mov Kho kom raug. Hauv daim ntawv uas tshwm sim, xaiv qhov khoom "Hloov". Xwb, koj tuaj yeem sau cov yaum ua ke ntawm cov keyboard Ctrl + H.



4. Tshawb nrhiav thiab hloov qhov rais qhib. Hauv teb "Dab tsi" muab xaus. Hauv teb "Dab tsi" - comma. Peb nias lub khawm "Hloov Tag Nrho".



5. Xaiv cov ntaub ntawv kho nyob rau hauv Notepad. Nias lub pob nyem khawm, thiab xaiv cov khoom "Daim qauv". Los yog nyem rau ntawm tus keyboard shortcut Ctrl + C.



6. Peb rov qab mus rau Excel. Xaiv qhov ntau ntawm cov hlwb uas qhov tseem ceeb yuav tsum tau hloov. Peb nyem rau ntawm sab xis nrog txoj cai khawm. Hauv cov ntawv qhia zaubmov uas tshwm hauv seem "Insertion Options" nyem rau ntawm lub pob "Tseg ntawv tsuas". Los yog, nias ua ke nrog Ctrl + V.



7. Rau txhua yam ntawm cov hlwb, teem caij pes tsawg hom tib yam li yav tas los.

Txoj kev 5: Hloov Excel Chaw

Raws li yog ib txoj hauv kev hloov cov ntsiab lus rau leej twg, koj tuaj yeem siv Excel qhov customization nqis.

1. Mus rau lub tab "Cov Ntaub Ntawv".



2. Xaiv ib seem "Kev xaiv".



3. Mus rau kis "Qib Siab".



4. Hauv seem hais txog "Editing xaiv" uncheck yam khoom "Siv qhov kev kaw lus". Nyob rau hauv lub teb activated "Separator ntawm tag nrho thiab feem ntu" muab xaus. Peb nias lub khawm "OK".



5. Tab sis, cov ntaub ntawv xwb yuav tsis hloov. Peb luam lawv mus rau hauv Notepad, thiab ces muab lawv mus rau hauv tib qhov chaw nyob rau hauv txoj kev niaj zaus.



6. Tom qab lub lag luam tiav, nws pom zoo kom xa rov qab lub Excel default settings.

Txoj kev 6: hloov chaw

Hom no zoo ib yam li yav dhau los. Tsuas lub sijhawm no, peb tsis hloov cov chaw Excel. Thiab cov qhov system qhov rais.

1. Los ntawm cov ntawv qhia zaub mov "Pib" peb nkag mus "Tswj Vaj Huam Sib Luag".



2. Hauv Pawg Tswj Kev Tswj, mus rau seem "Moos, lus thiab cheeb tsam".



3. Mus rau subsection "Yam Lus thiab Lub Hauv Paus Lus".



4. Nyob rau hauv lub qhov rais qhib hauv lub tab "Ntaus ntawv" nias lub khawm "Cov chaw pib".



5. Hauv teb "Separator ntawm tag nrho thiab feem ntu" peb hloov ib qho vuag twg rau ib qho chaw. Peb nias lub khawm "OK".



6. Luam cov ntaub ntawv los ntawm Notepad mus rau Excel.



7. Peb xa rov qab lub qhov rais dhau los.

Qhov kawg taw tes yog qhov tseem ceeb heev. Yog tias koj tsis ua raws li nws, koj yuav tsis muaj peev xwm nqa tawm cov kev ua haujlwm li qub nrog cov ntaub ntawv hloov dua siab tshiab. Tsis tas li ntawd, lwm cov kev pab cuam uas tau teev hauv lub computer kuj tuaj yeem ua haujlwm tsis zoo.

Raws li koj tau pom, muaj ob peb txoj hauv kev los hloov qhov nres tag nrho nrog ib qho kev poob qab hauv Microsoft Excel. Tau kawg, cov neeg siv feem ntau xav siv qhov yooj yim thiab cov cuab yeej tshaj plaws rau qhov txheej txheem no. "Nrhiav thiab hloov". Tab sis, hmoov tsis, qee zaum nrog nws cov kev pab nws tsis tau hloov cov ntaub ntawv kom raug. Qhov ntawd yog thaum lwm cov kev daws teeb meem tuaj yeem pab cawm.