Yuav Ua Li Cas Thiaj Li Cells hauv Excel: 5 Kauj Ruam (nrog Duab)

Cov txheej txheem:

Yuav Ua Li Cas Thiaj Li Cells hauv Excel: 5 Kauj Ruam (nrog Duab)
Yuav Ua Li Cas Thiaj Li Cells hauv Excel: 5 Kauj Ruam (nrog Duab)

Video: Yuav Ua Li Cas Thiaj Li Cells hauv Excel: 5 Kauj Ruam (nrog Duab)

Video: Yuav Ua Li Cas Thiaj Li Cells hauv Excel: 5 Kauj Ruam (nrog Duab)
Video: nyiag nkag koj tus hluas nkauj tus messenger ua koj twb g paub password 2024, Tej zaum
Anonim

Qhov wikiHow no qhia koj yuav ua li cas faib cov sib txuas ua ke rau hauv ob lossis ntau lub qauv txheej txheem hauv Microsoft Excel.

Kauj ruam

Unmerge Cells hauv Excel Kauj Ruam 1
Unmerge Cells hauv Excel Kauj Ruam 1

Kauj Ruam 1. Qhib cov ntawv Excel

Ob npaug nias rau Excel cov ntaub ntawv uas koj xav qhib.

Unmerge Cells hauv Excel Kauj Ruam 2
Unmerge Cells hauv Excel Kauj Ruam 2

Kauj Ruam 2. Xaiv cov cell sib koom ua ke

Nrhiav lub xovtooj uas koj xav faib, tom qab ntawv xaiv lub cell los txhaj rau nws.

  • Merged cells nqa ob lossis ntau kab ntawm qhov chaw. Piv txwv li, sib koom ua ke cov cell uas twb muaj lawm hauv ib kem A thiab B yuav ua rau lub cell uas nthuav tawm los ntawm kab A rau B.
  • Koj tsis tuaj yeem tshem cov cell uas tsis tau koom nrog ib lossis ntau lwm lub cell.
Unmerge Cells hauv Excel Kauj Ruam 3
Unmerge Cells hauv Excel Kauj Ruam 3

Kauj Ruam 3. Nyem Lub Tsev tab nyob rau sab saud ntawm Excel qhov rai

Toolbar (toolbar) Tsev yuav qhib.

Thaum koj tau qhib lub tab Tsev, hla cov kauj ruam no.

Unmerge Cells hauv Excel Kauj Ruam 4
Unmerge Cells hauv Excel Kauj Ruam 4

Kauj Ruam 4. Qhib cov ntawv "Merge & Center"

Nyem rau qhov nco-down xub icon (nco-down)

Android7dropdown
Android7dropdown

mus rau sab xis ntawm lub pob Merge & Chaw nyob rau hauv ntu "Alignment" ntawm toolbar. Cov ntawv qhia zaub mov nco-down yuav tshwm.

Unmerge Cells hauv Excel Kauj Ruam 5
Unmerge Cells hauv Excel Kauj Ruam 5

Kauj Ruam 5. Nyem Unmerge Cells hauv cov ntawv qhia zaub mov nco-down

Cov cell koj xaiv yuav raug faib, thiab cov txiaj ntsig ntawm tes yuav raug ntxiv rau sab laug ntawm tes.

Piv txwv li, yog tias muaj "Nyob Zoo" hauv cov xovtooj sib txuas, lo lus "Nyob Zoo" yuav muab tso rau hauv lub cell sab laug tom qab koj faib cov cell

Lub tswv yim

Yog tias koj siv Excel hauv cov lus uas nyeem ntawm sab xis mus rau sab laug, qhov sib faib ntawm cov txiaj ntsig ntawm tes yuav muab tso rau hauv txoj cai ntawm tes

Pom zoo: