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.
You are trying to merge cells inside an Excel table.There are two reasons why the Merge & Center command can become unavailable. 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. What is a Merged CellĪ merged cell in Excel combines two or more cells into one large cell. I’ll also tell you why you shouldn’t use them and a better alternative that will produce the same visual result. In this post, I’ll show you everything you need to know about merged cells including 8 ways to merge cells. This does the trick, so all that’s left to do is press ctrl-b to bold the text.Merged cells are one of the most popular options used by beginner spreadsheet users.īut they have a lot of drawbacks that make them a not so great option. It needs to be centered vertically, so we need to click the Middle Align button in the Alignment group. What’s wrong? Well, the text is centered – horizontally. Hold on, we selected Merge and Center, but the text isn’t centered. Select Rotate Up, and we should get the following: Now click the Orientation button, also in the Alignment group. Those cells are merged, but we can’t see all the text. Select cells A2 – A14 and then click the Merge and Center button. The text needs to be in the bottom row because we’re going to rotate the text anticlockwise, as we’ll see. Now, we can type the text “Months of the year – 2010″ in row A14. Suppose we move our table to the right by one cell to make room for a row title. We can do a similar thing vertically for row headings. Cells are merged and title centered! Press Cctrl-b to bold the text and there we have a nice looking title.
Select cells A1 to D1 and then click Home > Alignment > Merge and Center. We can do that with just one button: the Merge and Center button. It would help if we could merge all the cells above the table headings for the title to occupy and also center the title. When we type the title “Sales By Month For 2010″, we can see that it spills out into other cells. This is where Excel’s merge and center command comes in.įor example, look at the following spreadsheet that contains data about sales by month for the year 2010. Often in your worksheets, you’ll need a title or heading to span multiple cells and you’ll want Excel to display the title or heading in the center.