Raws li koj paub, nyob rau hauv phau ntawv ntawm Excel muaj qhov tsim ntawm ntau cov nplooj ntawv. Tsis tas li ntawd, qhov kev tso dag tso tawm yog teeb tsa kom cov ntaub ntawv twb muaj peb lub ntsiab lus thaum nws raug tsim. Tab sis, muaj qee cov neeg mob xav rho tawm ib co ntaub ntawv los yog khoob kom lawv tsis txhob cuam tshuam nrog lawv. Cia peb pom tias qhov no yuav ua li cas rau ntau txoj hauv kev.
Tshem tawm txoj cai
Nyob hauv Excel, nws yog ib qho ua tau los mus rho tawm ob qho tib si ib daim ntawv thiab ntau. Xav seb qhov no ua li cas hauv kev xyaum.
Method 1: deletion ntawm cov ntawv qhia zaub mov
Qhov yoojyim thiab feem ntau intuitive txoj hauv kev ua txoj haujlwm no yog siv lub sijhawm los ntawm cov ntawv qhia zaub mov. Peb txoj cai-nias rau ntawm daim ntawv uas tsis tas yuav ntxiv. Hauv daim ntawv teev cov ntsiab lus tseem ceeb, xaiv qhov khoom "Rho tawm".
Tom qab qhov kev txiav txim no, daim ntawv tshem tawm ntawm daim ntawv teev cov khoom saum toj no cov xwm txheej.
Txoj kev 2: kev tshem tawm cov cuab yeej ntawm kab xev
Nws yog ib qho ua tau kom tshem tawm ib qho tsis tseem ceeb uas siv cov cuab yeej nyob rau ntawm daim kab xev.
- Mus rau ntawm daim ntawv tias peb xav tshem tawm.
- Thaum nyob hauv tab "Tsev" nyem rau ntawm lub khawm ntawm daim kab xev "Rho tawm" nyob rau hauv lub block ntawm cov cuab yeej "Hlwb". Nyob rau hauv cov ntawv qhia zaub mov uas tshwm sim, nyem rau ntawm daim duab hauv daim duab ntawm ib daim duab peb sab nyob ze ntawm lub pob "Rho tawm". Nyob rau hauv cov ntawv qhia zaub mov uas qhib, peb tso peb xaiv ntawm qhov khoom "Rho tawm ntawv".
Cov ntawv xov xwm yuav muab tshem tawm sai sai.
Method 3: rho tawm ntau yam khoom
Ua tau, txoj kev tshem tawm nws tus kheej yog raws nraim tib yam li hauv ob txoj hauv kev piav qhia saum toj no. Tsuas yog kom tshem tawm ob peb nplooj ntawv, ua ntej pib ua haujlwm, peb yuav tau xaiv lawv.
- Yog xav xaiv cov khoom uas tau teem tseg, tuav lub ntsiab Ua haujlwm. Tom qab ntawd nias ntawm thawj lub caij, thiab tom qab ntawd ces nyob rau hauv lub xeem, ua rau lub pob nyem khawm.
- Yog hais tias cov ntsiab lus uas koj xav kom tshem tawm tsis tuaj yeem ua ke, tab sis yuav tawg, ces qhov no koj yuav tsum tuav khawm Ctrl. Tom qab ntawd nias rau ntawm txhua daim ntawv npe uas koj xav rho tawm.
Tom qab lub ntsiab raug xaiv, tshem tawm lawv, koj yuav tsum siv ib txoj kev ntawm ob txoj kev, uas tau sib tham saum toj no.
Tshooj: Yuav ua li cas ntxiv ib daim ntawv hauv Excel
Raws li koj tau pom, tshem tawm cov ntawv tsis tseem ceeb hauv kev pabcuam Excel yog qhov yooj yim heev. Yog tias xav tau, nws tseem muaj peev xwm rho tawm ntau yam khoom tib lub sijhawm.
