txheem
Hauv Excel, tus neeg siv tuaj yeem tsim thiab ua haujlwm ntawm ob peb nplooj ntawv ib zaug. Thiab qee zaum, rau ntau yam laj thawj, tej zaum yuav xav tau zais qee yam ntawm lawv. Piv txwv li, nyob rau hauv saib ntawm lub siab xav mus nkaum cov ntaub ntawv tseem ceeb ntawm prying ob lub qhov muag, uas tej zaum yuav tsis pub leej twg paub thiab muaj, hais, coj mus muag tus nqi. Los yog, tus neeg siv tsuas yog xav tiv thaiv nws tus kheej los ntawm kev ua yuam kev nrog cov ntaub ntawv ntawm ib daim ntawv uas yuav tsum tsis txhob kov.
Yog li, yuav ua li cas nkaum ib daim ntawv hauv Excel? Nws muaj ob txoj hauv kev los ua qhov no. Cia peb saib ib leeg thiab.
Cov ntsiab lus: "Hidden nplooj ntawv hauv Excel"
Qhov no yog txoj kev yooj yim tshaj plaws thiab ceev tshaj plaws los nkaum ib daim ntawv, uas yog ua tiav hauv 2 kauj ruam xwb.
- Txhawm rau ua qhov no, peb yuav tsum hu rau cov ntawv qhia zaub mov los ntawm txoj cai-nias ntawm daim ntawv xav tau.
- Xaiv "Hide" los ntawm cov npe uas tshwm.
- Qhov tseeb, yog txhua yam. Daim ntawv yuav tsum tau muab zais.
Nkaum siv cov cuab yeej program
Ib txoj kev tsis tshua nyiam, tab sis tseem, kev paub txog nws yuav tsis yog superfluous.
- Ua ntej, xaiv daim ntawv uas koj xav nkaum.
- Mus rau "Tsev" tab, nyem rau ntawm "Cells", hauv cov kev xaiv uas tshwm sim, xaiv "Format".
- Hauv cov npe uas qhib, xaiv "Hide lossis qhia" thiab tom qab ntawd "Hide sheet".
- Daim ntawv xaiv yuav raug muab zais.
Nco ntsoov: Yog hais tias qhov ntev ntawm lub qhov rais nrog qhov kev pab cuam Excel tso cai, lub "Format" khawm yuav tam sim ntawd tshwm nyob rau hauv lub "Tsev" tab, bypassing lub "Cells" toolbox.
Yuav ua li cas nkaum ntau daim ntawv
Cov txheej txheem rau nkaum ob peb nplooj ntawv, qhov tseeb, yog xyaum tsis txawv ntawm cov uas tau piav saum toj no. Txawm li cas los xij, ua ntej pib nrog nws, koj yuav tsum xaiv tag nrho cov nplooj ntawv uas yuav tsum tau muab zais.
- Yog tias cov nplooj ntawv tau teeb tsa ua ke, tus yuam sij Shift yuav los ua ke. Xaiv thawj daim ntawv, tuav tus yuam sij Hloov, thiab tsis tso nws, nyem rau ntawm daim ntawv kawg, ces tso tus yuam sij. Kev xaiv kuj tseem tuaj yeem ua nyob rau hauv qhov sib txawv - los ntawm qhov kawg mus rau thawj. Lawm, peb tab tom tham txog thawj thiab kawg nplooj ntawv uas yuav tsum tau muab zais.
- Yog tias cov nplooj ntawv yuav tsum muab zais tsis tau teeb tsa ua ke, lawv yuav tsum raug xaiv siv Ctrl key (Cmd - rau macOS). Peb tuav nws cia thiab nias rau ntawm tag nrho cov nplooj ntawv uas yuav tsum tau muab zais. Tom qab ntawd koj tuaj yeem tso tus yuam sij Ctrl.
- Peb tau xaiv tag nrho cov ntawv tsim nyog, tam sim no koj tuaj yeem nkaum lawv siv ib qho ntawm cov txheej txheem uas tau hais ua ntej. Qhov tshwm sim yuav zoo ib yam.
xaus
Yog li, peb tsuas yog xav paub yuav ua li cas nkaum cov ntawv hauv Excel hauv ob txoj hauv kev. Txawm hais tias koj xaiv qhov twg, qhov muaj txiaj ntsig ntawm qhov kev ua haujlwm no hauv qee kis yog qhov pom tseeb, yog li kev paub thiab kev muaj peev xwm siv nws yuav pab tawm cov neeg siv uas feem ntau ua haujlwm nrog cov haujlwm ntau dua ib zaug.