Yuav Paub
- Xaiv cov hlwb. Mus rau Home > xaiv Merge thiab Center nqes- xub > xaiv kev sib koom ua ke lossis Unmerge Cells.
- Or, right-click select cells > Format Cells > Alignment > xaiv lossis tsis xaiv Merge Cells.
Kab lus no piav qhia yuav ua li cas sib koom ua ke thiab tshem tawm cov hlwb hauv Excel, nrog rau yuav ua li cas thiaj nrhiav tau ib pawg ntawm cov hlwb sib koom ua ke hauv daim ntawv nthuav qhia. Cov lus qhia hauv kab lus no siv rau Microsoft Excel 2019, 2016, thiab Excel hauv Microsoft 365.
Yuav ua li cas Merge thiab Unmerge Cells hauv Excel
Kev sib koom ua ke ntawm cov hlwb hauv Excel tso cai rau koj los tsim lub xov tooj loj dua uas tuaj yeem pom thoob plaws ntau kab thiab kab. Txoj haujlwm no muaj txiaj ntsig zoo thaum koj xav tsim lub thawv ntawv lossis thaj chaw loj dua rau kev nthuav qhia koj cov ntaub ntawv. Txawm li cas los xij, tej zaum koj kuj yuav xav tau unmerge koj lub hlwb los hloov tus tsim ntawm koj daim ntawv nthuav qhia lossis ua qee cov ntaub ntawv ua haujlwm.
Muaj peb txoj hauv kev sib cais rau kev sib koom ua ke hauv Microsoft Excel. Cov txheej txheem no yog siv Excel Ribbon, siv Merge Cells ntawv qhia zaub mov, thiab siv cov keyboard shortcuts. Txhua txoj kev yog yooj yim rau siv thiab ua kom formatting hlwb yooj yim ua.
Thaum koj sib koom ua ke ntawm tes, tsuas yog sab sauv sab laug ntawm koj xaiv ntau lub cell yuav muaj nws cov ntsiab lus tso rau hauv lub xov tooj tshiab. Tag nrho lwm cov ntaub ntawv nyob rau hauv lub hlwb ntxiv uas yog merged yuav muab deleted tom qab lub merge. Yog li, yog tias muaj cov ntaub ntawv hauv cov hlwb uas koj xav khaws cia, koj yuav tsum luam nws mus rau qhov chaw tshiab ua ntej tsim cov cell sib koom ua ke.
Yuav ua li cas Siv Excel Ribbon los ua ke thiab Unmerge Cells
Hauv Microsoft Excel, Ribbon yog qhov chaw koj yuav pom feem ntau ntawm cov lus txib uas koj siv. Siv cov lus txib ntawm cov kab no, koj tuaj yeem yooj yim sib koom ua ke thiab tshem tawm cov hlwb nyob txhua qhov chaw hauv Excel spreadsheet.
- Xaiv cov hlwb uas koj xav sib koom ua ke lossis unmerge.
-
Xaiv Home.
Image -
Mus rau ntu Txhim kho thiab xaiv Merge thiab Center nqes xub.
Image -
Xaiv ib qho kev sib koom ua ke lossis Unmerge Cells.
Image Ib txoj hauv kev nrawm rau kev sib koom ua ke lossis kev sib koom ua ke siv lub Merge & Center kev xaiv yog xaiv cov hlwb uas koj xav sib koom ua ke, lossis cov uas twb tau muab ua ke, thiab xaiv Merge & Center. Yog hais tias lub hlwb tseem ceeb tsis sib koom ua ke, lawv yuav yog. Yog tias lawv raug muab sib koom ua ke, cov hlwb yuav raug rho tawm.
Yuav ua li cas Siv 'Format Cells' los ua ke thiab Unmerge Cells
Cov ntawv qhia zaub mov hauv Excel tswj ntau txoj hauv kev rau cov lej thiab cov ntawv tshwm hauv koj daim ntawv nthuav qhia. Koj tuaj yeem siv cov ntawv qhia zaub mov no los tswj koj li cas koj sib koom ua ke thiab unmerge cell, ib yam nkaus.
- Highlight cov hlwb uas koj xav sib koom ua ke lossis unmerge.
-
Right-click the selected cells and xaiv Format Cells.
Image -
Xaiv Alignment.
Image -
Xaiv lossis tsis xaiv qhov Merge Cells kev xaiv.
Image
Yuav ua li cas siv Keyboard Shortcuts los ua ke thiab Unmerge Cells
Yog tias koj xav siv cov keyboard shortcuts hauv Excel, koj muaj hmoo, vim tias koj tuaj yeem sib koom ua ke thiab tshem tawm cov hlwb siv kev sib txuas ntawm cov keyboard shortcuts.
- Xaiv cov hlwb uas koj xav sib koom ua ke.
-
Nias lub Alt tus yuam sij ntawm cov keyboard kom pom cov shortcuts.
Image -
Kaw tus H tus yuam sij nkag mus rau lub tsev ribbon.
Image -
Coj mus rhaub M tus yuam sij qhib lub Merge Cells zaub mov.
Image -
Nias lub U tus yuam sij kom Unmerge cov hlwb.
Image
Yuav Ua Li Cas Nrhiav Cov Cells hauv Excel
Nyob ntawm qhov loj ntawm koj daim ntawv nthuav qhia, koj yuav muaj teeb meem nrhiav cov hlwb sib koom ua ke thaum koj xav tau unmerge lawv. Piv txwv li, txhua kab lossis kab nrog lub xov tooj sib koom ua ke yuav ua rau nws nyuaj rau koj xaiv ntau lub hlwb lossis lim thiab txheeb cov ntaub ntawv uas lawv muaj. Txhawm rau nrhiav cov cell sib koom ua ke yooj yim, ua raws cov kauj ruam yooj yim no.
-
Los ntawm Home tab, xaiv Nrhiav & Xaiv > Nrhiav.
Image -
Nyob hauv Nrhiav thiab Hloov dialog box uas qhib, xaiv Options.
Image -
Qhov Nrhiav thiab Hloov lub thawv ntawv nthuav dav. Xaiv lub Format cov ntawv qhia zaub mov, ces xaiv Format.
Image -
Xaiv Alignment > Merge Cells > OK.
Image -
Xaiv Nrhiav Tag Nrho txhawm rau saib tag nrho cov cell sib koom ua ke hauv koj daim ntawv nthuav qhia.
Image - Koj tuaj yeem xaiv txhua yam hauv cov npe txhawm rau xaiv txhua lub xov tooj sib koom ua ke. Thaum xaiv, koj tuaj yeem tshem tawm txhua lub xov tooj raws li xav tau.
