Yuav Paub
- Txoj kev yooj yim tshaj plaws los nkaum ib daim ntawv ua haujlwm: right-click the worksheet tab thiab xaiv Hide.
- Txoj hauv kev yooj yim tshaj plaws rau unhide: right-click any worksheet tab, xaiv Unhide, thiab xaiv daim ntawv ua haujlwm kom tsis txhob nkaum.
- Xwb, ntawm kab, mus Home > Format > Hide & Unhide > Hide Sheet or Unhide Sheet.
Cov kab lus no piav qhia yuav ua li cas nkaum thiab tshem tawm cov ntawv ua haujlwm siv cov ntawv qhia zaub mov thiab kab hauv Excel rau Microsoft 365, Excel 2019, 2016, 2013, thiab 2010.
Cov ntaub ntawv siv hauv cov ntawv zais zais
Daim ntawv ua haujlwm Excel yog ib daim ntawv nthuav qhia uas muaj cov hlwb. Txhua lub xovtooj tuaj yeem tuav cov ntawv, tus lej, lossis cov qauv, thiab txhua lub xovtooj tuaj yeem siv lub xovtooj sib txawv ntawm tib daim ntawv ua haujlwm, tib phau ntawv ua haujlwm, lossis phau ntawv ua haujlwm sib txawv.
Los ntawm lub neej ntawd, txhua qhov qhib Excel phau ntawv ua haujlwm tso saib cov ntawv ua haujlwm ntawm lub taskbar hauv qab ntawm lub vijtsam, tab sis koj tuaj yeem nkaum lossis tso saib lawv raws li xav tau. Yam tsawg kawg ib daim ntawv ua haujlwm yuav tsum pom txhua lub sijhawm.
Kev zais daim ntawv ua haujlwm tsis tau txhais hais tias koj tab tom tshem lawv, thiab koj tseem tuaj yeem siv lawv hauv cov qauv thiab cov kab kos nyob ntawm lwm daim ntawv ua haujlwm lossis lwm phau ntawv ua haujlwm.
Hide Worksheets using the Contextual Menu
Cov kev xaiv muaj nyob rau hauv ntsiab lus qhia zaub mov - cov ntawv qhia zaub mov raug nyem - hloov pauv nyob ntawm qhov tau xaiv.
Yog qhov Hide kev xaiv tsis ua haujlwm lossis greyed, feem ntau yuav, phau ntawv ua haujlwm tam sim no tsuas muaj ib daim ntawv ua haujlwm xwb. Excel deactivates Hide kev xaiv rau ib daim ntawv ua haujlwm vim tias yuav tsum muaj tsawg kawg ib daim ntawv pom.
Yuav ua li cas nkaum ib daim ntawv ua haujlwm
- Click the worksheet tab los xaiv nws.
- Right-click ntawm worksheet tab txhawm rau qhib ntsiab lus qhia ntawv.
-
Nyob hauv menu, nyem qhov Hide kev xaiv los nkaum daim ntawv xaiv.
Image Yuav ua li cas nkaum ntau daim ntawv ua haujlwm
- Click the tab ntawm thawj daim ntawv ua haujlwm kom muab zais los xaiv nws.
-
nias thiab tuav nqes tus Ctrl tus yuam sij ntawm cov keyboard.
- Nias lub tabs ntawm cov ntawv ua haujlwm ntxiv los xaiv lawv.
- Right-click on one worksheet tab to open the contextual menu.
- Nyob hauv menu, nyem rau ntawm Hide kev xaiv los nkaum txhua daim ntawv ua haujlwm xaiv.
Hide Worksheets using the Ribbon
Excel tsis muaj keyboard shortcut rau zais cov ntawv ua haujlwm, tab sis koj tuaj yeem siv lub ribbon bar kom ua tiav tib txoj haujlwm.
- Xaiv ib lossis ntau dua worksheet tabs nyob hauv qab ntawm Excel cov ntaub ntawv.
- Click the Home tab ntawm ribbon.
-
Xaiv Format hauv pawg Cells.
Image -
Click on Hide & Unhide.
Image -
Xaiv Hide Sheet.
Image
Unhide Worksheets using the Contextual Menu
Koj tuaj yeem tshem tawm cov tabs siv ntsiab lus qhia zaub mov, ib yam li koj tuaj yeem nkaum lawv.
- Right-click a worksheet tab los qhib lub Unhide dialog box, uas qhia tag nrho cov nplooj ntawv zais tam sim no.
-
Click the sheet koj xav unhide.
Image - Click OK txhawm rau tshem tawm daim ntawv ua haujlwm xaiv thiab kaw lub thawv sib tham.
Unhide Worksheets using the Ribbon
Raws li nrog zais cov ntawv ua haujlwm, Excel tsis muaj keyboard shortcut rau unhiding ib daim ntawv, tab sis koj tseem tuaj yeem siv cov ribbon.
- Xaiv ib lossis ntau dua worksheet tabs nyob hauv qab ntawm Excel cov ntaub ntawv.
-
Click the Home tab ntawm ribbon.
-
Xaiv Format.
Image -
Click Hide & Unhide.
Image - Xaiv Unhide Sheet.
-
Nyem daim ntawv koj xav tso tawm ntawm cov npe uas tshwm.
Image - Click OK.
