![merge cells in excel merge cells in excel](https://www.wikihow.com/images/8/8a/Unmerge-Cells-in-Excel-Step-5-Version-3.jpg)
Now you should be able to merge cells inside the sheet. If the sheet has been protected with a password, then you will need to enter it in order to unprotect the sheet. This can be done by going to the Review tab and clicking the Unprotect Sheet command. In order to access the Merge option, you will need to unprotect the worksheet. If most of the other commands in the ribbon are greyed out too, then it’s likely the sheet is protected.
![merge cells in excel merge cells in excel](https://cdn.goskills.com/blobs/blogs/517/originals/4ef148cc-d765-4afc-818e-79324287b322.gif)
On occasion, you might find the Merge & Center command in Excel is greyed out and not available to use. For example the First and Last name columns are organized with a Name merged cell. The above example shows two merged cells in B2:C2 and D2:F2 which indicates the category of information in the columns below. Any other values or formulas are discarded. When you merge cells, only the value or formula in the top left cell of the range is preserved and displayed in the resulting merged cell. Merging cells is a common technique used when a title or label is needed for a group of cells, rows or columns. The above example shows a single merged cell resulting from merging 6 cells in the range B2:C4. You can only merge contiguous cells that form a rectangular shape.
![merge cells in excel merge cells in excel](https://study.com/cimages/videopreview/screenshot-702_132045.jpg)
Merge cells in excel how to#
How to Get Data from Merged Cells in ExcelĪ merged cell in Excel combines two or more cells into one large cell.Merged Cells Only Retain the Top Left Values.