3 Txoj hauv kev los Qhia Rows Rows hauv Excel

Cov txheej txheem:

3 Txoj hauv kev los Qhia Rows Rows hauv Excel
3 Txoj hauv kev los Qhia Rows Rows hauv Excel

Video: 3 Txoj hauv kev los Qhia Rows Rows hauv Excel

Video: 3 Txoj hauv kev los Qhia Rows Rows hauv Excel
Video: Kev txo Hwjchim yog yam uas haum Vajtswv siab 2024, Tej zaum
Anonim

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

Unhide Kab hauv Excel Kauj Ruam 1
Unhide Kab hauv Excel Kauj Ruam 1

Kauj Ruam 1. Qhib daim ntawv Excel

Ob npaug nias rau daim ntawv Excel uas koj xav qhib hauv Microsoft Excel.

Image
Image

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.

Image
Image

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.
Image
Image

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

Image
Image

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

Unhide Kab hauv Excel Kauj Ruam 7
Unhide Kab hauv Excel Kauj Ruam 7

Kauj Ruam 1. Qhib daim ntawv Excel

Ob npaug nias rau daim ntawv Excel uas koj xav qhib hauv Microsoft Excel.

Image
Image

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)

Unhide Kab hauv Excel Kauj Ruam 3
Unhide Kab hauv Excel Kauj Ruam 3

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.

Unhide Kab hauv Excel Kauj Ruam 4
Unhide Kab hauv Excel Kauj Ruam 4

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.

Image
Image

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.

Image
Image

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

Unhide Kab hauv Excel Kauj Ruam 12
Unhide Kab hauv Excel Kauj Ruam 12

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.

Unhide Kab hauv Excel Kauj Ruam 13
Unhide Kab hauv Excel Kauj Ruam 13

Kauj Ruam 2. Qhib daim ntawv Excel

Ob npaug nias rau daim ntawv Excel uas koj xav qhib hauv Microsoft Excel.

Image
Image

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)

Image
Image

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.

Unhide Kab hauv Excel Kauj Ruam 16
Unhide Kab hauv Excel Kauj Ruam 16

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.

Unhide Kab hauv Excel Kauj Ruam 17
Unhide Kab hauv Excel Kauj Ruam 17

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.

Unhide Kab hauv Excel Kauj Ruam 18
Unhide Kab hauv Excel Kauj Ruam 18

Kauj Ruam 7. Ntaus hauv qhov siab ua ntej kab

Ntaus 14.4 rau hauv cov ntawv sau hauv lub qhov rai qhib.

Unhide Kab hauv Excel Kauj Ruam 19
Unhide Kab hauv Excel Kauj Ruam 19

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.

Pom zoo: