01 ntawm 05
Txog Cov Ntawv Cuam Tshuam Ua Ntej Excel
Ib daim ntawv khom nqi Excel yog ib daim ntawv khij nyiab uas muaj hlwb. Txhua lub xov tooj yuav tuav cov ntawv nyeem, ib tug xov tooj, los yog ib tus qauv, thiab txhua lub xov tooj ntawm tes tau siv ib lub xov tooj sib txawv ntawm tib daim ntawv, tib phau ntawv, lossis lwm phau ntawv.
Ib qho Excel workbook muaj ib los yog ntau daim ntawv khom nqi. Los ntawm kev ua neej, qhib tag nrho cov ntaub ntawv qhib Excel cov ntawv khawm tab sis ntawm daim ntawv pov thawj hauv qab ntawm lub vijtsam, tabsis koj tuaj yeem zais lossis tso tau raws li xav tau. Tsawg kawg ib daim ntawv ua haujlwm yuav tsum pom txhua lub sijhawm.
Muaj ntau tshaj ib txoj hau kev nkaum thiab muab cov ntawv ua haujlwm Excel sau. Koj tuaj yeem:
- Siv cov ntawv qhia kev cai lub ntsiab lus nruab nrab.
- Siv Hom Kev Txheeb rau Hom Tsev ntawm txoj hlua .
Kev Siv Cov Ntaub Ntawv Siv Hauv Cov Ntawv Qhia Thaum Cov Lus Qhia
Cov ntaub ntawv nyob rau hauv cov nplooj ntawv uas tau muab zais tawm tsis muab deleted, thiab nws tseem tuaj yeem hais txog cov qauv thiab cov kab kos nyob rau lwm daim ntawv los yog lwm cov ntawv ua haujlwm .
Hauv cov qauv uas muaj cov chiv keeb tseem rov hloov yog cov ntaub ntawv hauv cov npe ntawm cov kev hloov hlwb.
02 ntawm 05
Nkaum ib Daim Ntawv Qhia Txog Kev Ua Haujlwm Hauv Excel Siv Cov Ntawv Teev Npe Ntawm Cov Ntaub Ntawv
Cov kev xaiv muaj nyob hauv cov ntawv qhia zaub mov - lossis txoj cai-nias lub tshuab raj-hloov raws li lub khoom uas xaiv thaum lub tshuab qhib.
Yog tias qhov kev xaiv Hide tsis ua haujlwm lossis tsis tuaj yeem tawm, tej zaum yuav muaj cov ntawv ua haujlwm tam sim no tsuas muaj ib daim ntawv ua haujlwm xwb. Excel deactivates qhov nkaum xaiv rau cov ntawv ua haujlwm ib leeg vim tias nws yuav tsum muaj tsawg kawg yog ib daim ntawv uas pom pom hauv phau ntawv ua haujlwm.
Mus Nta Sau Ib Daim Ntawv Sau Tseg
- Nias rau ntawm daim ntawv tab tab ntawm nplooj ntawv muab khaws cia rau nws.
- Txoj cai-nias ntawm daim ntawv tab tab tab qhib lub ntsiab lus ntawm cov ntawv qhia.
- Nyob rau hauv cov ntawv qhia zaub mov, nias ntawm qhov kev nkaum nkaum xaiv cov lus xaiv.
Yuav Npog Cov Ntawv Xab Thib Ntau Lawm
- Nias rau ntawm daim ntawv ntawm thawj daim ntawv khij tau muab zais los xaiv nws.
- Nias thiab tuav lub Ctrl qhov tseem ceeb ntawm cov keyboard.
- Nias rau ntawm tabs ntawm cov ntawv khom nqi ntxiv los xaiv lawv.
- Txoj cai-nias rau ntawm ib daim ntawv tab tab qhib lub ntsiab lus ntawm cov ntawv ceeb toom.
- Nyob rau hauv cov ntawv qhia, nias ntawm qhov kev nkaum nkaum tag nrho cov ntawv khom nqi.
03 ntawm 05
Nkaum Cov Ntawv Cuam Tshuam Siv Cov Ribbon
Excel tsis muaj keyboard shortcut rau cov ntawv khom nqi, tiam sis koj tuaj yeem siv txoj hlua los ua txoj haujlwm.
- Xaiv ib daim ntawv tab rau hauv qab ntawm Excel.
- Nias lub tsev tab ntawm txoj hlua thiab xaiv cov Vev Xaib.
- Xaiv Hom Ntawv rau hauv cov ntawv qhia zaub mov uas tshwm sim.
- Nyem qhov nkaum & Unhide .
- Xaiv Hide Sheet .
04 ntawm 05
Muab Daim Ntawv Sau Cov Ntaub Ntawv Qhia Txog Excel Ua Siv Cov Ntawv Teev Npe
Cov kev xaiv muaj nyob hauv cov ntawv qhia zaub mov - lossis txoj cai-nias lub tshuab raj-hloov raws li lub khoom uas xaiv thaum lub tshuab qhib.
Txhawm rau Unhide ib Daim Ntawv Xwb Ua Haujlwm
- Txoj cai-nias rau ntawm daim ntawv tab tab qhib lub Unhide dialog box , uas qhia tag nrho cov ntawv khawm tam sim no.
- Nias rau ntawm daim ntawv yuav tsum tsis txhob mob.
- Nias OK mus nias cov ntawv xaiv thiab kaw lub thawv ntawv.
05 ntawm 05
Muab Daim Ntawv Cuam Npe Siv Cov Ribbon
Raws li cov ntawv zais cia, Excel tsis muaj cov keyboard shortcut rau cov ntawv ua haujlwm, tab sis koj siv tau cov ntawv sau los nrhiav thiab ua tsis tau cov ntawv khom nqi.
- Xaiv ib daim ntawv tab rau hauv qab ntawm Excel.
- Nias lub tsev tab ntawm txoj hlua thiab xaiv cov Vev Xaib.
- Xaiv Hom Ntawv rau hauv cov ntawv qhia zaub mov uas tshwm sim.
- Nyem qhov nkaum & Unhide .
- Xaiv Unhide Sheet .
- Saib cov npe ntawm cov ntaub ntawv uas tshwm sim. Nias rau ntawm cov ntaub ntawv koj xav kom unhide.
- Nyem OK .