Xov tes tiv thaiv lawv
- Xaiv lub hlwb koj xav kaw.
- Ntawm lub Tsev tab, hauv pawg Alignment, nyem lub xub me los qhib lub qhov rai Format Cells popup.
- Ntawm Kev Tiv Thaiv tab, xaiv lub thawv Xauv, thiab tom qab ntawd nyem OK txhawm rau kaw qhov popup.
Koj yuav tiv thaiv cov hlwb hauv Excel li cas yam tsis muaj ntawv tiv thaiv?
Betreff: Xauv ntawm tes tsis tiv thaiv daim ntawv ua haujlwm
- Start Excel.
- Hloov mus rau "Xaiv" tab thiab xaiv "Tshem tawm daim ntawv tiv thaiv". …
- Xaiv tag nrho cov hlwb los ntawm nyem rau saum toj sab laug ntawm lub rooj.
- Nyob rau hauv "Pib" tab, xaiv "Format> Format cells> Tiv Thaiv" thiab uncheck "Locked".
tiv thaiv ua dab tsi hauv Excel?
Txhawm rau tiv thaiv lwm tus neeg siv los ntawm kev ua yuam kev lossis txhob txwm hloov pauv, txav, lossis tshem tawm cov ntaub ntawv hauv daim ntawv ua haujlwm, koj tuaj yeem kaw cov hlwb ntawm koj daim ntawv ua haujlwm Excel thiab tom qab ntawd tiv thaiv daim ntawv nrog tus password.
Kuv yuav tiv thaiv thiab tiv thaiv cov hlwb hauv Excel li cas?
Nias lub Ctrl key thiab 1 tus yuam sij ua ke (Ctrl + 1) ntawm koj cov keyboard kom qhib lub qhov rai Format Cells. Koj tuaj yeem siv Ctrl + Ua haujlwm + F qhov tseem ceeb ua ke los qhib lub qhov rai Format Cells. Nyob rau hauv Format Cells qhov rais, nyem qhov Tiv thaiv tab. Uncheck lub thawv rau qhov kev xaiv Xauv, tom qab ntawd nyem OK.
Kuv yuav ua li cas thiaj ua kom lub xovtooj tsis hloov tau hauv Excel?
1 Teb. Txhawm rau ua ib kem uas tsis tuaj yeem kho tau: Xaiv tag nrho daim ntawv ua haujlwm, Right Click->Format Cells->Protection, uncheck the "Locked" check box. Xaiv lub kem koj xav tiv thaiv, txoj cai Click->Format Cells->Protection, xaiv lub "Xauv" kos lub thawv.
