Yuav Paub
- Qhib kab ntawv > xaiv arrow hauv kab xaiv > xaiv Ntxig 1 sab laug lossis Ntxig 1 txoj cai.
- Tom ntej no, xaiv arrow hauv kab kom tshem tawm > xaiv Delete Kab lossis Hide Kem.
- Select View > hover over Freeze > xaiv kab rau khov.
Kab lus no piav qhia yuav ua li cas ntxiv, tshem tawm, thiab kho cov kab hauv Google Sheets.
Yuav ua li cas ntxiv cov kab hauv cov ntawv
Spreadsheets yog tsim los ntawm kab thiab kab, thiab siv lawv kom zoo nws yog ib qho tseem ceeb uas yuav tsum paub yuav ua li cas hloov lawv kom suav nrog cov ntaub ntawv koj xav taug qab lossis cov ntaub ntawv koj xav tswj. Ntxiv ib kab rau ib daim ntawv:
-
Qhib Cov Ntawv Raws li koj ib txwm xav, thiab qhib cov ntawv qhia koj xav ntxiv kab rau.
Image -
Txiav txim siab qhov twg koj xav tau koj kab ntawv thiab hla tsab ntawv saum toj ntawm ib kab ntawm nws. Piv txwv li, ntawm no peb xav ntxiv ib kab nyob nruab nrab ntawm D thiab E, yog li peb hla E.
Image -
Xaiv tus arrow uas zoo nkaus li nqa ib daim ntawv qhia.
Image -
Xaiv Insert 1 left or Insert 1 right, nyob ntawm seb koj xav tso koj kab tshiab.
Image -
Kab tshiab yuav tshwm sim, thiab koj tuaj yeem sau nws nrog koj cov ntaub ntawv.
Image Txhawm rau ntxiv ntau dua ib kab, txiav txim siab qhov twg koj xav tau cov kab thiab xaiv tib tus lej ntawm kab ib sab ntawm lawv. Nyem rau ntawm kab ntawv xub xub nyob rau sab saum toj ntawm ib kab, thiab xaiv Insert X sab laug lossis Ntxig X sab xis (X yuav yog tus lej ntawm kab koj xaiv).
- Kab tshiab thiab cov ntaub ntawv dhau los ua ib feem ntawm koj daim ntawv nthuav qhia.
Yuav ua li cas tshem cov kab hauv Google Cov Ntawv
Cia hais tias kab tshiab tsis ua haujlwm thiab koj xav tshem nws.
-
Qhib Google Sheets raws li koj ib txwm xav, thiab qhib daim ntawv qhia koj xav tshem tawm ib kab ntawm.
Image -
Hover tsab ntawv nyob rau sab saum toj ntawm kab koj xav tshem tawm. Ntawm no peb xav tshem Kab E, yog li peb hla E.
Image -
Xaiv tus arrow uas zoo nkaus li nqa ib daim ntawv qhia.
Image -
Xaiv Delete column. Kab yuav ploj mus.
Txhawm rau rho tawm ntau dua ib kab hauv ib lub sijhawm, xaiv cov kab uas koj xav rho tawm, nyem rau ntawm kab ntawv qhia zaub mov, thiab xaiv Delete kab X-Y (X thiab Y yuav yog thawj thiab kab ntawv kawg uas koj tau hais txog).
Image -
Ob kab ntawm ob sab ntawm kab uas raug tshem tawm tam sim no yuav nyob ib sab ntawm ib leeg.
Image
Yuav ua li cas nkaum kab hauv Google Sheets
Tshwj tsis yog tshem ib kab mus tas li, tej zaum koj xav saib koj cov ntaub ntawv yam tsis muaj kab ntawv ib ntus. Hauv qhov no, koj tuaj yeem nkaum kab ntawv.
-
Qhib Google Sheets raws li koj ib txwm xav, thiab qhib cov ntawv qhia koj xav zais ib kab hauv.
Image -
Hover tsab ntawv nyob rau sab saum toj ntawm kab koj xav nkaum. Ntawm no peb xav zais Kab E, yog li peb hla E.
Image -
Click the arrow uas tshwm los ua zaub mov.
Image -
Xaiv Hide column. Kab yuav ploj mus.
Image -
Koj yuav pom arrows hauv kab ntawm ob sab los qhia tias muaj ib kab zais nyob ntawd. Txhawm rau tshem tawm kab ntawv, nyem ib qho ntawm arrows.
Image
Yuav ua li cas khov kab hauv Google Sheets
Nyob rau hauv daim ntawv nthuav qhia, nws yog ib qho uas siv thawj kab rau cov cim ntawm cov ntaub ntawv hauv kab tom ntej. Hauv peb qhov piv txwv, thawj kab (Kem A) txheeb xyuas cov khoom qab zib qab zib, thiab cov lej hauv kab tom ntej ntawm lawv lub npe sawv cev rau lawv cov khoom muag rau txhua xyoo. Yog tias koj muaj cov kab ntau, tej zaum koj yuav xav saib cov tsis tam sim no hauv koj lub vijtsam thaum tseem ua rau thawj kab qhib kom koj tseem tuaj yeem pom tus cim. Txoj kev siv yog hu ua khov. Nov yog yuav ua li cas khov kab.
-
Qhib Google Sheets raws li koj ib txwm xav tau, thiab qhib cov ntawv qhia koj xav kom khov ib kab hauv.
Image -
Nyob rau sab saum toj ntawm qhov screen, xaiv View thiab hla dhau khov.
Image -
Xaiv tus lej ntawm kab koj xav kom khov. Hauv qhov piv txwv no, peb tsuas yog khov ib kab xwb.
Image -
Koj yuav pom ib qho grey tshwm nyob nruab nrab ntawm cov kab khov thiab tsis khov. Qhov ntawd txhais tau tias koj tuaj yeem saib cov ntaub ntawv hauv cov kab tsis khov yam tsis muaj cov kab khov txav mus.
Image -
Txhob tso tseg, xaiv View > Freeze > Tsis muaj kab.
Image
