EXCEL NCO-DOWN DAIM NTAWV

Kev tsim cov npe ntawm cov ntawv tso npe tsis pub tsuas yog kom txuag lub sij hawm thaum xaiv ib qho kev xaiv ntawm kev sau hauv cov ntxhuav, tab sis kuj yuav tsum tiv thaiv tus kheej los ntawm cov lus qhia tawm tsis muaj tseeb ntawm cov ntaub ntawv tsis raug. Qhov no yog ib qho yooj yim thiab siv tau cov cuab yeej. Cia peb kawm seb yuav qhib tau li cas hauv Excel, thiab siv nws li cas, nrog rau lwm tus kawm txog lwm yam kev ua haujlwm.

Siv cov npe teev cia

Tawm-down, los yog raws li lawv hais, cov npe ntawm kev sau npe yog feem ntau siv hauv cov ntxhuav. Nrog lawv cov kev pab, koj tuaj yeem txo qhov ntau ntawm cov txiaj ntsim uas tau nkag rau hauv cov rooj plaub. Lawv cia koj xaiv qhov sau qhov tseem ceeb tsuas yog los ntawm daim ntawv teev npe ua ntej. Qhov no ib txhij ceev txog cov ntaub ntawv nkag teb chaws thiab tiv thaiv kev ua yuam kev.

Tsim cov txheej txheem

Ua ntej tshaj plaws, cia peb xav paub seb yuav tsim cov ntawv sau cia li cas. Qhov yoojyim tshaj los ua qhov no yog nrog lub cuab yeej hu ua "Cov Ntaub Ntawv Qhia Tias".

Xaiv lub kem ntawm lub rooj array, hauv cov hlwb uas koj npaj muab tso rau hauv daim ntawv teev npe. Tsiv mus rau qhov tab "Cov ntaub ntawv" thiab nyem rau ntawm lub pob "Cov Ntaub Ntawv Qhia Tias". Nws yog nyob rau hauv daim npliag rau hauv kab ntawv. "Ua hauj lwm nrog cov ntaub ntawv".

Qhov cuab yeej qhib qhov rai. "Kuaj Qhov Muag". Mus rau seem "Kev xaiv". Hauv thaj chaw "Hom ntaub ntawv" xaiv los ntawm daim ntawv teev npe "Sau". Tom qab ntawd tsiv mus rau tom teb "Tau qhov twg los". Ntawm no koj yuav tau qhia ib pawg ntawm cov khoom siv rau hauv daim ntawv. Cov npe no yuav muab ntaus nkag los ntawm kev xuas tes, los yog koj tuaj yeem txuas mus rau lawv yog tias lawv twb muab tso rau hauv ib daim ntawv Excel ua lwm qhov.
Yog tias phau ntawv xaiv tau raug xaiv, ces txhua daim ntawv teev npe yuav tsum nkag mus rau hauv thaj tsam ntawm lub semicolon (;).
Yog tias koj xav rho tawm cov ntaub ntawv los ntawm cov txheej txheem uas twb muaj lawm, ces mus rau daim ntawv uas nws nyob (yog nws nyob ntawm lwm), muab tus cursor hauv cheeb tsam "Tau qhov twg los" cov ntaub ntawv validation qhov rais, thiab tom qab ntawd ces xaiv ib qho array ntawm cov cells qhov chaw nyob. Nws yog ib qho tseem ceeb uas txhua tus tib neeg muaj nyob hauv ib qho khoom cais. Tom qab ntawd, cov hauj lwm ntawm qhov tau teev tseg yuav tsum tshwm sim hauv cheeb tsam "Tau qhov twg los".
Lwm txoj kev los tsim kev sib txuas lus yog los muab tus qauv nrog cov npe. Xaiv qhov ntau ntawm cov ntaub ntawv tseem ceeb. Rau sab laug ntawm tus qauv mis yog cov npe. Los ntawm lub neej ua ntej, thaum xaiv ib thaj tsam, tus thawj ntawm cov thawj xaiv ntawm tes tau muab tso tawm. Peb, rau peb lub hom phiaj, tsuas sau lub npe uas peb xav tias tsim nyog. Lub ntsiab lus tseem ceeb ntawm lub npe yog tias nws yog nyob rau hauv phau ntawv, tsis muaj chaw, thiab tas pib nrog ib tsab ntawv. Tam sim no nws yog los ntawm lub npe no tias qhov ntau qhov uas peb tau txheeb xyuas tau yuav raug txheeb xyuas.
Tam sim no nyob rau hauv cov ntaub ntawv pov thawj cov ntaub ntawv nyob hauv cheeb tsam "Tau qhov twg los" yuav tsum tau teem caij ua cim "="thiab tom qab ntawd tam sim ntawd tom qab nws sau lub npe uas peb muab rau qhov ntau. Qhov kev qhia tam sim ntawd qhia qhov kev sib txuas ntawm lub npe thiab cov array, thiab rho tawm cov npe hauv nws.
Tab sis nws yuav siv ntau npaum li cas los siv daim ntawv yog tias nws hloov dua siab tshiab rau hauv ib lub rooj ntse. Nyob rau hauv xws li ib lub rooj nws yuav yooj yim dua los hloov lub qhov tseem ceeb, yog li cia li hloov cov khoom sau. Yog li, qhov sib txawv no yuav tau tig mus rau hauv ib lub rooj lookup.
Yuav kom hloov tau ib chav rau ib lub ntse ntse, xaiv nws thiab txav mus rau qhov tab "Tsev". Muaj peb nyem rau ntawm lub pob "Hom ntawv raws li rooj"uas yog muab tso rau hauv kab xev hauv kev thaiv "Yeej". Muaj ntau pab pawg neeg loj tuaj. Cov kev xaiv ntawm ib hom lus tsis zoo rau kev ua haujlwm ntawm lub rooj, thiab yog li ntawd peb xaiv ib yam ntawm lawv.
Tom qab ntawd lub qhov rais qhib me me, uas muaj qhov chaw nyob ntawm tus xaiv cov array. Yog tias txoj kev xaiv raug tsim kom yog, ces tsis muaj dab tsi yuav tsum tau hloov. Vim peb tsis muaj lub npe, yam khoom "Cov lus nrog lub npe" zuam yuav tsum tsis txhob. Txawm hais tias nyob hauv koj rooj plaub, tej zaum lub npe yuav raug siv. Li ntawd, peb tsuas muaj thawb lub pob. "OK".
Tom qab qhov no yuav muab teeb tsa ua ib lub rooj. Yog tias koj xaiv nws, koj tuaj yeem pom nyob rau hauv lub npe teb tias lub npe raug muab tso rau nws. Lub npe no siv tau los nkag rau hauv cheeb tsam. "Tau qhov twg los" nyob rau hauv cov ntaub ntawv pov thawj qhov rais siv lub algorithm piav qhia ua ntej. Tab sis, yog tias koj xav siv ib lub npe txawv, koj tuaj yeem hloov nws los ntawm ntaus ntawv hauv cov npe.
Yog hais tias daim ntawv sau tso rau hauv lwm phau ntawv, ces kom muaj kev cuam tshuam rau nws, koj yuav tsum tau ua ntawv thov lub txiaj ntsim TAWS. Tus neeg teb xov tooj qhia tseeb yog npaj siab rau "super-absolute" mus rau cov ntawv sau hauv cov ntawv sau. Ua tau, tus txheej txheem yuav ua tau raws nraim tib yam nkaus li hauv cov neeg tau piav txog yav dhau los, tsuas yog hauv thaj teb ntawm "Tau qhov twg los" tom qab ua cim "=" yuav tsum qhia lub npe ntawm tus neeg teb xov tooj - "DVSSYL". Tom qab ntawd, qhov chaw nyob ntawm qhov ntau, nrog rau lub npe ntawm phau ntawv thiab daim ntawv, yuav tsum tau muab teev tias yog ib qho kev sib cav ntawm qhov kev ua haujlwm no. Ua tau, raws li qhia hauv daim duab hauv qab no.

Txij ntawm no mus peb yuav ua tiav cov txheej txheem ntawm nias ntawm lub pob. "OK" nyob hauv cov ntaub ntawv kuaj xyuas qhov rais, tab sis yog tias koj nyiam, koj tuaj yeem txhim kho daim ntawv. Mus rau seem "Tswv yim lus" cov ntaub ntawv kuaj xyuas qhov rais. Nov nyob hauv thaj chaw "Xov xwm" Koj tuaj yeem sau cov ntawv uas cov neeg siv yuav pom los ntawm kev hovering ntau tshaj ib daim ntawv teev npe nrog cov ntawv sau npe. Peb sau cov lus uas peb xav tau.

Tom qab, txav mus rau seem "Cov lus yuam kev". Nov nyob hauv thaj chaw "Xov xwm" Koj tuaj yeem nkag rau hauv cov ntawv uas tus neeg siv yuav soj ntsuam thaum koj sim sau cov ntaub ntawv tsis raug, uas yog, cov ntaub ntawv uas ploj lawm ntawm daim ntawv teev npe. Hauv thaj chaw "Saib" Koj tuaj yeem xaiv lub cim uas yuav tau nrog lus ceeb toom. Sau cov lus ntawm cov lus thiab nias rau "OK".

Zaj Lus Qhia: Yuav ua li cas thiaj ua tau daim ntawv teev npe hauv Excel

Ua haujlwm

Tam sim no cia saib seb yuav ua hauj lwm nrog lub cuab tam uas peb tsim saum toj no.

Yog tias peb teev tus cursor ntawm txhua daim ntawv hauv daim ntawv uas tau sau npe thov, peb yuav pom ib cov lus qhia uas peb tau nkag ua ntej hauv qhov tseeb cov ntaub ntawv tshawb xyuas. Tsis tas li ntawd, ib daim duab peb sab yuav tshwm rau sab xis ntawm tes. Hais tias nws ua hauj lwm pab kom nkag tau xaiv cov npe khoom. Peb nyem rau ntawm daim duab peb sab.

Tom qab txhaj rau nws, cov ntawv qhia los ntawm daim ntawv teev khoom yuav qhib. Nws muaj tag nrho cov ntsiab lus uas tau muab tso ua ntej los ntawm cov ntaub ntawv pov thawj ntawm cov ntaub ntawv. Peb xaiv qhov kev xaiv uas peb xav tau tsim nyog.

Cov kev xaiv xaiv tau muab tso rau hauv lub xov tooj ntawm tes.

Yog tias peb sim nkag mus rau hauv xovtooj ntawm cov nqi uas tsis nyob hauv daim ntawv, ces qhov kev txiav txim no yuav raug thaiv. Nyob rau tib lub sijhawm, yog tias koj nkag rau hauv cov lus ceeb toom hauv cov ntaub ntawv tshawb xyuas cov ntaub ntawv, nws yuav muab tso rau ntawm qhov screen. Nws yog qhov tsim nyog nyob rau hauv lub qhov ceeb toom kom tau nyem rau ntawm lub pob. "Ncua tseg" thiab nrog rau lwm zaus kom nkag mus rau cov ntaub ntawv kom yog.

Nyob rau hauv no txoj kev, yog tias tsim nyog, sau tag nrho lub rooj.

Muab ib yam khoom tshiab

Tab sis ua li cas yog tias koj tseem xav ntxiv ib yam khoom tshiab? Qhov yeeb yam ntawm no yog nyob ntawm seb qhov koj tau tsim muaj li cas nyob rau hauv cov ntaub ntawv txheeb xyuas qhov rais: nkag los ntawm kev tuav tus tes los yog rho tawm ntawm lub rooj cov khoom.

Yog hais tias cov ntaub ntawv rau lub tsim ntawm daim ntawv teev no yog rub los ntawm lub rooj array, ces mus rau nws. Xaiv lub xov tooj ntawm tes. Yog hais tias qhov no tsis yog ib lub rooj ntse, tab sis ib qho yooj yim cov ntaub ntawv, ces koj yuav tsum tau ntxig txoj hlua nyob nruab nrab ntawm cov array. Yog hais tias koj thov "rooj ntse ntse", ces qhov no nws txaus los nkag rau qhov nqi uas yuav tsum muaj nyob rau thawj kab hauv qab nws thiab qhov no yuav tsum tam sim ntawd muab tso rau hauv lub qhov rooj array. Qhov no yog qhov kom zoo dua ntawm cov lus ntse uas peb hais saum toj no.
Tiam sis xav tias peb tabtom ntsuam xyuas nrog cov ntaub ntawv ntau dua, siv qhov sib txawv li ib txwm. Li ntawd, xaiv lub xovtooj ntawm qhov nruab nrab ntawm cov kev cai teev tseg. Ntawd yog, saum toj no lub xov tooj ntawm tes thiab hauv qab nws yuav tsum muaj lwm cov kab. Peb nias rau ntawm cov cim cim nrog tus nas khawm. Hauv daim ntawv qhia zaub mov, xaiv qhov kev xaiv "Muab tshuaj txhuam ...".

Lub qhov rais pib, qhov twg koj yuav tsum xaiv ib qho khoom kwv. Xaiv qhov kev xaiv "Txoj hlua" thiab nyem rau ntawm lub pob "OK".

Yog li ntawd, cov kab lus npliag ntxiv.

Peb nkag mus rau hauv nws qhov nqi uas peb xav kom muab tso tawm rau hauv daim ntawv teev npe.

Tom qab ntawd, peb rov qab mus rau rooj hauv daim ntawv teev npe uas tso npe tawm. Txhawm rau ntawm daim duab peb sab mus rau sab xis ntawm cov xovtooj ntawm cov khoom hauv lub array, peb pom tias tus nqi peb xav tau ntxiv rau cov npe uas twb muaj lawm. Tam sim no, yog tias koj xav, koj tuaj yeem xaiv nws los ntxig rau hauv nws lub rooj.

Tab sis yuav ua li cas yog tias daim ntawv teev cov txiaj ntsig yog rho tawm tsis tau ntawm ib lub rooj cais, tab sis tau manually entered? Ntxiv ib qho hauv qhov no, dhau lawm, nws muaj nws tus kheej algorithm ntawm kev ua.

Xaiv tag nrho cov lus sib txawv, lub ntsiab lus ntawm cov npe ntawm cov ntawv sau tseg. Mus rau lub tab "Cov ntaub ntawv" thiab nyem rau ntawm lub pob dua "Cov Ntaub Ntawv Qhia Tias" hauv ib pawg "Ua hauj lwm nrog cov ntaub ntawv".

Lub tswv yim pib ntawm qhov kev pib nkag pib. Tsiv mus rau seem "Kev xaiv". Raws li koj tau pom, tag nrho cov chaw ntawm no yog tib yam nkaus li peb tau teem caij ua ntej. Peb yog nyob rau hauv cov ntaub ntawv no yuav txaus siab rau hauv cheeb tsam "Tau qhov twg los". Peb ntxiv rau daim ntawv uas twb muaj, sib cais los ntawm lub semicolon (;) tus nqi lossis qhov tseem ceeb uas peb xav pom hauv daim ntawv teev npe cia. Tom qab ntxiv peb nias rau "OK".

Tam sim no, yog tias peb qhib lub npe ntawm cov ntawv sau npe hauv cov rooj zaum, peb yuav pom cov nqi ntxiv rau.

Tshem tawm cov khoom

Qhov kev tshem tawm ntawm daim ntawv teev npe yog ua raws nraim li lub caij nyoog tib algorithm raws li qhov sib ntxiv.

Yog tias cov ntaub ntawv raug rho tawm ntawm cov lus teev rooj, ces mus rau qhov rooj thiab txoj cai-nyem rau ntawm lub xov tooj ntawm qhov uas tus nqi nyob, uas yuav tsum tau muab tshem tawm. Hauv cov ntawv qhia zaub mov, nres qhov kev xaiv ntawm qhov kev xaiv "Rho tawm ...".

Lub qhov rais qhib lub hlwb qhib yog yuav luag tib yam li peb tau pom thaum muab lawv ntxiv. Ntawm no peb tau teem caij mus rau txoj haujlwm "Txoj hlua" thiab nias rau "OK".

Txoj hlua ntawm rooj ua ke, raws li peb pom, yog deleted.

Tam sim no peb rov qab mus rau saum rooj uas lub hlwb nrog daim ntawv teev npe-cia. Peb nyem rau ntawm daim duab peb sab mus rau sab xis ntawm lub xov tooj ntawm tes. Nyob rau hauv daim ntawv uas qhib, peb pom tias cov khoom deleted yog ploj lawm.

Yuav ua li cas yog tias qhov tseem ceeb tau ntxiv rau qhov kev tshawb xyuas cov ntaub ntawv ntawm qhov rais manually, thiab tsis nrog kev pab los ntawm ib lub rooj ntxiv?

Xaiv cov lus nrug nrog ib daim ntawv teev npe cia thiab mus rau ntawm lub qhov rais rau kev kuaj qhov tseem ceeb, raws li peb tau ua ua ntej. Nyob rau hauv qhov kev cai tswjhwm, tshais mus rau seem "Kev xaiv". Hauv thaj chaw "Tau qhov twg los" xaiv cov nqi uas koj xav rho tawm nrog tus cursor. Ces nyem rau ntawm lub pob Rho tawm ntawm cov keyboard.

Tom qab muab cov khoom rho tawm lawm, nyem rau ntawm "OK". Tam sim no nws yuav tsis nyob rau hauv daim ntawv teev npe cia, tib txoj kev raws li peb pom nyob rau hauv qhov kev xaiv yav dhau los nrog rau lub rooj.

Ua tiav tshem tawm

Tib lub sij hawm, muaj ntau lub sijhawm uas qhov chaw sau npe yuav tsum raug tshem tawm tag nrho. Yog hais tias nws tsis ua rau koj tias cov ntaub ntawv nkag tau raug cawm, ces kev sib txuas lus yog yooj yim heev.

Xaiv tagnrho cov array uas lub npe sau xa rov qab. Tsiv mus rau qhov tab "Tsev". Ndliv qhov icon "Tseeb"uas yog muab tso rau hauv kab xev hauv kev thaiv Editing. Hauv daim ntawv qhia tawm, xaiv qhov chaw "Tshem Tag Nrho".

Thaum xaiv qhov no, txhua qhov tseem ceeb ntawm cov ntsiab lus ntawm cov ntawv yuav muab deleted, cov formatting yuav cleared, thiab tsis tas li ntawd, lub hom phiaj tseem ceeb ntawm txoj hauj lwm yuav tsum tiav: daim ntawv teev npe cia yuav raug muab tshem tawm thiab tam sim no koj tuaj yeem nkag rau tej qhov tseem ceeb manually hauv lub hlwb.

Tsis tas li ntawd xwb, yog tias tus neeg siv tsis xav khaws cov ntaub ntawv nkag, ces muaj lwm txoj kev los mus rho tawm cov ntawv sau npe.

Xaiv cov kab kev khoob hlwb, uas yog qhov sib npaug ntawm cov ntsiab lus uas muaj cov ntsiab lus sau tseg. Tsiv mus rau qhov tab "Tsev" thiab muaj peb nyem rau ntawm lub icon "Daim qauv"uas yog nyob rau thaj tsam ntawm thaj chaw "Ntawv Teev Npe".
Tsis tas li ntawd xwb, txhob siv qhov kev ua no, koj tuaj yeem nyem rau ntawm cov lus pom nrog lub khawm txoj kev nas thiab nres ntawm qhov kev xaiv "Daim qauv".
Nws yog yooj yim dua txawm siv cov txheej khawm tam sim ntawd tom qab xaiv. Ctrl + C.
Tom qab ntawd, xaiv qhov fragment ntawm lub rooj array, qhov twg cov ntsiab lus poob nqis. Peb nias lub khawm Muab tshuaj txhuamlaus nyob rau ntawm txoj hlua hauv qhov tab "Tsev" hauv seem "Ntawv Teev Npe".
Qhov kev xaiv thib ob yog rau txoj cai-nias ntawm qhov xaiv thiab nres qhov kev xaiv ntawm qhov kev xaiv Muab tshuaj txhuam hauv ib pawg "Insertion Options".
Thaum kawg, nws yog ib qho ua tau los kos tus cim lub hlwb thiab ntaus ib qho ua ke ntawm cov nyees khawm. Ctrl + V.
Rau ib qho ntawm cov saum toj no, tsis muaj hlwb uas muaj qhov muaj nqis thiab cov npe poob npe, ib qho chaw ntxhua khaub ncaws kiag li yuav muab tso rau.

Yog tias xav tau, tib txoj hauv kev, koj tuaj yeem ntxig rau qhov tsis muaj khoob, tab sis ib phau ntawv thwj toob nrog cov ntaub ntawv. Qhov tsis zoo ntawm cov npe sau npe yog tias koj tuaj yeem tsis txhob sau cov ntaub ntawv uas tsis nyob hauv daim ntawv, tab sis koj tuaj yeem luam thiab muab tshuaj. Hauv qhov no, daim tshev cov ntaub ntawv yuav tsis ua haujlwm. Tsis tas li ntawd xwb, raws li peb pom, cov qauv ntawm cov ntawv sau npe yuav raug rhuav tshem.

Feem ntau, koj tseem yuav tau tshem cov ntawv teev npe cia, tab sis tib lub sijhawm tawm ntawm qhov tseem ceeb uas tau nkag los siv nws, thiab kev hloov. Hauv qhov no, ntau cov kev ua ub ua no yuav tsum tau coj mus tshem tawm cov cuab yeej teev tseg.

Xaiv lub thauv tag nrho uas muaj cov npe nrog cov ntawv sau npe. Tsiv mus rau qhov tab "Cov ntaub ntawv" thiab nyem rau ntawm lub cim "Cov Ntaub Ntawv Qhia Tias"uas, thaum peb nco qab, muab tso rau ntawm kab xev hauv pawg "Ua hauj lwm nrog cov ntaub ntawv".

Lub qhov ncauj tawm tswv yim zoo paub qhib qhov rooj. Nyob hauv ibqho ntawm cov cuab yeej uas tau hais tseg, peb yuav tsum tau ua cov haujlwm nkaus xwb - nyem rau ntawm lub pob. "Tshem Tag Nrho". Nws nyob ntawm sab qis sab laug ntawm lub qhov rais.

Tom qab qhov no, cov ntaub ntawv txheeb xyuas qhov tseeb tuaj yeem raug kaw los ntawm txhaj rau tus khawm txheem nyob hauv nws sab xis saum toj kawg nkaus hauv daim ntawv ntawm tus ntoo khaub lig lossis hauv lub khawm "OK" nyob hauv qab ntawm qhov rais.

Tom qab ntawd xaiv ib qho ntawm cov hlwb uas daim ntawv teev npe tso npe tas yav tas los. Raws li koj pom, tam sim no tsis muaj ib qho tseem ceeb thaum xaiv lub caij, los yog ib daim duab peb sab kom hu rau daim ntawv teev npe mus rau sab xis ntawm tes. Tab sis tib lub sij hawm, lub formatting thiab tag nrho cov nqi nkag siv lub npe tseem si tau zoo. Qhov no txhais tau hais tias peb tau ua haujlwm nrog txoj haujlwm tiav: qhov cuab yeej uas peb tsis tau xav tau yog tshem tawm, tab sis qhov kev tshwm sim ntawm nws txoj haujlwm tseem tsis tau zoo.

Raws li koj tuaj yeem pom, daim ntawv teev npe cia yuav pab tau cov kev qhia txog cov ntaub ntawv rau hauv cov ntxhuav, nrog rau kev tiv thaiv kev qhia txog qhov tsis muaj tseeb. Qhov no yuav txo tau cov xov tooj ntawm cov teeb meem thaum sau rau hauv cov ntxhuav. Yog tias muaj nqis ntxiv yuav tsum ntxiv, ces koj tuaj yeem ua raws li cov txheej txheem kho kom raug. Qhov kev xaiv kho xaiv yuav nyob ntawm qhov kev tsim ntawm kev tsim. Tom qab sau rau hauv lub rooj, koj tuaj yeem tshem daim ntawv teev npe cia, txawm tias nws tsis tsim nyog los ua qhov no. Cov neeg siv feem ntau xav tawm nws txawm tias tom qab kev ua haujlwm tiav rau sau daim ntawv nrog cov ntaub ntawv.