Kev tiv thaiv ntawm cov hlwb hauv daim ntawv nthuav qhia kev tswj hwm Microsoft Office Excel tsis yog siv los tswj kev tsim tawm - rau lub hom phiaj no, kev tiv thaiv ntawm cov ntaub ntawv cov ntaub ntawv tau npaj rau ntawm no. Theej, txhav tas cov xov tooj ntawm tes yog xav tau los tiv thaiv kev hloov pauv ntawm cov qauv lossis cov ntaub ntawv hauv pob ntawv. Cov txheej txheem rau kev ua kom muaj kev tiv thaiv nws tus kheej yog yooj yim, tab sis xav tau kev nkag siab ntawm lub hauv paus ntsiab lus ntawm kev ua haujlwm.
Tsim nyog
Tabular editor Microsoft Office Excel 2007 lossis 2010
Cov Lus Qhia
Kauj ruam 1
Kev Tiv Thaiv hauv Excel tau teeb tsa li qhov uas nws tau nruab rau ntawm daim ntawv ntawm cov ntawv raws li tag nrho thiab siv rau tag nrho nws cov ncauj lus. Yog li no, ua ntej pib ncaj qha nrog kev teeb tsa kev nkag mus thaiv, koj yuav tsum txhais cov kev zam ntawm kev thaiv dav dav. Yog lawm, qhov no yuav tsum tsuas yog ua yog tias nws yog qhov yuav tsum tau tso tawm dawb nkag mus rau qee qhov rooj ntawm lub hlwb. Pib tus txheej txheem los ntawm xaiv tag nrho daim ntawv - nias tus ntawv keyboard shortcut Ctrl + A.
Kauj ruam 2
Txoj cai-nias xaiv thiab xaiv Hom Cell los ntawm lub pop-up ntsiab lus teb ntawv qhia zaub mov. Ib lub qhov rai yuav tshwm sim ntawm qhov screen uas koj xav tau "Kev Tiv Thaiv" tab - kos lub box "Tiv Thaiv Cov Ntawv Pov Tseg" nyob ntawm nws. Yog tias koj xav kaw cov hlwb tsis yog tsuas yog ua tsis yooj yim los kho, tab sis kuj tseem saib cov qauv uas lawv muaj, khij lub thawv "Khaws cov qauv" ib yam nkaus. Nyem OK thiab daim ntawv npaj tiav los ua kom muaj kev tiv thaiv.
Kauj ruam 3
Yog tias koj tsis tas yuav tawm dawb nkag mus rau qee lub ntsiab lus, hla lub kauj ruam no, txwv tsis pub xaiv cov hlwb uas koj xav cais tawm ntawm cov npe tiv thaiv. Hu xov tooj rau lub qhov rai yam ntxwv dua ntawm cov ntawv qhia zaub mov thiab ua lub lag luam fab ntxeev - tsis xaiv lub npov nyob ntawm kab lus "Pov Thaiv ntawm tes". Nyem OK.
Kauj ruam 4
Nthuav cov ntawv tiv thaiv. Qhov no tuaj yeem ua tiav rau ntawm "Tsev" tab ntawm daim ntawv teev cov ntawv teev cov khoom siv. Hauv "Cells" pab pawg ntawm cov lus txib ntawm lub npov no muaj cov ntawv teev cia "Daim Ntawv" - qhib nws thiab xaiv "Tiv Thaiv Cov Ntawv". Lub qhov rais me me rau kev teeb tsa ntawm kev tiv thaiv no yuav tshwm sim ntawm lub screen.
Kauj ruam 5
Txheeb xyuas lub thawv ntsuas ntawm kev ua haujlwm uas yuav tsum muaj rau cov neeg siv ntawm daim ntawv tiv thaiv. Yog tias tsuas yog ib tus neeg uas paub txog tus password yuav tsum tshem tawm kev tiv thaiv, sau tus password rau hauv kab ntawv. Nyem OK thiab kev tiv thaiv yuav raug qhib.