txheem
- 3 Txoj kev nrawm thiab txhim khu kev qha kom tshem tawm cov kab dawb
- Tsis txhob tshem cov kab khoob los ntawm kev xaiv cov hlwb khoob
- Tshem tawm tag nrho cov kab khoob thaum muaj kab tseem ceeb
- Tshem tawm tag nrho cov kab khoob thaum tsis muaj kab tseem ceeb
- Siv cov cuab yeej tshem tawm Empty Lines yog txoj kev yooj yim tshaj plaws thiab ceev tshaj plaws
- Yuav ua li cas tshem tawm cov kab dawb huv hauv 4 cov kauj ruam yooj yim
Kev txawj ntawm kev ua haujlwm nrog Excel program yog qhov tseem ceeb rau cov neeg sawv cev ntawm ntau txoj haujlwm. Hauv tsab xov xwm no, peb yuav xav txog ntau yam teeb meem - tshwj xeeb, vim li cas thiaj tshem kab hauv Excel siv "xaiv cov hlwb tsis muaj -> rho tawm kab" tsis yog lub tswv yim zoo tshaj. Peb kuj yuav tshuaj xyuas 3 Txoj kev nrawm thiab txhim khu kev qha kom tshem tawm cov kab dawb yog li no, kom nws tsis ua puas cov ntaub ntawv nyob rau hauv lwm lub hlwb nyob rau hauv txhua txoj kev. Txhua qhov kev daws teeb meem siv rau Excel 2019, 2016, 2013 thiab ntxov dua.
3 Txoj kev nrawm thiab txhim khu kev qha kom tshem tawm cov kab dawb
Txij li thaum tam sim no koj tab tom saib cov kab lus no, nws yog qhov xav tau los xav tias koj, zoo li ntau lwm tus, yuav tsum tsis tu ncua nrog excel spreadsheets loj loj. Muaj feem yuav yog koj tau hla cov xwm txheej twg cov kab dawb, tiv thaiv feem ntau ntawm cov cuab yeej built-in los ntawm kev lees paub qhov ntau ntawm cov ntaub ntawv. Yog li, txhua lub sij hawm, koj yuav tsum qhia cov ciam teb manually - txwv tsis pub koj yuav tau txais qhov tshwm sim tsis ncaj ncees lawm, thiab nws yuav siv sij hawm koj ntau tshaj li ib teev ntawm lub sij hawm los xyuas thiab kho qhov tsis raug.
Nws tuaj yeem muaj ntau yam laj thawj vim li cas cov kab dawb paug tshwm - piv txwv li, koj tau txais cov ntaub ntawv Excel los ntawm lwm tus, lossis cov ntaub ntawv raug xa tawm los ntawm qee qhov chaw khaws ntaub ntawv, lossis koj yuam kev tshem tawm cov ntaub ntawv hauv cov kab tsis xav tau. Hauv txhua qhov xwm txheej, yog tias koj xav tau tshem tawm cov kab dawb paug thiab yog li ntawd kom muaj lub rooj huv si thiab zoo nkauj, koj yuav tsum tau ua ib tug series ntawm cov kauj ruam yooj yim. Cia peb saib ob peb yam tshwj xeeb ntawm cov ncauj lus hauv qab no:
- Vim li cas koj yuav tsum tsis txhob tshem cov kab khoob los ntawm kev xaiv cov hlwb khoob.
- Yuav ua li cas tshem tawm tag nrho cov kab khoob thaum muaj kab tseem ceeb.
- Yuav ua li cas tshem tawm tag nrho cov kab khoob thaum tsis muaj kab tseem ceeb.
- Yuav ua li cas rho tawm Empty Lines cuab yeej siv, thiab vim li cas nws yog qhov yooj yim tshaj plaws, thiab qhov tseem ceeb tshaj, txoj kev ceev tshaj plaws.
Tsis txhob tshem cov kab khoob los ntawm kev xaiv cov hlwb khoob
Hauv Internet, feem ntau koj tuaj yeem pom cov lus qhia hauv qab no:
- Xaiv tag nrho cov cell uas muaj cov ntaub ntawv, los ntawm 1 mus rau kawg.
- Nias tus yuam sij F5 - Yog li ntawd, lub dialog box "Txoj kev hloov".
- Hauv qhov rai uas qhib, nyem "highlight".
- Hauv qhov rais "Xaiv ib pawg ntawm cov hlwb» xaiv xaiv «cov hlwb khoob", tiam sis"OK".
- Right-click rau ntawm ib lub xov tooj uas tau xaiv, ces xaiv "Rho tawm…".
- Sab hauv lub qhov rais uas qhibTshem tawm cov cell» nyem rau ntawm qhov kev xaiv «txoj hlua".
Tu siab, qhov no tsis yog txoj kev zoo tshaj plaws - siv nws tsuas yog rau cov rooj me me uas cov kab tau tshwm sim hauv qhov screen, lossis zoo dua - tsis txhob siv nws kiag li.
Qhov no yog vim qhov tseeb tias yog tias tsuas muaj ib lub xov tooj khoob hauv kab uas muaj cov ntaub ntawv tseem ceeb, tag nrho cov kab yuav raug tshem tawm.
Cia peb saib ib qho piv txwv. Ua ntej peb yog lub rooj ntawm cov neeg siv khoom, hauv nws nkaus xwb 6 lus. Peb xav rho tawm kab thib peb thiab thib tsib, txij li thaum lawv yog khoob.
Siv cov txheej txheem saum toj no thiab koj yuav tau txais cov hauv qab no:
Kab 4 (Rojer) kuj ploj lawm, vim hais tias nyob rau hauv kab "Tsav qhov chaw". Cell D4 yog khoob.
Txij li thaum koj muaj ib lub rooj me me, koj yuav nrhiav tau tsis muaj cov ntaub ntawv, tab sis nyob rau hauv cov rooj loj uas muaj ntau txhiab kab, koj tuaj yeem tshem tawm ntau ntau cov kab tsim nyog yam tsis tau paub txog nws. Yog tias koj muaj hmoo koj yuav pom tias nws ploj lawm hauv ob peb teev, rov qab koj cov ntaub ntawv los ntawm backupthiab mam li ua dua. Tab sis yuav ua li cas yog tias koj tsis muaj hmoo lossis tsis muaj thaub qab?
Cia peb saib 3 Txoj kev nrawm thiab txhim khu kev qha kom tshem tawm cov kab dawb los ntawm koj cov ntaub ntawv Excel. Thiab yog tias koj xav txuag koj lub sijhawm - mus ncaj qha rau 3rd txoj kev.
Tshem tawm tag nrho cov kab khoob thaum muaj kab tseem ceeb
cov txoj kev tej hauj lwm yog koj muaj ib kem los pab koj xam seb yog ib txoj hlua khoob los tsis tau (hu ua kem tseem ceeb). Piv txwv li, qhov no tuaj yeem yog tus lej xaj, lossis tus neeg siv khoom ID, lossis qee yam zoo sib xws.
Peb yuav tsum tawm mus txoj hlua kab ke tsis hloov, yog li ntawd, yooj yim txheeb los ntawm kab ntawv no thiab hloov tag nrho cov kab khoob mus rau qhov kawg ntawm lub rooj yuav tsis ua haujlwm. Yog li cas yuav tsum ua.
- Xaiv lub rooj kom tiav, los ntawm 1st mus rau kab kawg (kom ua qhov no, koj tuaj yeem tuav ib txhij Ctrl + Tsev, Ntxiv - Ctrl + Ua haujlwm + Xaus).
- teem Autofilter: mus rau tab "Cov ntaub ntawv"thiab nyem rau ntawm lub pob"Lim".
- Tom ntej no, koj yuav tsum tau siv lub lim mus rau "Cust #" ("Cov Neeg Siv Khoom Tsis yog.") kab: nyem rau ntawm lub pob "Autofilter" hauv kab npe, uncheck (xaiv tag nrho), scroll down mus rau qhov kawg (ua tau daim ntawv teev npe ntev heev), ces kos lub thawv "Empty"… Nyem OK.
- Ua ke tag nrho cov kab lim dej: rau qhov no koj tuaj yeem tuav tib lub sijhawm Ctrl + Tsev, ces tus xub xub khawm rov qab mus rau thawj kab dua, ces tuav Ctrl + Ua haujlwm + Xaus.
- Txoj cai-nias ntawm txhua lub xov tooj uas tau xaiv thiab nyem rau ntawm "Rho tawm kab» los yog nias Ctrl + - (tus cim kos npe).
- Nyem rau feem khawm OK thaum teb cov lus nugRho tawm tag nrho lub sij hawm ntawm tsab ntawv?»
- Tom qab ntawd koj yuav tsum tshem tawm cov lim siv: ua qhov no, mus rau "Cov ntaub ntawv"thiab nyem rau ntawm lub pob"Ntxuav".
- Ua haujlwm zoo! Tag nrho cov kab khoob tau ploj mus, thiab kab thib peb (Rojer) tseem nyob ntawd (rau kev sib piv, koj tuaj yeem xa mus rau yav dhau los version).
Tshem tawm tag nrho cov kab khoob thaum tsis muaj kab tseem ceeb
Siv qhov no txoj kevYog tias koj muaj ib lub rooj hauv koj txoj haujlwm nrog ntau lub hlwb khoob tso rau hauv ntau kab, thiab koj xav rho tawm raws nraim cov kab uas kiag li khoob.
kem tseem ceeb, uas tuaj yeem siv los txheeb xyuas seb txoj hlua tsis muaj dab tsi los yog tsis, yog ploj hauv peb qhov piv txwv. Yuav ua li cas? Peb tus kheej tsim ib kab ntawv ntxiv:
- tsim kem "Blanks" ("Empty cells") nyob rau ntawm qhov kawg ntawm koj lub rooj, ces sau rau hauv 1st cell ntawm kab ntawv no tus qauv: = COUNTBLANK (A2: C2).
Qhov no mis suav cov hlwb khoob hauv cov tshuaj ntau yam, qhov twg A2 yog 1st cell, C2 yog lub xeem cell.
- Copy tus qauv rau tag nrho cov cell hauv kab.
- Tam sim no peb muaj kem tseem ceeb. Ces siv lim nyob rau hauv kab "Blanks" (cov lus qhia ntxaws saum toj no) kom pom cov kab nrog tus nqi siab tshaj (3). "3" txhais tau tias cov hauv qab no: tag nrho cov hlwb hauv kab yog khoob.
- Ces xaiv tag nrho lim kab thiab tshem tawm tag nrho npliagsiv cov lus qhia yav dhau los tau piav qhia.
Yog li cov kab khoob (kab 5) muab tshem tawm, thiab kab nrog cov ntaub ntawv tsim nyog nyob hauv qhov chaw.
- Tom ntej no, rho tawm ntxiv kab. Nws yuav tsis xav tau ntxiv lawm. Los yog koj tuaj yeem tso lwm tus lim thiab tso saib kab uas muaj ib lossis ntau lub hlwb khoob.
Txhawm rau ua qhov no, uncheck lub0", ces nias "OK".
Siv cov cuab yeej tshem tawm Empty Lines yog txoj kev yooj yim tshaj plaws thiab ceev tshaj plaws
Txoj kev ceev tshaj plaws thiab zoo tshaj plaws los tshem tawm cov kab dawb yog qhov txheej txheemTshem tawm cov kab dawb paug”, suav nrog hauv cov khoom siv Ultimate Suite rau Excel.
Ntawm lwm yam pab tau zog nws muaj ob peb hlauv taws xob, uas tso cai rau ib tug nias kom txav kab los ntawm dragging; rho tawm tag nrho cov hlwb khoob, kab thiab kab, nrog rau lim los ntawm tus nqi xaiv, suav feem pua, siv cov lej ua lej yooj yim rau ntau yam, luam cov chaw nyob ntawm tes rau cov ntawv teev cia thiab ntau ntxiv.
Yuav ua li cas tshem tawm cov kab dawb huv hauv 4 cov kauj ruam yooj yim
Siv Ultimate Suite, ntxiv mus ntsia rau hauv Excel program, uas yog qhov koj xav tau do:
- Nyem rau qhov twg cell hauv lub rooj.
- Nyem lub tab cuab yeej Abblebits > Hloov Pawg.
- Xovxwm Tshem tawm cov kab dawb paug > Cov kab tsis muaj.
- xovxwm OKkom paub meej tias koj xav tau tiag tiag tshem tawm cov kab khoob.
Qhov ntawd yog txhua yam! Tsuas yog ob peb clicks thiab koj yuav tau txais huv lub rooj, tag nrho cov kab khoob tau ploj mus, thiab qhov kev txiav txim ntawm cov kab tsis txawv txav!