Learn How You Can Merge Rows and Columns in Microsoft Excel Office 365

Suppose you need to merge some of the rows or columns or both. Then check below some excellent tips we showed how you could merge.

First Way

First, Open Microsoft Office 365 Excel in your fav browser, Then open excel by clicking the recent one or the New blank workbook as shown below.

Then select the number of rows and columns you want to merge, as shown in the picture below.

Now select Merge and Center from the drop-down. It will merge all the selected rows and columns, plus whatever text is written inside the first column will come in the middle. But if you don't want the text to be in the middle then you the third option of Merge Cells.

Now after clicking Merge & Center, you will see this result as shown in the image below.

Second Way

Another way is also very simple first, and you need to select the area where you want to apply merge rows and columns, as shown in the image below.

Then click on the color selection icon and select the white color as shown in the image below. ( Not recommended )

Here you will see the result after adding white color to the particular rows and columns.

Merging rows and columns is a constructive tip because sometimes you need to write an extended header, and you want to merge few rows and put text in the middle. If you want to put text in the middle after merging, then use Merge & Center. But if you don't want the text to be in the center after merging, then use the third option, Merge Cells.

Check out the list of all other articles:

• Learn How to Get nth Match in Microsoft Excel
• Learn How to Find Missing Values in Microsoft Excel
• Learn How to Get nth Smallest Value With Criteria in Microsoft Excel
• Learn How to Sort by Text Length in Microsoft Excel
• Learn How to Sort by Two Columns in Microsoft Excel
• Learn How to Sort by Random in Microsoft Excel
• Learn How to Sort by One Column in Microsoft Excel
• Learn How to Sort by Custom List in Microsoft Excel