Ntxhuav nrog cov kab tas yog tsis zoo nkauj heev. Tsis tas li ntawd, vim hais tias ntawm cov kab ntxiv, los ntawm lawv tuaj yeem ua nyuab dua, vim tias koj yuav tsum los ntawm ntau ntau lub hlwb mus rau thaum pib ntawm lub rooj mus txog thaum kawg. Cia peb nrhiav seb cov kev tshem tawm kab dawb hauv Microsoft Excel, thiab tshem tawm lawv sai npaum li cas.
Txheem deletion
Cov feem ntau nrov thiab nrov txoj kev kom tshem cov khoob khoob yog siv cov ntsiab lus teb ntawm lub Excel qhov kev pab cuam. Tshem tawm cov kab nyob rau hauv txoj kev no, xaiv ib thaj tsam ntawm cov hlwb uas tsis muaj cov ntaub ntawv, thiab txoj cai-nias. Hauv cov ntawv qhia zaub mov qhib, peb mus rau qhov "Delete ...". Koj tuaj yeem hu tsis tau cov ntsiab lus teb tab sis ntaus cov keyboard shortcut "Ctrl + -".
Ib lub qhov rais me me tshwm nyob rau hauv uas koj yuav tsum qhia kom meej meej raws nraim peb xav rho tawm. Peb muab tus tes hloov mus rau txoj hauj lwm "txoj hlua". Nias rau ntawm "OK" khawm.
Tom qab ntawd, tag nrho cov kab ntawm cov kev xaiv yuav raug muab tshem tawm.
Xwb, koj tuaj yeem xaiv lub hlwb nyob rau hauv cov kab, thiab thaum nyob hauv lub Tsev tab, nias rau lub Delete khawm, uas nyob rau hauv cov thawv Cell ntawm txoj kab. Tom qab ntawd, nws yuav muab deleted tam sim ntawd tsis muaj cov kab ntawv ntxiv.
Ntawm chav kawm, txoj kev yog heev yooj yim thiab zoo-paub. Tab sis, nws puas yog qhov yooj yim tshaj, ceev thiab ruaj ntseg?
Tsi
Yog tias cov kab dawb paug nyob rau hauv tib qhov chaw, tom qab rho cov ntawv lawv yuav haum yooj yim. Tab sis, yog tias lawv tau tawg khiav thoob plaws hauv lub rooj, lawv tshawb thiab tshem tawm yuav siv sij hawm ntau. Qhov no, kev faib tawm yuav tsum pab.
Xaiv tag nrho cov lus teb. Nias rau sab xis nrog tus nas khawm, thiab hauv cov ntawv qhia zaub mov ntawv xaiv qhov khoom "Tsi". Tom qab ntawd, lwm cov zaub mov tshwm. Hauv nws, koj yuav tsum xaiv ib qho ntawm cov hauv qab no: "Tsi ntawm A rau Z", "Los ntawm qhov tsawg kawg nkaus rau qhov siab", lossis "Los ntawm tshiab rau cov laus." Cov twg ntawm cov khoom teev rau hauv yuav muaj nyob rau hauv cov ntawv qhia zaub mov nyob ntawm seb cov ntaub ntawv uas muab tso rau hauv lub hlwb ntawm lub rooj.
Tom qab ua haujlwm tiav tas lawm, txhua lub hlwb yuav txav mus rau hauv lub qab rooj. Tam sim no, peb tuaj yeem lwv cov hlwb no tawm hauv ib qho ntawm txoj hauv kev sib tham hauv thawj feem ntawm zaj lus qhia.
Yog hais tias qhov kev txiav txim siab ntawm qhov tso rau hauv lub rooj yog qhov tseem ceeb, ces ua ntej peb ua qhov kev faib tawm, peb ntxig rau lwm kem hauv nruab nrab ntawm lub rooj.
Tag nrho cov hlwb nyob hauv kab ntawv no yog muab suav ua.
Tom qab ntawd, peb xaiv los ntawm lwm cov sab, thiab tshem tawm cov qia hlwb, raws li tau piav saum toj no.
Tom qab ntawd, xwv kom rov xa qhov kev txiav txim ntawm cov kab mus rau ib qho uas twb ua ntej qhov kev faib tawm, peb txheeb nyob rau hauv kem nrog cov kab xov tooj "Los ntawm yam tsawg kawg nkaus rau qhov siab".
Raws li koj tau pom, cov kab yog hlua rau tib qho kev txiav txim, tshwj tsis yog rau qhov kev npliag, uas tau muab deleted. Tam sim no, peb nyuam qhuav xav rho tawm cov kab kem ntxiv nrog cov lej. Xaiv cov kem no. Ces nias lub khawm ntawm "Delete" kab xev. Hauv daim ntawv qhia tawm, xaiv qhov khoom "Tshem txhua ntawm daim ntawv." Tom qab ntawd, lub sab nraud xav tau muab tshem tawm.
Tshooj: Xaiv hauv Microsoft Excel
Thov lim
Lwm qhov kev xaiv los nkaum hauv hlwb yog siv lub lim.
Xaiv tag nro ntawm lub rooj, thiab, nyob hauv tab "Tsev", nias qhov "Tsi thiab lim" khawm, uas nyob rau ntawm "Editing" qhov chaw. Nyob rau hauv cov ntawv qhia zaub mov uas tshwm, ua rau kev hloov mus rau qhov "Filter".
Ib qho txawv lwm tus cim tshwm nyob rau hauv lub hlwb ntawm lub rooj hau lus. Nias ntawm daim ntawv no rau txhua kem ntawm koj xaiv.
Hauv daim ntawv qhia tias, tsis pom lub thawv "Empty". Nias rau ntawm "OK" khawm.
Raws li koj tau pom, tom qab no, tag nrho cov kab tas lawm, raws li lawv tau lim.
Nyeem: Yuav ua li cas siv ib qho pib lim hauv Microsoft Excel
Cell xaiv
Lwm txoj kev deletion siv txoj kev xaiv ntawm ib pab pawg neeg khoob hlwb. Yog xav siv hom no, xub xaiv tag nrho cov lus. Tom qab ntawd, nyob hauv "Tsev" tab, nias qhov "Find and highlight" khawm, uas nyob rau ntawm daim qauv xov rau "Kho kom raug" pab pawg. Hauv daim ntawv qhia zaub mov, nyem qhov khoom "Xaiv ib pawg ntawm hlwb ...".
Lub qhov rais qhib hauv qhov uas peb tsiv mus rau qhov kev hloov mus rau "qhov chaw khoob hauv hlwb". Nias rau ntawm "OK" khawm.
Raws li koj tau pom, tom qab no, tag nrho cov kab uas muaj cov hlwb tsis muaj hlwb. Tam sim no nias qhov "Delete" khawm twb paub txog peb, nyob rau ntawm daim qauv ntawm cov "Cells" tuam pab pawg.
Tom qab ntawd, tag nrho cov kab kev npliag yuav raug muab tshem tawm ntawm lub rooj.
Tseem ceeb ntawv! Txoj kev tom kawg no tsis tuaj yeem siv hauv cov ntxhuav nrog overlapping ranges, thiab nrog cov qoob hlwb uas nyob hauv cov kab uas muaj cov ntaub ntawv muaj. Hauv qhov no, lub hlwb yuav hloov, thiab lub rooj yuav tawg.
Raws li koj tau pom, muaj ntau txoj hauv kev los tshem cov qoob hlwb ntawm lub rooj. Txoj kev twg yog qhov zoo dua yog siv nyob ntawm qhov nyuaj ntawm lub rooj, thiab nyob li cas nraim cov kab khiav nkaum nyob ib ncig ntawm nws (teem rau hauv ib lub block, los yog tov nrog cov kab uas muaj cov ntaub ntawv).
