Yuav ua li cas Merge Cells hauv Excel: 4 Kauj Ruam (nrog Duab)

Cov txheej txheem:

Yuav ua li cas Merge Cells hauv Excel: 4 Kauj Ruam (nrog Duab)
Yuav ua li cas Merge Cells hauv Excel: 4 Kauj Ruam (nrog Duab)

Video: Yuav ua li cas Merge Cells hauv Excel: 4 Kauj Ruam (nrog Duab)

Video: Yuav ua li cas Merge Cells hauv Excel: 4 Kauj Ruam (nrog Duab)
Video: Lo lus, lub nplooj sawv, dai khoom cov ntaub ntawv 2024, Tej zaum
Anonim

Qhov wikiHow qhia koj yuav ua li cas muab ob lossis ntau lub cell hauv Excel. Txoj kev no ua haujlwm ntawm ob qho tib si Windows thiab Mac versions ntawm Excel.

Kauj ruam

Merge Cells hauv Excel Kauj Ruam 1
Merge Cells hauv Excel Kauj Ruam 1

Kauj Ruam 1. Qhib daim ntawv Excel

Ob npaug nias rau daim ntawv Excel kom qhib nws hauv Excel.

Yog tias koj tseem tsis muaj daim ntawv Excel, qhib qhov Excel program thiab nyem rau Phau ntawv ua haujlwm dawb paug.

Merge Cells hauv Excel Kauj Ruam 2
Merge Cells hauv Excel Kauj Ruam 2

Kauj Ruam 2. Xaiv cov cell uas koj xav koom ua ke

Nyem ib lub xovtooj, tom qab ntawd rub tus nas hla lwm lub xovtooj uas koj xav koom ua ke.

  • Piv txwv li, yog tias koj xav koom ua ke cov cell A1 txog C1, nyem thiab rub tus nas los ntawm lub xovtooj A1 txog C1.
  • Cov hlwb koj xav koom ua ke yuav tsum sib koom ua ke; Piv txwv li, koj tuaj yeem ua ke cov cell A1 thiab B1, tab sis tsis nrog C1 tsis muaj kev sib txuas B1 thiab.
Merge Cells hauv Excel Kauj Ruam 3
Merge Cells hauv Excel Kauj Ruam 3

Kauj Ruam 3. Nyem rau Tsev tab

Nws yog nyob rau sab laug sab saud ntawm Excel qhov rai. Cov kauj ruam no yuav coj mus rau qhov toolbar Tsev.

Merge Cells hauv Excel Kauj Ruam 4
Merge Cells hauv Excel Kauj Ruam 4

Kauj Ruam 4. Nyem Merge & Center

Lub npov no nyob hauv ntu "Alignment" ntawm cov kev xaiv ntawm lub cuab yeej Tsev. Cov kauj ruam no yuav txiav ua ke cov xov tooj uas tau xaiv thiab nruab nrab lawv cov ntsiab lus.

Yog tias koj tsis xav kom nruab nrab cov ntsiab lus ntawm tes, nyem lub pob ntawm sab xis Merge & Chaw ces nyem Merge Cells.

Lub tswv yim

Koj tuaj yeem tsim lub npov npe uas nthuav tawm thoob plaws hauv daim ntawv

Pom zoo: