Yuav ua li cas txwv kab thiab kab hauv ib daim ntawv Excel

2024 Tus sau: Abigail Brown | [email protected]. Kawg hloov kho: 2023-12-17 06:49

Yuav Paub

• Txawm kom nkaum qee kab: Xaiv lossis qhia cov kab uas koj xav nkaum. Right-click ib kab kab thiab xaiv Hide. Rov ua dua rau kab.
• To unhide: right-click the header for the last pom kab lossis kem thiab xaiv Unhide.
• Txhawm rau txwv ib ntus ntawm cov hlwb: Txoj cai-nias daim ntawv tab > View Code > Properties. Rau ScrollArea, ntaus A1:Z30. Txuag, kaw, thiab rov qhib Excel.

Txhawm rau pab tswj qhov loj ntawm daim ntawv ua haujlwm Excel, koj tuaj yeem txwv cov kab thiab kab uas daim ntawv qhia ua haujlwm. Hauv phau ntawv qhia no, peb qhia koj yuav ua li cas nkaum (thiab unhide) kab thiab kab hauv Excel 2019, Excel 2016, Excel 2013, thiab Excel rau Microsoft 365, nrog rau yuav ua li cas txwv kev nkag mus rau kab thiab kab siv Microsoft Visual Basic rau Daim Ntawv Thov (VBA).

Hide kab thiab kab hauv Excel

Ib txoj hauv kev rau kev txwv thaj chaw ua haujlwm ntawm daim ntawv ua haujlwm yog zais cov ntu ntawm cov kab tsis siv thiab kab; lawv yuav nyob zais txawm tias tom qab koj kaw cov ntaub ntawv. Ua raws li cov kauj ruam hauv qab no txhawm rau zais cov kab thiab kab sab nraum qhov ntau A1:Z30.

1. Qhib koj phau ntawv ua haujlwm thiab xaiv daim ntawv ua haujlwm uas koj xav zais cov kab thiab kab hauv. Nyem lub header rau kab 31 xaiv tag nrho kab.

   

2. Nias thiab tuav lub Shift thiab Ctrl tus yuam sij ntawm cov keyboard. Nyob rau tib lub sijhawm, nias lub down xub tus yuam sij ntawm cov keyboard rau xaiv txhua kab ntawm kab 31 mus rau hauv qab ntawm daim ntawv ua haujlwm. Tso txhua tus yuam sij.

   

3. Right-click ib qho ntawm kab kab txhawm rau qhib ntsiab lus qhia zaub mov. Xaiv Hide.

   

4. Daim ntawv ua haujlwm tam sim no tsuas yog qhia cov ntaub ntawv hauv kab 1 txog 30.

   

5. Click the header for column AA thiab rov ua cov kauj ruam 2 thiab 3 (siv cov right xub tus yuam sij es tsis yog tus xub hauv qab) mus nkaum txhua kab tom qab kem Z.

   

6. Txuag phau ntawv ua haujlwm; cov kab thiab kab tawm sab nraum qhov ntau A1 txog Z30 yuav nyob twj ywm kom txog thaum koj unhide lawv.

   Koj tuaj yeem siv tib txoj kev los nkaum txhua kab lossis kab koj xav tau. Tsuas yog xaiv lub header lossis headers rau kab lossis kab, right-click lub header, thiab xaiv Hide.

Unhide kab thiab kab hauv Excel

Thaum koj xav saib cov ntaub ntawv koj zais, koj tuaj yeem tshem tawm cov kab thiab kab txhua lub sijhawm. Ua raws li cov kauj ruam no kom tshem tawm cov kab thiab kab uas koj zais hauv qhov piv txwv dhau los.

1. Qhib daim ntawv ua haujlwm uas koj tau siv zais kab 31 thiab siab dua thiab kab AA thiab siab dua. Nyem lub headers rau kab 30 (los yog kab pom kawg hauv daim ntawv ua haujlwm) thiab kab hauv qab nws. Right-click tus kab headers thiab, los ntawm cov ntawv qhia zaub mov, xaiv Unhide.

   

2. Cov kab zais tau rov qab los.

   

3. Tam sim no nyem lub headers rau kem Z (los yog kab ntawv kawg pom) thiab kab rau sab xis ntawm nws. Txoj cai-nias ntawm kab ntawv xaiv headers thiab, los ntawm cov ntawv qhia zaub mov, xaiv Unhide. Cov kab ntawv zais tau rov qab los.

   

txwv kev nkag mus rau kab thiab kab nrog VBA

Koj tuaj yeem siv Microsoft Visual Basic rau Daim Ntawv Thov (VBA) txhawm rau txwv ib ntus ntawm cov kab siv tau thiab kab hauv ib daim ntawv ua haujlwm. Hauv qhov piv txwv no, koj yuav hloov cov khoom ntawm daim ntawv ua haujlwm kom txwv tus lej ntawm cov kab muaj rau 30 thiab tus lej ntawm kab rau 26.

Hloov thaj chaw scroll yog qhov ntsuas ib ntus; nws rov pib dua txhua zaus uas phau ntawv ua haujlwm raug kaw thiab rov qhib dua.

1. Qhib ib daim ntawv Excel dawb. Nyob rau hauv qab ntawm qhov screen, right-click lub Sheet1 daim ntawv tab. Los ntawm cov ntawv qhia zaub mov, xaiv View Code.

   

2. The Visual Basic for Applications (VBA) editor windows qhib. Nyob rau sab laug rail, nrhiav qhov Properties ntu.

   

3. hauv Properties, nyob rau sab xis ntawm ScrollArea kab, nyem lub thawv khoob thiab ntaus A1: Z30.

   

4. Xaiv File > Txuag thiab khaws koj phau ntawv ua haujlwm raws li koj xav tau. Xaiv File > Kaw thiab rov qab mus rau Microsoft Excel.

   

5. Kom paub tseeb tias koj qhov kev hloov pauv tau siv, ua qhov kev sim no. Hauv koj daim ntawv ua haujlwm, sim mus rau kab dhau los 30 lossis kab Z. Yog tias qhov hloov pauv tau siv, Excel thaws koj rov qab mus rau qhov kev xaiv ntau thiab koj tsis tuaj yeem hloov kho cov hlwb sab nraud qhov ntau.

   

6. Txhawm rau tshem tawm cov kev txwv, nkag mus rau VBA dua thiab tshem tawm ScrollArea ntau yam.