Yuav Paub
- Txhawm rau rho tawm ib kab, nyem rau ntawm kab kab thiab xaiv Delete los ntawm cov ntawv qhia zaub mov uas tshwm.
- Delete rows on the home tab: Nrhiav & Xaiv > Nco mus tshwj xeeb > Blanks > OKpab kom meej cov kab dawb, ces Delete > Delete Sheet Rows.
- Txhawm rau rho tawm ib kab uas siv cov keyboard shortcuts, taw qhia kab thiab nias Ctrl + - ntawm koj cov keyboard.
Kab lus no piav qhia peb txoj hauv kev rau kev rho tawm cov kab dawb paug hauv Excel daim ntawv nthuav qhia hauv Microsoft Excel 2019, Excel 2016, thiab Office 365, suav nrog kev tshem tawm manually, siv keyboard shortcut, thiab siv qhov Nrhiav & Xaiv xaiv.
Ob txoj hauv kev los rho tawm Ib tus kab hauv Microsoft Excel
Yog tias koj ua haujlwm nrog daim ntawv me me, tsis yooj yim, muaj ob peb txoj hauv kev yooj yim los tshem tawm ib kab lossis ob peb kab yam tsis muaj teeb meem ntau dhau. Qhov yooj yim ntawm txoj hauv kev no yog txhawm rau txhawm rau txhawm rau txhawm rau txhawm rau txhawm rau txhawm rau txhawm rau txhawm rau txhawm rau txhawm rau txhawm rau txhawm rau txhawm rau txhawm rau txhawm rau txhawm rau txhawm rau txhawm rau txhawm rau txhawm rau txhawm rau txhawm rau txhawm rau tshem tawm kab. Qhov no yooj yim thiab yooj yim yog tias koj tsuas muaj tus lej me me lossis txawm tias qee zaus txoj kab tsis raug tshem tawm.
Xav tau tshem tawm ob lossis peb kab hauv tib cheeb tsam ntawm daim ntawv tshaj tawm? Tsis muaj teeb meem. Teeb tsa thawj kab, tom qab ntawd tuav lub Ctrltus yuam sij ntawm koj cov keyboard thiab xaiv lwm kab. Thaum tag nrho cov kab uas koj xav rho tawm raug qhia, nias Ctrl + - ntawm cov keyboard kom tshem tawm tag nrho cov kab xaiv.
Lwm txoj hauv kev yooj yim los rho tawm ib kab hauv Microsoft Excel yog txoj cai-nias tus lej kab thiab tom qab ntawd xaiv Delete los ntawm cov ntawv qhia zaub mov uas tshwm. Qhov no tshem tawm tsuas yog kab uas xaiv.
Yuav ua li cas rho tawm Empty Kab hauv Excel Nrog Nrhiav & Xaiv
Yog tias koj ua haujlwm nrog daim ntawv loj dua hauv Excel, tshem cov kab ib tus zuj zus, lossis qee zaum ib zaug, tuaj yeem mob, tsis hais txog sijhawm siv sijhawm. Hmoov zoo, muaj ib txoj hauv kev yooj yim los tshem tawm tag nrho koj cov kab dawb huv ib zaug.
-
Nyob rau hauv daim ntawv uas koj xav rho tawm kab, mus rau Home tab thiab xaiv Nrhiav & Xaiv los ntawmEditing pab pawg.
Image -
Nyob hauv cov ntawv qhia zaub mov uas tshwm, xaiv Mus rau Tshwj Xeeb.
Image -
The Go to Special dialog box tshwm. Nias lub xov tooj cua ntawm ib sab ntawm Blanks thiab mam li nias OK.
Image -
Qhov no yuav xaiv tag nrho cov kab dawb huv hauv koj daim ntawv teev npe.
Ceev faj thaum siv txoj kev no los xaiv kab dawb. Yog tias koj muaj kab uas tsuas yog ua tiav ib nrab, cov kab yuav raug xaiv thiab tshem tawm thaum koj ua tiav cov kauj ruam hauv cov lus qhia no. Yog tias koj tsis xav rho tawm cov kab ua tiav ib nrab, koj yuav tau siv cov Ctrl + nias txoj kev xaiv kab uas tau hais saum toj no.
-
Nrog cov kab xaiv, ntawm Home tab, xaiv Delete los ntawm Cells group.
Image -
Los ntawm Delete ntawv qhia, xaiv Delete Sheet Rows.
Image -
Xwb, ib zaug cov kab dawb raug xaiv, koj tuaj yeem siv cov keyboard shortcut Ctrl + -. Qhov no qhib ib lub Delete dialog box, nyob rau hauv uas koj yuav tsum xaiv lub xov tooj cua khawm nyob ib sab ntawm Tag nrho cov kab thiab nias OK.
Yog tias koj tsis pom zoo rho tawm kab uas koj yuav tsum tau coj rov qab ua ntej koj ua lwm yam ntawm daim ntawv ua haujlwm, nias Ctrl + Z rau koj cov keyboard los undo qhov rho tawm ua. Qhov no yuav coj rov qab tag nrho cov kab uas koj nyuam qhuav deleted, txawm li cas los xij, yog li koj yuav tau rov qab rho tawm lwm kab.
