Yuav ua li cas khov thiab tsis khov kab lossis kab hauv Google Cov Ntawv

Cov txheej txheem:

Yuav ua li cas khov thiab tsis khov kab lossis kab hauv Google Cov Ntawv
Yuav ua li cas khov thiab tsis khov kab lossis kab hauv Google Cov Ntawv
Anonim

Yuav Paub

  • Nyob hauv qhov browser, xaiv kab thiab tom qab ntawd xaiv View > Freeze. Xaiv qhov koj xav tau.
  • Ntawm lub xov tooj ntawm tes, qhib Sheets app thiab xaiv kab lossis kab. Qhib cov ntawv qhia zaub mov, xaiv peb lub dots, thiab tom qab ntawd xaiv Freeze.

Thaum ua haujlwm nrog daim ntawv loj loj, khaws cov kab tshwj xeeb lossis kab ib txwm saib tuaj yeem pab tau. Tej zaum koj xav tau cov kab ntawv kab ntawv los tso saib thaum koj nqes hauv nplooj ntawv, lossis tej zaum koj xav sib piv ob kab ntawm cov ntaub ntawv uas nyob deb ntawm ib leeg. Nov yog yuav ua li cas khov thiab tsis khov kab thiab kab hauv Google Sheets siv lub web browser thiab mobile app.

Txias kab hauv Daim Ntawv Web App

Hauv qhov piv txwv no, peb yuav khov thawj kab los qhia tias nws ua haujlwm li cas thaum koj txav deb ntawm thawj kab.

  1. Xaiv kab koj xav kom khov.

    Nias lossis coj mus rhaub tus lej kab rau sab laug ntawm kab koj xav kom khov los xaiv tag nrho kab. Txhawm rau xaiv tag nrho kab, xaiv tsab ntawv saum toj kawg nkaus.

  2. Xaiv View> Freeze.

    Image
    Image
  3. Los ntawm cov kev xaiv uas tau tshwm sim, xaiv qhov uas haum koj xav tau.

    • No rows: Unfreezes all rows.
    • 1 kab: Txias thawj kab.
    • 2 row: Txias thawj ob kab.
    • Up to tam sim no kab (x): Txuag tag nrho cov kab mus rau ib qho tam sim no tau xaiv, sawv cev los ntawm x.
    • Tsis muaj kab: Unfreezes tag nrho kab.
    • 1 kem: Txuag thawj kab.
    • 2 kab: Txuag thawj ob kab.
    • Up to tam sim no kab (x): Txuag tag nrho txhua kab mus txog qhov uas tau xaiv tam sim no, sawv cev los ntawm x.
    Image
    Image

Thaum koj scroll kab rov tav lossis ntsug, kab lossis kab uas koj xaiv kom khov tseem nyob hauv saib txawm tias koj nyob qhov twg hauv daim ntawv nthuav qhia.

Txhawm rau tshem tawm ib kab lossis kab tom qab, ua raws cov kauj ruam 1 thiab 2 dua thiab xaiv Tsis muaj kab lossis Tsis muaj kab.

Txuag ib kab lossis kab ntawm lub xov tooj smartphone lossis ntsiav tshuaj

Ua raws li cov lus qhia no kom khov kab thiab / lossis kab hauv Android thiab iOS (iPad, iPhone, iPod kov) cov khoom siv.

Cov kauj ruam hauv qab no tau ua tiav hauv Android version 8 tab sis yuav zoo ib yam ntawm cov khoom siv.

  1. Xaiv Google Sheets app.
  2. Qhib daim ntawv tshaj tawm uas koj ua haujlwm rau (lossis tsim ib qho tshiab).
  3. Xaiv kab lossis kab uas koj xav kom khov los ntawm tapping rau nws ib zaug kom nws ua qhov tseem ceeb.

    Coj mus rhaub tus lej kab rau sab laug ntawm kab koj xav kom khov kom xaiv tag nrho kab. Txhawm rau xaiv tag nrho kab, xaiv tsab ntawv saum toj kawg nkaus.

  4. Coj mus rhaub rau kab uas tseem ceeb dua kom cov ntsiab lus qhia tshwm.

  5. Coj mus rhaub peb lub dots ntawm sab xis los qhib cov ntsiab lus qhia zaub mov.
  6. Xaiv FREEZE.

    Image
    Image

Tam sim no, thaum koj scroll kab rov tav lossis ntsug, kab lossis kab uas koj xaiv kom khov tseem nyob hauv saib txawm tias koj nyob qhov twg hauv daim ntawv nthuav qhia.

Txhawm rau tshem tawm ib kab lossis kab tom qab, ua raws cov kauj ruam 3 thiab 4 dua thiab xaiv UNFREEZE COLUMN lossis UNFREEZE ROW.

Pom zoo: