Qhov wikiHow qhia koj yuav ua li cas qhia kab nyob hauv Microsoft Excel. Txoj kev no tuaj yeem siv tau ntawm ob lub Windows thiab Mac versions ntawm Microsoft Excel.
Kauj ruam
Kauj Ruam 1. Qhib daim ntawv Excel
Ob npaug nias rau daim ntawv Excel, lossis ob npaug nias rau ntawm lub cim Excel thiab xaiv cov npe ntawv los ntawm lub vev xaib. Qhov no yuav qhib cov ntawv uas muaj cov zais zais hauv nws.
Kauj Ruam 2. Xaiv kab uas nyob ib puag ncig ntawm kab ntawv zais
Tuav Shift thaum koj nyem tsab ntawv saum kab sab laug thiab tom qab ntawv sab xis ntawm kab ntawv zais. Cov teb no yuav raug cim yog tias koj xaiv lawv ua tiav.
- Piv txwv li, yog kem B zais, nyem A ces C thaum tuav tus yuam sij ua haujlwm.
- Yog koj xav tso saib kem A, xaiv kab ntawv los ntawm kev ntaus "A1" hauv "Lub Npe Lub Npe" lub thawv nyob rau sab laug ntawm lub npov mis.
Kauj Ruam 3. Nyem rau Tsev tab
Nws yog nyob rau sab laug sab saud ntawm Excel qhov rai. Cov kauj ruam no yuav tso saib qhov toolbar Tsev.
Kauj Ruam 4. Nyem Format
Lub pob no nyob hauv ntu "Cells" ntawm. Tab Tsev; Seem no yog nyob rau 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 nyob hauv qab "Pom Kev" nqe lus hauv cov ntawv qhia zaub mov Hom ntawv. Tom qab xaiv qhov no, cov ntawv qhia zaub mov tawm yuav tshwm.
Kauj Ruam 6. Nyem Unhide Column
Nws nyob hauv qab cov ntawv qhia zaub mov Hide & Unhide. Qhov no yuav qhia tam sim tam sim ntawm kab ntawv zais ntawm ob kab ntawv xaiv.
Lub tswv yim
- Yog tias qee qhov kab ntawv tseem tsis pom tom qab cov kauj ruam no, nws yuav yog tias kab dav tau teev tseg rau "0" lossis qee qhov me me. Txhawm rau nthuav dav ib kem, tso tus cursor nyob rau sab xis ntawm kab, thiab rub kab ntawv los nthuav nws.
- Yog tias koj xav qhia txhua kab ntawv zais hauv Excel daim ntawv nthuav tawm, nyem rau "Xaiv Txhua" khawm, uas yog lub npov square khoob rau sab laug ntawm kab "A" thiab saum toj kab "1". Tom ntej no, ua cov kauj ruam raws li tau sau hauv kab lus no kom pom cov kab no.
Qhov chaw thiab Citation
-
https://support.office.com/en-us/article/Hide-or-show-rows-or-column-659c2cad-802e-44ee-a614-dde8443579f8
