El merge operate in Microsoft Excel lets iou mix a number of Excel cells right into mixed single cell. Heu benejat les steps per Merge and Unmerge cells in Excel.
Merge and Unmerge Cells in Excel
Una de les freqüències vitals d'utilitzar les mercaderies operatives d'Excel, s'employen per als seus personals és crear-se a heads or title per content material unfold throughout a number of columns.
Altres causes per mergir cells en l'Excel poden inserir emblem o imatge matxing width of content material and different such formatting causas.
Whereas the Merge operate combines cells, the Unmerge choice in Excel splits again beforehand Merged cells in particular person single cells, simply as they existeix earlier than being merged.
What Occurs to Content material a Merged Cells
Earlier than going forward with steps a Merge cells in excel, és essencial en grasp a les occurs if you Merge dues o extra cells comptaining knowledge in a l'Excel spreadsheet.
While you Merge cells containing knowledge, solement la informació s'hi high left cell (first cell) will stay within susuing Merged cell, whereas knowledge in different cells will get discarded (See picture beneath).
Equally, if you Unmerge cells containing knowledge, all the information will positioned within first cell and different cells develop into empty.
Fortunately, Excel does present a warning message informing ou about such knowledge elss if you attempt to Merge cells in Excel.
Tipus on how to Merge Cells in Excel
Comply with the steps beneath to Merge Cells in Excel.
1. triï el Les cèl · lules that you just need to merge, click on on the Residència tab after which click on on Unir botó.
2. On the pop-up that seems, click on on OK fonamentar.
3. Per a clicar on OK, vostè instantly see the chosen cells Merged or mixed right into a single cell.
Aix y'll be able to see in above picture, cells A1 to D1 have been merged right into a single Cell.
Unmerge Cells in Excel
Unmerging Cells in Excel és simples simples Merging cells.
1. Merely, choose the Merged cell and click on on Merge/Unmerge icona.
Alternately, you may also click on on the Fletxa cap avall subsequent to the “Merge/Unmerge” icon and click on on Desajunta les cel·les choice within the drop-down menú.
2. You'll instantly see the Merged Cell reverting again in to particular person single cells.
Different Merge Cell Choices in Excel
The Merge Cells Operate in Excel supplies al nombre d'extra choice que tot just hey be all for.
Click on on the Fletxa cap avall subsequent a la “Merge Icon” i és possible per a vostè per a tot el que és obtainable Merge choices amb el drop-down menu.
- Merge & Heart: Combines chosen Cells right into a Single Cell i contenen material mitjançant cell can be centered.
- Merge Throughout: Combines solely les colles cells in a row, no són les cells in a columna.
- Mere Cells: Combines chosen Cells
- Unmerge Cells: Splits the chosen Merged cell into particular person or single cells
- Tips on how to Cover Cells, Rows and Columns In Excel
- Tipus on how to AutoFit Column Width and Row Peak in Excel
Em dic Javier Chirinos i sóc un apassionat de la tecnologia. Des que tinc ús de raó em vaig aficionar als ordinadors i als videojocs i aquesta afició va acabar en una feina.
Porto més de 15 anys publicant sobre tecnologia i gadgets a Internet, especialment a mundobytes.com
També sóc expert en comunicació i màrqueting en línia i tinc coneixements en desenvolupament a WordPress.