Qhov wikiHow qhia koj yuav ua li cas tso saib kab lus zais hauv Microsoft Excel. Koj tuaj yeem ua qhov no ntawm ob qho tib si Windows thiab Mac versions ntawm Excel.
Cov kauj ruam
Kauj Ruam 1. Qhib koj daim ntawv Excel
Ob npaug nias rau daim ntawv Excel, lossis ob npaug nias lub cim Excel thiab tom qab ntawd xaiv cov ntawv lub npe los ntawm lub vev xaib. Qhov no yuav qhib koj cov ntawv uas muaj kab ntawv zais hauv Excel.
Kauj Ruam 2. Xaiv kab ntawm ob sab ntawm kab ntawv zais
Tuav tus yuam sij ift Ua haujlwm thaum koj nyem tsab ntawv saum toj kab ntawv mus rau sab laug thiab tom qab ntawv mus rau sab xis ntawm kab ntawv zais. Cov kab yuav raug hais qhia thaum koj ua tiav xaiv lawv.
- Piv txwv li, yog kem B yog zais, koj yuav tsum nyem A thiab ces C thaum tuav ⇧ Shift.
- Yog koj xav unhide kem A, xaiv kab ntawv los ntawm kev ntaus "A1" rau hauv "Lub Npe Lub Npe," uas nyob rau sab laug ntawm tus lej bar.
Kauj Ruam 3. Nyem rau Tsev tab
Nws nyob rau sab saud sab laug ntawm lub qhov rais Excel, hauv qab ntawm kab ntsuab ntawm no. Ua li ntawd yuav ua kom ntseeg tau tias cov Tsev toolbar tau tshwm rau hauv qab ntawm kab ntsuab.
Kauj Ruam 4. Nyem Format
Lub pob no nyob hauv ntu "Cells" ntawm Tsev tab; koj yuav pom ntu no nyob rau sab xis-sab xis ntawm lub cuab yeej. Cov ntawv qhia zaub mov nco-down yuav tshwm.
Kauj Ruam 5. Xaiv Hide & Unhide
Qhov kev xaiv no yog hauv qab "Visibility" nqe lus hauv Hom ntawv nco-down ntawv qhia zaub mov. Xaiv nws yuav qhia tawm cov ntawv qhia zaub mov tawm.
Kauj Ruam 6. Nyem Unhide Column
Nws nyob ze rau hauv qab ntawm Hide & Unhide ntawv qhia zaub mov Ua li ntawd yuav tam sim unhide kem uas nyob nruab nrab ntawm ob kab ntawv xaiv.
Lub tswv yim
- Yog tias qee kab tseem tsis pom tom qab koj tau sim zais cov kab, qhov dav ntawm kab ntawv tuaj yeem teeb tsa rau "0" lossis lwm qhov nqi me me. Txhawm rau nthuav dav kem, tso koj tus cursor ntawm sab xis ntawm kab, thiab rub kab kom nce nws qhov dav.
- Yog tias koj xav kom zais tag nrho cov kab lus zais ntawm Excel daim ntawv nthuav tawm, nyem rau ntawm "Xaiv Txhua" khawm, uas yog daim duab plaub uas nyob sab laug ntawm kab "A" thiab saum toj kab "1." Tom qab ntawd koj tuaj yeem txuas ntxiv nrog cov kauj ruam uas tseem tshuav hauv kab lus no kom zais cov kab ntawv no.
