Cov rooj uas muaj cov kab khoob tsis zoo saib zoo nkauj heev. Tsis tas li ntawd xwb, vim tias cov kab ntawv ntxiv, kev ua haujlwm ntawm lawv tuaj yeem nyuaj, txij li koj yuav tsum yauv los ntawm ntau qhov loj ntawm cov kab mob mus rau thaum pib ntawm lub rooj mus txog thaum kawg. Cia peb pom tias dab tsi yog txoj hauv kev tshem cov kab seem hauv Microsoft Excel, thiab yuav ua li cas thiaj li tshem tau sai dua thiab yooj yim dua.
Txheeb cais tawm
Txoj kev nto moo tshaj plaws thiab nrov tshaj plaws rau kev tshem tawm cov kab npliag yog siv Excel cov zaub mov ntawm lub ntsiab lus teb ntawv qhia. Txhawm rau tshem tawm cov kab nyob hauv txoj kev no, xaiv cov ntau ntawm cov hlwb uas tsis muaj cov ntaub ntawv, thiab nias-txoj cai. Hauv cov ntawv qhia zaub mov uas qhib, mus rau qhov "Delete ..." item. Koj tuaj yeem tsis tuaj yeem hu lub ntsiab lus teb tshuab raj, tab sis sau rau ntawm kab ntawv shortcut "Ctrl + -".
Lub qhov rais me me tshwm nyob rau hauv uas koj xav tau qhia meej dab tsi xyov peb xav rho tawm. Peb muab tus tes hloov qhov ua txoj haujlwm "kab". Nyem rau khawm "OK".
Tom qab ntawd, txhua kab ntawm cov xaiv tau txais yuav raug tshem tawm.
Raws li lwm txoj kev xaiv, koj tuaj yeem xaiv cov kab hauv cov kab sib xws, thiab nyob hauv "Tsev" tab, nyem rau ntawm "Rho tawm" khawm, uas nyob hauv "Cells" toolbar ntawm daim xov. Tom qab ntawd, qhov txiav tawm yuav tshwm sim tam sim ntawd yam tsis muaj lub thawv ntawv ntxiv.
Yog lawm, txoj kev yog heev yooj yim thiab zoo-rau. Tab sis nws yog qhov yooj yim dua, sai dua thiab muaj kev nyab xeeb?
Kev cais tawm
Yog tias cov kab npliag nyob hauv ib qho chaw, tom qab ntawd lawv txoj kev tshem tawm lawv yuav yooj yim heev. Tab sis, yog tias lawv tawg thoob plaws hauv rooj, tom qab ntawd lawv tshawb thiab tshem tawm yuav siv sijhawm ntau. Hauv qhov no, kev ua kom zoo yuav tsum tau pab.
Xaiv tag nrho cov ntxhuav. Peb nyem rau ntawm nws nrog txoj khawm nas, thiab xaiv cov "Txawv" yam khoom hauv cov ntawv qhia zaub mov. Tom qab ntawd, muaj lwm lub tshuab raj tawm. Hauv nws koj yuav tsum xaiv ib qho ntawm cov khoom hauv qab no: "Txheeb ib qho ntawm A txog Z", "Txij li tsawg kawg mus rau qhov siab tshaj", lossis "Txij li tshiab mus rau qub." Qhov twg ntawm cov khoom lag luam hauv daim ntawv yuav nyob ntawm hom ntawv uas muab tso rau hauv cov ntawv hlwb.
Tom qab cov haujlwm saum toj no tiav lawm, txhua lub hlwb khoob yuav raug hloov mus rau hauv qab lub rooj. Tam sim no, peb tuaj yeem tshem cov hlwb ntawm ib txoj hauv kev uas tau hais tawm hauv thawj ntu ntawm zaj lus qhia.
Yog tias qhov kev txiav txim ntawm tso cov cell hauv lub rooj yog qhov tseem ceeb, tom qab ntawd ua ntej cais, ntxig rau lwm kab hauv nruab nrab ntawm qhov rooj.
Txhua lub ntawm kem no tau suav ua ntej.
Tom qab ntawv, txheeb los ntawm lwm kab ntawv, thiab rho tawm cov xaum txav mus, raws li tau hais los saum no.
Tom qab ntawd, txhawm rau xa cov kab rov qab rau seem uas yog twb tau ua ntej xaiv, peb txheeb hauv kab ntawv nrog cov kab "Ntawm qhov tsawg kawg nkaus rau qhov siab tshaj".
Raws li koj tuaj yeem pom, cov kab tau muab txoj kab tso rau hauv tib qho kev txiav txim, tsis suav cov khoob uas tau muab tshem tawm. Tam sim no, peb tsuas yog yuav tsum rho tawm kab ntawv ntxiv nrog cov lej ntawm cov lej. Xaiv kab ntawv no. Tom qab ntawd nias rau khawm ntawm "Rho tawm" xov. Hauv cov ntawv qhia zaub mov uas qhib, xaiv qhov "Delete kab ntawm daim ntawv" yam khoom. Tom qab ntawv, cov kem xav tau yuav raug muab lwv tawm.
Zaj lus qhia: Xaiv tawm hauv Microsoft Excel
Lim daim ntawv thov
Lwm qhov kev xaiv los nkaum cov khoob khoob yog siv lub lim.
Xaiv tag nrho cheeb tsam ntawm lub rooj, thiab, nyob hauv "Tsev" tab, nyem rau kab "Tshawb thiab Lim", uas nyob hauv "Kho kom raug" cov chaw teeb tsa. Hauv cov ntawv qhia zaub mov uas tshwm sim, mus rau "Lim" yam khoom.
Lub cim tus yam ntxwv tshwm sim hauv cov kab ntawm lub rooj header. Txheeb rau lub cim no hauv kem ntawm koj xaiv.
Hauv cov ntawv qhia zaub mov uas tsis tshwm, tsis kos lub "Empty" ntawm cov khoom. Nyem rau khawm "OK".
Raws li koj tuaj yeem pom, tom qab ntawd, txhua kab khoob ploj, txij li lawv tau lim.
Tshooj Lus: Yuav ua li cas siv autofilter hauv Microsoft Excel
Cell Xaiv
Lwm txoj kev tshem tawm siv txoj kev xaiv ntawm ib pawg ntawm cov khoob. Txhawm rau siv hom qauv no, ua ntej xaiv tag nrho cov lus. Tom qab ntawd, nyob hauv "Lub Tsev" tab, nyem rau ntawm "Nrhiav thiab Xaiv" khawm, uas nyob rau ntawm pob txhav hauv "Pab Pawg Kho Kom Zoo Nkauj" pab pawg. Hauv cov ntawv qhia zaub mov uas tshwm sim, nyem rau ntawm yam khoom "Xaiv cov pab pawg ntawm lub hlwb ...".
Lub qhov rais qhib nyob rau hauv uas peb hloov lub mus rau "khoob hlwb" txoj hauj lwm. Nyem rau khawm "OK".
Raws li koj tuaj yeem pom, tom qab ntawd, txhua kab uas muaj cov npliag hlwb tau tseem ceeb. Tam sim no nyem rau ntawm lub pob "Rho tawm", uas yog twb paub rau peb, nyob ntawm txoj hlua ntawm "Cells" cov pab pawg.
Tom qab ntawv, txhua kab tas yuav raug tshem tawm ntawm lub rooj.
Cov ntawv ceeb toom tseem ceeb! Qhov kawg txoj kev tuaj yeem siv tsis tau hauv cov kab uas muaj cov kab sib tshooj, thiab nrog cov khoob khoob uas nyob hauv kab uas cov ntaub ntawv muaj. Hauv qhov no, lub sijhawm ua haujlwm ntawm tes yuav tshwm sim thiab lub rooj yuav tawg.
Raws li koj tuaj yeem pom, muaj ob peb txoj hauv kev kom tshem tawm cov khoob ntawm lub rooj. Txoj kev twg zoo dua los siv yog nyob ntawm qhov nyuaj ntawm lub rooj, thiab yuav ua li cas raws nraim cov kab khoob tau tawg nyob ib puag ncig nws (nyob rau hauv ib lub block, lossis sib xyaw nrog kab uas muaj cov ntaub ntawv).