Yuav Paub
- Xaiv thiab nyem rau sab xis, xaiv Tiv Thaiv Ntau , thiab muab lub npe. Nyem Set permissions thiab xaiv los qhia ceeb toom lossis txwv kev kho.
- Xaiv hlwb: Xaiv Data > Cov ntawv tiv thaiv thiab ntau yam, nyem lub hlwb hauv sidebar, xaiv qhov lub thoob khib nyiab icon, thiab xaiv Remove.
Spreadsheets yog cov ntaub ntawv tsis yooj yim; Nws yog ib qho yooj yim los hloov lub xov tooj ntawm tes uas "lov" ib qho kev suav, rhuav tshem cov formatting, lossis ua rau cov ntaub ntawv tsis raug. Tias yog vim li cas nws tseem ceeb heev kom paub yuav ua li cas kaw cov hlwb hauv Google Sheets los tiv thaiv lawv los ntawm kev hloov pauv lossis qhib lawv rau kev kho.
Nws txhais li cas rau xauv Cells hauv Google Sheets?
Ua ntej peb mus txog qhov tseeb yuav ua li cas-raug kaw cov hlwb hauv Google Sheets, nws tsim nyog siv sijhawm ib pliag kom nkag siab txog cov kev xaiv uas Google Sheets tso rau koj pov tseg.
Thaum koj kaw cov hlwb hauv Google Docs, koj muaj ob txoj kev xaiv:
- Qhia ceeb toom Yog tias ib tus neeg (xws li koj tus kheej) sim hloov kho lub xov tooj ntawm tes uas tiv thaiv li no, Google Sheets yuav tso cov lus ceeb toom, tab sis cia lub xov tooj hloov pauv yog tias tus neeg siv txuas ntxiv mus. Qhov no yog hom kev nyab xeeb valve uas tiv thaiv kev hloov pauv tsis raug tab sis tsis txwv leej twg los ntawm kev hloov pauv yog tias xav tau.
- Restrictedit. Yog tias lub xov tooj raug tiv thaiv li no, tsuas yog cov neeg uas tau tso cai tshwj xeeb los hloov kho lub xov tooj tuaj yeem hloov pauv. Qhov no tuaj yeem yog koj thiab koj ib leeg xwb, lossis lwm tus neeg koj ntxiv rau daim ntawv tso cai.
Yuav ua li cas xauv Cells hauv Google Sheets
Koj tuaj yeem kaw ib leeg lossis ntau lub hlwb hauv Google Sheets. Qhov ntawd suav nrog tag nrho cov kab thiab kab thiab. Nov yog li cas.
-
Xaiv lub xovtooj lossis ntau lub hlwb uas koj xav kaw.
Image -
Right-click the selected cells and then choose Protect Range from the menu.
Image -
Nyob hauv Cov ntawv tiv thaiv & ntau yam sidebar ntawm sab xis ntawm tus browser, muab cov npe xaiv yog tias xav tau (tab sis tsis txhob nias Enter). Koj tsis tas yuav muab nws lub npe, tab sis nws tuaj yeem ua rau nws yooj yim dua los nrhiav cov txheej txheem tiv thaiv tom qab.
Image - Nias lub ntsuab Teem tso cai khawm hauv tib lub sidebar.
-
Nyob hauv Range editing permissions dialog, xaiv seb koj puas xav kom tsuas yog qhia cov lus ceeb toom (uas tso cai rau lub hlwb hloov) lossis txwv tsis pub leej twg tuaj yeem hloov kho nws. Yog tias koj xaiv txwv leej twg tuaj yeem hloov kho qhov ntau yam no, nyem rau ntawm cov ntawv qhia zaub mov thiab xaiv Tsuas yog koj lossis Custom, thiab ntxiv qhov chaw nyob email rau txhua tus neeg koj xav tso cai kho. Thaum koj npaj txhij, nyem lub ntsuab Done khawm.
Image Yog tias koj twb tau tiv thaiv tsawg kawg ib pawg ntawm cov hlwb hauv cov ntaub ntawv no, koj tuaj yeem xaiv Copy tso cai los ntawm lwm qhov ntau, thiab tom qab ntawd xaiv cov cell ntawm daim ntawv uas tshwm. Qhov no yog ib txoj hauv kev yooj yim los siv tib txheej ntawm cov neeg kho kom raug tso cai los hloov qhov kev xaiv tshiab no.
Yuav Ua Li Cas Xauv Cells hauv Google Sheets
Tej zaum koj yuav xav kom tsis txhob tiv thaiv qee lub hlwb hauv daim ntawv nthuav qhia. Koj tuaj yeem ua qhov ntawd nrog ob peb nias ib yam nkaus.
-
Yog tias cov ntawv tiv thaiv & ntau yam sidebar tsis pom hauv koj daim ntawv teev npe, nyem Data hauv cov ntawv qhia zaub mov saum toj kawg nkaus. tshuaj ntsuam thiab xaiv tiv thaiv nplooj ntawv thiab ntau yam.
Image -
Nyob hauv sidebar, nyem lub xovtooj lossis ntau lub hlwb uas koj xav qhib.
-
Nias lub thoob khib nyiab icon mus rau sab xis ntawm tes piav qhia. Nyob rau hauv lub pop-up dialog, nyem Remove. Qhov no tsuas yog tshem tawm kev tiv thaiv ntawm lub hlwb, tsis yog cov ntaub ntawv suav nrog hauv lub hlwb.
Image
