Qhov wikiHow no qhia koj yuav ua li cas qhia kab nyob hauv Excel daim ntawv nthuav qhia.
Kauj ruam
Txoj Kev 1 ntawm 3: Qhia Kab Tshwj Xeeb
Kauj Ruam 1. Qhib daim ntawv Excel
Ob npaug nias rau daim ntawv Excel uas koj xav qhib hauv Microsoft Excel.
Kauj Ruam 2. Nrhiav cov kab uas zais
Txheeb tus lej kab rau sab laug ntawm daim ntawv thaum koj nqes mus. Yog tias tus lej ploj lawm (piv txwv li kab
Kauj ruam 10. tsuas yog hauv qab kab
Kauj ruam 8.), txhais tau tias kab ntawm ob tus lej tau muab zais (hauv qhov piv txwv, nws txhais tau tias kab
Kauj ruam 9.). Koj tseem yuav pom ob kab ntawm ob kab lej.
Kauj Ruam 3. Txoj cai-nias ntawm qhov chaw nruab nrab ntawm ob kab lej
Qhov no yuav coj los rau hauv cov ntawv qhia zaub mov nco-down.
-
Piv txwv li, yog tias kab 9 zais, txhais tau tias koj yuav tsum nyem qhov chaw nruab nrab ntawm kab
Kauj ruam 8. ua da
Kauj ruam 10..
- Ntawm Mac, koj tuaj yeem nias thiab tuav tus yuam sij Tswj thaum nyem rau ntawm qhov chaw kom coj los rau hauv cov ntawv qhia zaub mov nco-down.
Kauj Ruam 4. Nyem Unhide hauv cov ntawv qhia zaub mov nco-down
Qhov no yuav coj kab uas zais.
Nias Command+S (Mac) lossis Ctrl+S (Windows) yog tias koj xav khaws koj cov kev hloov pauv
Kauj Ruam 5. Qhia qee kab uas zais
Yog tias koj pom tias qee kab uas ploj lawm, koj tuaj yeem tso saib txhua kab los ntawm kev ua cov hauv qab no:
- Nias hais kom ua (Mac) lossis Ctrl (Windows) thaum nyem kab kab saum toj no kab zais thiab kab lej hauv qab kab zais.
- Txoj cai-nias ntawm ib qho ntawm cov kab xaiv xaiv.
- Nyem Tshem tawm nyob rau hauv cov ntawv qhia zaub mov nco-down.
Txoj Kev 2 ntawm 3: Qhia Tag Nrho Cov Kab
Kauj Ruam 1. Qhib daim ntawv Excel
Ob npaug nias rau daim ntawv Excel uas koj xav qhib hauv Microsoft Excel.
Kauj Ruam 2. Nyem rau "Xaiv Txhua" khawm
Nws yog daim duab peb sab-zoo li lub pob nyob rau sab saum toj-sab laug ntawm daim ntawv nthuav qhia, saum tus lej kab
Kauj ruam 1. mus rau sab laug ntawm kab ntawv A. Ua li ntawd yuav xaiv tag nrho cov ntsiab lus ntawm daim ntawv Excel.
Koj tseem tuaj yeem xaiv tag nrho cov ntawv los ntawm txhaj ib lub xov tooj ntawm tes hauv daim ntawv, tom qab ntawd nyem Command+A (Mac) lossis Ctrl+A (Windows)
Kauj Ruam 3. Nyem rau Tsev tab
Cov ntawv no nyob hauv qab kab ntsuab nyob saum lub qhov rai.
Hla cov kauj ruam no yog tias koj twb nyob hauv tab lawm Tsev.
Kauj Ruam 4. Nyem Format
Cov ntawv qhia zaub mov no nyob hauv ntu "Cells" ntawm lub cuab yeej nyob rau sab xis saum toj ntawm lub qhov rais. Cov ntawv qhia zaub mov nco-down yuav tshwm.
Kauj Ruam 5. Xaiv Hide & Unhide
Qhov kev xaiv no yog nyob hauv cov ntawv qhia zaub mov nco-down Hom ntawv. Thaum koj ua li ntawd, cov ntawv qhia zaub mov tawm yuav tshwm.
Kauj Ruam 6. Nyem Unhide Rows hauv cov ntawv qhia zaub mov tawm
Ua li ntawd yuav tam sim pom txhua kab ntawm daim ntawv nthuav tawm.
Nias Command+S (Mac) lossis Ctrl+S (Windows) yog tias koj xav khaws koj cov kev hloov pauv
Txoj Kev 3 ntawm 3: Teeb Kab Qhov Siab
Kauj Ruam 1. Nkag siab thaum yuav tsum ua txoj kev no
Ib txoj hauv kev los nkaum kab yog hloov qhov siab ntawm kab uas xav tau kom luv kom nws zoo li nws ploj mus. Koj tuaj yeem rov pib qhov siab ntawm txhua kab rau "14.4" (qhov siab hauv Excel) los ua haujlwm ib puag ncig qhov no.
Kauj Ruam 2. Qhib daim ntawv Excel
Ob npaug nias rau daim ntawv Excel uas koj xav qhib hauv Microsoft Excel.
Kauj Ruam 3. Nyem rau lub pob "Xaiv Txhua"
Nws yog daim duab peb sab-zoo li lub pob nyob rau sab saud sab laug ntawm daim ntawv nthuav qhia, saum toj ntawm kab lej
Kauj ruam 1. mus rau sab laug ntawm kab ntawv A. Ua li ntawd yuav xaiv tag nrho cov ntsiab lus ntawm daim ntawv Excel.
Koj tseem tuaj yeem xaiv tag nrho cov ntawv los ntawm txhaj ib lub xov tooj ntawm tes hauv daim ntawv, tom qab ntawd nyem Command+A (Mac) lossis Ctrl+A (Windows)
Kauj Ruam 4. Nyem rau Tsev tab
Cov ntawv no nyob hauv qab kab ntsuab nyob saum lub qhov rai.
Hla cov kauj ruam no yog tias koj twb nyob hauv tab lawm Tsev.
Kauj Ruam 5. Nyem Format
Nws nyob hauv ntu "Cells" ntawm lub cuab yeej nyob rau sab xis saum toj ntawm lub qhov rais. Cov ntawv qhia zaub mov nco-down yuav tshwm.
Kauj Ruam 6. Nyem Row Height… hauv cov ntawv qhia zaub mov nco-down
Lub qhov rai pop-up uas muaj cov ntawv npliag teb yuav qhib.
Kauj Ruam 7. Ntaus hauv qhov siab ua ntej kab
Ntaus 14.4 rau hauv cov ntawv sau hauv lub qhov rai qhib.
Kauj ruam 8. Nyem OK
Qhov kev hloov pauv uas koj ua yuav raug siv rau txhua kab hauv daim ntawv nthuav tawm. Txhua kab uas "zais" los ntawm kev luv lawv qhov siab yuav raug qhia.