Yuav Paub
- Hide a kem: Xaiv ib lub xovtooj ntawm kem kom nkaum, tom qab ntawd nias Ctrl+ 0. Txhawm rau tshem tawm, xaiv kab uas nyob ib sab thiab nias Ctrl+ Shift+ 0.
- Hide ib kab: Xaiv ib lub xovtooj ntawm kab uas koj xav nkaum, tom qab ntawd nias Ctrl+ 9. Txhawm rau tshem tawm, xaiv kab uas nyob ib sab thiab nias Ctrl + Shift+ 9.
- Koj tuaj yeem siv txoj cai-nias cov ntawv qhia zaub mov thiab cov hom kev xaiv ntawm Home tab txhawm rau nkaum lossis tshem tawm ib tus kab thiab kab.
Koj tuaj yeem nkaum kab thiab kab hauv Excel los ua daim ntawv ua haujlwm huv yam tsis muaj kev rho tawm cov ntaub ntawv koj xav tau tom qab, txawm hais tias tsis muaj txoj hauv kev los nkaum ib leeg. Hauv phau ntawv qhia no, peb muab cov lus qhia rau peb txoj hauv kev los nkaum thiab tshem cov kab hauv Excel 2019, 2016, 2013, 2010, 2007, thiab Excel rau Microsoft 365.
Hide kab hauv Excel Siv Keyboard Shortcut
Keyboard tseem ceeb ua ke rau zais kab yog Ctrl + 0.
- Nias rau ntawm lub xovtooj ntawm kab ntawv koj xav nkaum kom nws ua haujlwm ntawm tes.
- Nias thiab tuav lub Ctrl tus yuam sij ntawm cov keyboard.
-
Nias thiab tso tus yuam sij 0 yam tsis tso tus yuam sij Ctrl. Cov kem uas muaj cov xovtooj ntawm tes yuav tsum muab zais ntawm qhov pom.
Txhawm rau nkaum ntau kab uas siv cov keyboard shortcut, taw qhia tsawg kawg ib lub xov tooj ntawm txhua kab kom muab zais, thiab tom qab ntawd rov ua dua kauj ruam ob thiab peb saum toj no.
Hide Kem Siv Cov Ntawv Qhia Cov Ntsiab Lus
Cov kev xaiv muaj nyob rau hauv cov ntsiab lus - lossis txoj cai-nias ntawv qhia zaub mov - hloov raws li qhov khoom xaiv thaum koj qhib cov ntawv qhia zaub mov. Yog tias qhov Hidekev xaiv, raws li pom hauv daim duab hauv qab no, tsis muaj nyob hauv cov ntawv qhia zaub mov nws yuav zoo li koj tsis tau xaiv tag nrho kab ua ntej nyem nyem.
Image Hide a Single Kem
- Click the kem header ntawm kem koj xav nkaum kom xaiv tag nrho kem.
- Right-click rau ntawm kab ntawv xaiv los qhib cov ntsiab lus teb.
-
Choose Hide. Cov kab ntawv xaiv, kab ntawv kab, thiab cov ntaub ntawv hauv kab yuav raug muab zais los ntawm kev saib.
Hide Kab uas nyob ib sab
- Nyob hauv kem header, nyem thiab luag nrog tus nas pointer kom pom tag nrho peb kab.
- Right-click rau ntawm kab ntawv xaiv.
- Choose Hide. Cov kab ntawv xaiv thiab kab ntawv yuav raug muab zais tsis pom.
Thaum koj zais kab thiab kab uas muaj cov ntaub ntawv, nws tsis rho tawm cov ntaub ntawv, thiab koj tseem tuaj yeem siv nws hauv cov qauv thiab kab kos. Cov qauv zais zais uas muaj cov ntaub ntawv xovtooj ntawm tes yuav hloov kho yog tias cov ntaub ntawv hauv cov ntaub ntawv hais txog hloov pauv.
Hide Separated Kem
- Nyob hauv kem header nyem rau ntawm thawj kab kom muab zais.
- Nias thiab tuav lub Ctrl tus yuam sij ntawm cov keyboard.
- Txuas ntxiv tuav lub Ctrl thiab nyem ib zaug ntawm txhua kab ntxiv kom muab zais los xaiv lawv.
- Tshuav tus Ctrl tus yuam sij.
- Nyob rau hauv kab ntawv header, right-click rau ib qho ntawm cov kab ntawv xaiv thiab xaiv Hide. Cov kab ntawv xaiv thiab kab ntawv yuav raug muab zais tsis pom.
Thaum zais cov kab sib cais, yog tias tus nas pointer tsis dhau ntawm kab ntawv header thaum koj nias tus nas khawm sab xis, qhov kev xaiv zais yuav tsis muaj.
Nkag thiab tshem cov kab hauv Excel Siv lub Npe Lub Npe
Txoj kev no tuaj yeem siv los tshem tawm txhua kab. Hauv peb qhov piv txwv, peb yuav siv kem A.
-
Ntaus tus xov tooj siv A1 rau hauv lub Npe Lub Npe.
- Nias lub Enter tus yuam sij ntawm cov keyboard kom xaiv cov kab zais.
- Click on the Home tab ntawm ribbon.
- Click on the Format icon ntawm tus ribbon kom qhib qhov poob.
- Nyob rau hauv qhov pom kev pom ntawm cov ntawv qhia zaub mov, xaiv Hide & Unhide > Hide Columns lossis Unhide Kem.
Unhide Kem Siv Keyboard Shortcut
Qhov tseem ceeb ua ke rau cov kab uas tsis muaj kev zais yog Ctrl + Ua haujlwm + 0.
- Hloov lub xovtooj siv A1 rau hauv Npe Box.
- Nias lub Enter tus yuam sij rau ntawm cov keyboard kom xaiv cov kem zais.
- Nias thiab tuav lub Ctrlthiab Shift tus yuam sij ntawm cov keyboard.
-
Nias thiab tso tus yuam sij 0 yam tsis tso tawm Ctrl thiab Shift tus yuam sij.
Txhawm rau tshem tawm ib lossis ntau kab, ua kom pom tsawg kawg ib lub xovtooj ntawm txhua kab ntawm ob sab ntawm kem zais nrog tus nas pointer.
- Nyem thiab luag nrog tus nas kom pom cov kab A rau G.
- Nias thiab tuav lub Ctrl thiab Shift tus yuam sij ntawm cov keyboard.
-
Nias thiab tso tus yuam sij 0 yam tsis tso tus yuam sij Ctrl thiab Shift tus yuam sij. Cov kab uas zais zais yuav pom.
Lub Ctrl + Ua haujlwm + 0 keyboard shortcut yuav tsis ua haujlwm nyob ntawm qhov version ntawm Windows koj tab tom khiav, vim li cas tsis tau piav qhia los ntawm Microsoft. Yog tias qhov shortcut no tsis ua haujlwm, siv lwm txoj hauv kev los ntawm kab lus.
Unhide Kab Siv Cov Ntawv Qhia Txheej Txheem
Raws li nrog txoj hauv kev luv luv saum toj no, koj yuav tsum xaiv tsawg kawg ib kem ntawm ob sab ntawm ib kem zais lossis txhua kab kom tsis txhob zais lawv. Piv txwv li, kom unhide kab D, E, thiab G:
- Hover tus nas pointer hla kab C nyob rau hauv kab header. Nyem thiab luag nrog tus nas kom pom cov kab C rau H kom tshem tawm txhua kab hauv ib zaug.
- Right-click rau ntawm kab ntawv xaiv thiab xaiv Unhide. Cov kab uas zais zais yuav pom.
Hide Kab Siv Shortcut Keys
Cov keyboard tseem ceeb ua ke rau kev zais kab yog Ctrl+9:
- Nias rau ntawm lub xovtooj ntawm kab uas koj xav nkaum kom nws ua haujlwm ntawm tes.
- Nias thiab tuav lub Ctrl tus yuam sij ntawm cov keyboard.
- Nias thiab tso tus yuam sij 9 yam tsis tso tus yuam sij Ctrl. Cov kab uas muaj cov xov tooj ntawm tes yuav tsum muab zais los ntawm kev pom.
Txhawm rau nkaum ntau kab uas siv cov keyboard shortcut, taw qhia tsawg kawg ib lub xov tooj ntawm txhua kab koj xav nkaum, thiab tom qab ntawd rov ua cov kauj ruam ob thiab peb saum toj no.
Hide Kab Siv Cov Ntawv Qhia Txheej Txheem
Cov kev xaiv muaj nyob rau hauv cov ntawv qhia zaub mov - lossis nyem rau sab xis - hloov raws li qhov khoom xaiv thaum koj qhib nws. Yog tias qhov Hide kev xaiv, raws li pom hauv daim duab saum toj no, tsis muaj nyob hauv cov ntawv qhia zaub mov nws yog vim koj zaum tsis tau xaiv tag nrho kab.
Hide ib Kab
- Nias rau ntawm kab header rau kab kom muab zais kom xaiv tag nrho kab.
- Right-click ntawm kab xaiv los qhib cov ntsiab lus teb.
- Choose Hide. Cov kab xaiv, kab ntawv, thiab cov ntaub ntawv hauv kab yuav raug muab zais ntawm qhov pom.
Hide Kab uas nyob ib sab
- Nyob rau hauv kab header, nyem thiab luag nrog tus nas pointer kom pom tag nrho peb kab.
- Right-click rau ntawm cov kab xaiv thiab xaiv Hide. Cov kab uas tau xaiv yuav raug muab zais ntawm qhov pom.
Hide Separated Rows
- Nyob hauv kab header, nyem rau ntawm thawj kab kom muab zais.
- Nias thiab tuav lub Ctrl tus yuam sij ntawm cov keyboard.
- Txuas ntxiv tuav lub Ctrl thiab nyem ib zaug ntawm txhua kab ntxiv kom muab zais los xaiv lawv.
- Right-click rau ntawm ib qho ntawm cov kab xaiv thiab xaiv Hide. Cov kab uas tau xaiv yuav raug muab zais ntawm qhov pom.
Nkag thiab Unhide Kab Siv Lub Npe Lub Npe
Txoj kev no tuaj yeem siv los tshem tawm ib kab. Hauv peb qhov piv txwv, peb yuav siv kab 1.
- Hloov lub xovtooj siv A1 rau hauv Npe Box.
- Nias lub Enter tus yuam sij ntawm cov keyboard xaiv cov kab zais.
- Click on the Home tab ntawm ribbon.
- Click on the Format icon ntawm tus ribbon los qhib cov ntawv qhia zaub mov.
- Nyob rau hauv qhov pom kev pom ntawm cov ntawv qhia zaub mov, xaiv Hide & Unhide > Hide Rows lossis Unhide Kab.
Unhide Kab Siv Keyboard Shortcut
Qhov tseem ceeb ua ke rau cov kab uas tsis zais yog Ctrl+Shift+9.
Unhide Kab siv Shortcut Keys thiab Lub Npe Lub Npe
- Hloov lub xovtooj siv A1 rau hauv Npe Box.
- Nias lub Enter tus yuam sij ntawm cov keyboard xaiv cov kab zais.
- Nias thiab tuav lub Ctrlthiab Shift tus yuam sij ntawm cov keyboard.
- Nias thiab tuav lub Ctrl thiab Shift tus yuam sij ntawm cov keyboard. Kab 1 yuav pom.
Unhide Kab Siv Keyboard Shortcut
Txhawm rau tshem tawm ib lossis ntau kab, taw qhia tsawg kawg ib lub xov tooj ntawm cov kab ntawm ob sab ntawm cov kab zais nrog tus nas pointer. Piv txwv li, koj xav unhide kab 2, 4, thiab 6.
- Txhawm rau tshem tawm txhua kab, nyem thiab luag nrog tus nas kom pom kab 1 txog 7.
- Nias thiab tuav lub Ctrlthiab Shift tus yuam sij ntawm cov keyboard.
- Nias thiab tso tus lej 9 tus yuam sij yam tsis tso tus yuam sij Ctrl thiab Shift tus yuam sij. Cov kab zais (s) yuav pom.
Unhide Kab Siv Cov Ntawv Qhia Txheej Txheem
Raws li nrog txoj hauv kev luv luv saum toj no, koj yuav tsum xaiv tsawg kawg ib kab ntawm ob sab ntawm kab zais lossis kab kom tsis txhob zais lawv. Piv txwv li, kom unhide kab 3, 4, thiab 6:
- Hover the mouse pointer over row 2 in the row header.
- Click thiab luag nrog tus nas kom pom kab 2 txog 7 kom tshem tawm txhua kab ib zaug.
- Right-click rau ntawm cov kab xaiv thiab xaiv Unhide. Cov kab zais (s) yuav pom.
