#Grayed out merging cells in excel 2013 how to
#Grayed out merging cells in excel 2013 download

Step 3:Р’В Now, we shall simply click on this merged cell and then click on РІР‚Сљ Format PainterРІР‚Сњ in the Home Ribbon. Step 2:Р’В Next, we shall go to the Home ribbon and click on РІР‚СљMerge & CenterРІР‚Сњ.Р”Р„s we see in the below screenshot, the cells A2, A3 and A4 have been successfully merged. Step 1: We shall proceed with selecting the cells A2 to A4. Suppose we have to merge multiple cells in Excel.Р’В Our objective here is to merge all the cells for a РІР‚СљYearРІР‚Сњ for all entries for a particular year. The trick to Quickly Merge Multiple Cells in Excel Hence the merged cells have been РІР‚СљunmergedРІР‚Сњ by using this option. Now, here we shall select the РІР‚Сљ Unmerge CellsРІР‚Сњ option to unmerge the selected cells. Now to unmerge these cells, we will need to once again to the Home ribbon and navigate to the РІР‚СљMerge & CenterРІР‚Сњ option and click on the drop-down arrow at the side, to open up the underlying options.

#Grayed out merging cells in excel 2013 download

You can download this Merge Cells in Excel Template here РІР‚вЂњ Merge Cells in Excel Template Suppose we have the same set of merged cells that we had seen earlier with the РІР‚СљMerge & CenterРІР‚Сњ option.

#Grayed out merging cells in excel 2013 how to

So now that we have covered how to merge cells in Excel, perhaps it is interesting to know that we can also РІР‚СљUnmergeРІР‚Сњ cells! How to Unmerge cells in Excel? Unmerge Cells:Р’В РІР‚СљUnmerge CellsРІР‚Сњ is the exact opposite of Merge.Merge Cells:Р’В This is perhaps the simplest option РІР‚вЂњ It would just merge the selected cells.Merger Across:Р’В РІР‚СљMerge AcrossРІР‚Сњ would merge the selected cells but would not change the alignment.Merge & Center: This option will merge the selected cells by keeping only the left-hand value and making the text alignment as the center.Let us discuss the different options in the РІР‚СљMergeРІР‚Сњ option mentioned briefly earlier. Step 2:Р’В Next, we shall apply the formula as shown below. Step 1:Р’В First, we shall select the cell C2: The only difference will be that we shall use the РІР‚Сљ&РІР‚Сњ operator instead of the CONCATENATE function. Similar to the way in which we merged two cells using the CONCATENATE function, we shall use the ampersand (&) operator. We can merge multiple cells into one using this method, but it will be in a different cell. РІР‚Сљ РІР‚Сљ = The space between the First Name and the Last Name.Р”В«2 = The last cell that we wish to merge. Now, if we look at the breakup of the formula:Р”Р„2 = The first cell that we wish to merge. On applying this formula, we shall now get the correct results: Step 2: Next, we shall be applying the CONCATENATE formula as shown below. However, the result would be available in a new cell. By using this method, we can successfully merge the РІР‚СљFirst NameРІР‚Сњ and the РІР‚СљLast NameРІР‚Сњ without losing any data in the process. The CONCATENATE formula can merge the contents of multiple cells into one cell. Merge cells UsingР’В CONCATENATEР”Р„s we have seen by now that Excel has a vast array of formulas for various needs.

Let us see what each of these options is in detail. So you might have the question РІР‚вЂњ What is the correct and most effective way to merge cells in Excel? HereРІР‚в„ўs the answer to that. Now we shall discuss the two best ways to merge cells in Excel. This is the main drawback of using the РІР‚СљMerge & CenterРІР‚Сњ option. Due to this, we did get a merged cell, but we lost the РІР‚СљLast NameРІР‚Сњ in the process. So, what happened here is that Excel merged the two cells together instead of the cell values. Step 5: Once we click on РІР‚СљOKРІР‚Сњ, we shall get the following result Step 3: The moment we click on РІР‚СљMerge & CenterРІР‚Сњ, we get a dialogue box pop up showing a warning, mentioning that only the left-hand value would be considered, and the right-hand value would be discarded. Step 2: We will click on the РІР‚СљMerge & CenterРІР‚Сњ option on the Home ribbon next. In this scenario, we shall select cells A2 and B2. Step 1: We will need to select the cells that we wish to merge together. If we wish to merge the contents of РІР‚СљFirst NameРІР‚Сњ and РІР‚СљLast NameРІР‚Сњ, then this method fails as it takes only the left-hand value, completely overwriting the right-hand values. We have a list where the first column (A) contains the first names and the second column (B) has the last names. Let us look at an example to get a better understanding of this drawback.

If we have some data in cells A1 and B1, using this form of merging would result in the retention of the left-hand value and the overwriting of the right-hand value. There is, however, a drawback with this method of merging. Perhaps the most used and one of the simplest ways to achieve this using the РІР‚СљMerge & CenterРІР‚Сњ option available in the Home ribbon. Merging essentially means having the combined values of multiple cells in one.

Excel functions, formula, charts, formatting creating excel dashboard & others Merge Cells in Excel UsingР’В Merge & Center Option