How to Combine Cells in Excel

Excel offers extensive functionality for its users. But to enjoy all these benefits, you need to study all the available functions of this Microsoft app. In this article, we are going to show you how to combine cells in Excel.

We suggest you to study several ways on how to combine two cells in Excel to choose the one that is convenient for you. We will also share the secret of how to combine cells so that the values inside them are saved.

The 1st way to merge cells in Excel

We will do this through the main menu of the app. To perform this function, follow the instructions below.

Step 1. Select the cells you want to merge

Select the cells you want to merge

Step 2. Select the “Main menu”

Select the “Main menu”

Step 3. Find the “Merge Cells” icon

Find the “Merge Cells” icon

When you click on this icon, the two cells will turn into a single one.

Moreover, if one of the cells contained values, they will be saved in the new cell. And the information will be aligned to the center of the cell.

"Merge Cell" Options

The “Merge Cell” icon offers us even more functionality for working with cells.

To see all available options, click on the small down arrow next to the icon:

“Merge Cell” icon

Then you will see a window with the following options:

The first option “Merge and Center” is what happens automatically when clicking on the icon. The cells are merged into a single one, and the information is displayed in the center of the new cell.

The second option “Merge Across” provide with combining by lines; it allows us to select a large range of cells, within which the cells are merged by lines. For example, 

Step 1. We’ll highlight the following cells:

We’ll highlight the following cells

Step 2. Choose the “Merge Across” option to combine the cells by lines:

“Merge Across”

Step 3. Our cells are transformed like this:

The third option “Merge Cells” will make the values inside the cell right-aligned.

And the fourth option “Unmerge Cells” provides canceling the merge function. If you accidentally merged the wrong cells, you can use this function.

The 2nd way to combine cells in Excel

The next way on how to combine cells in Excel can be done through the right-click context menu of the mouse.

Step 1. Select the desired range of cells

Select the desired range of cells

Step 2. Select the desired range of cells. Such a window will appear

Select the desired range of cells

Step 3. Find the “Format Cells...” line 

Find the “Format Cells...” line 

Step 4. Go to the “Alignment” tab in this menu

Go to the “Alignment” tab

Step 5. Check the box next to “Merge Cells”

Check the box next to “Merge Cells”

Step 6. Click on “OK”

Click on “OK”

Thus, the cells you selected turned into a single one.

The described methods of how to combine two cells in Excel are suitable if only one of the two selected cells or none of the cells contained values.

If you start combining several cells, each of which contains some information, the Microsoft app will give you a warning:

Microsoft Excel will give you a warning

If you are willing to donate your values, you can confirm merging. In such a way, merging cells only keeps the upper-left value and discards other values.

If you want to save values from all the cells, you can follow these options:

  • Overwrite values from all the cells into one manually
  • Copy and paste the values via keyboard shortcuts or a context menu

In any case, the program does not yet offer us an option on how to combine two cells in Excel by simultaneously combining all the information in them at once.

We told you about the easiest and fastest ways of how to combine cells in Excel in this article. Choose the option that is convenient for you and use it as needed.

Now, the multifaceted functionality of the Excel app will not be so mysterious and incomprehensible to you.

51 articles11,629 likes
0 responses
Sign in to wright a response.
Read this next
Microsoft Excel, a popular spreadsheet program, is equipped with a wide range of tools for creating any and all graphs and charts. With their help, you can visually show the dynamics of various numerical data and the relationship between them. Very often, a standard curve graph is used for these purposes.
Microsoft Office Programs
To understand how to calculate the relative frequency in Excel, you should only take a few simple steps. We will also show how to build a colorful and informative histogram based on the data received.
Microsoft Office Programs
Why may it become necessary to freeze multiple rows in Excel? For example, to keep column headings always in sight when scrolling. In this article, we’ll tell you how to freeze multiple rows in Excel.
Microsoft Office Programs
Written by
51 articles11,629 likes
Do you have any question?
Try to use search or ask your question by clicking the button below
Was this article helpful?
We’re so sorry :(
Thanks a lot :D