Yog hais tias Unhide hais kom ua greyed tawm ob qho tib si ntawm ribbon thiab nyob rau hauv txoj cai-nias ntawv qhia zaub mov, txhais tau tias tsis muaj ib daim ntawv zais hauv koj phau ntawv ua haujlwm:) Qhov no yog li cas koj unhidenplooj ntawv hauv Excel.
Kuv yuav ua li cas thiaj zais thiab tsis zais hauv Excel?
Txoj cai-nias daim ntawv tab koj xav nkaum, lossis ib daim ntawv pom yog tias koj xav tshem cov nplooj ntawv.
Hide lossis unhide ib daim ntawv ua haujlwm
- Xaiv cov ntawv ua haujlwm uas koj xav nkaum. …
- Ntawm lub Tsev tab, hauv pawg Cells, nyem Format > Pom Kev > Hide & Unhide > Hide Sheet.
Vim li cas kuv tsis tuaj yeem zais daim ntawv ua haujlwm hauv Excel?
Yog tias phau ntawv ua haujlwm tsuas muaj cov ntawv zais ntau heev, koj tseem yuav tsis tuaj yeem qhib lub thawv Unhide vim tias Unhide cov lus txib yuav raug kaw. Yog tias phau ntawv ua haujlwm muaj ob daim ntawv zais thiab zais heev, lub Unhide dialog yuav muaj, tab sis cov nplooj ntawv zais heev yuav tsis tau teev nyob ntawd.
Kuv yuav kho greyed tawm hauv Excel li cas?
Nias lub "Tsev" ntawv qhia zaub mov, ces xaiv "Format" nyob rau hauv lub "Cells" tab. Xaiv " Unprotect Sheet" los ntawm "Kev Tiv Thaiv" ntu ntawm cov ntawv qhia zaub mov kom qhib daim ntawv ua haujlwm. Yog tias daim ntawv ua haujlwm raug tiv thaiv tus password, Excel yuav tsis qhib cov ntawv qhia zaub mov kom txog thaum koj nkag rau koj tus password.
Yuav ua li cas koj qhib cov ntawv qhia zaub mov greyed hauv Excel?
Nco ntsoov tias koj tsis nyob rau hauv Kho kom raug hom los ntawm ntaus Esc (Txoj kev khiav qhov tseem ceeb), raws li kho hom > yuav grey tawm ntau cov ntawv qhia zaub mov - tshwj xeeb tshaj yog feem ntau Kho kom raug xaiv (tshwj tsis yog txiav >& muab tshuaj txhuam). Yuav greyout Options nyob rau hauv Toolbar; ntau txoj kev xaiv nyob rau hauv Cov Ntaub Ntawv thiab >under Window.