How to merge cells in a range formatted as table in Excel?


In the article, the users are going to merge the cells in a range formatted as a table in Microsoft Excel. There are numerous types of structures within the Excel sheet including home, Merge & Center, Merge same cells from Ku-tools, and Convert To Range tab that will merge the cells according to the need. The users can use the Convert to Range tab to merge the cells which you need in the center position. This method may be completed utilizing an easy way within Microsoft Excel by using the Merge & Center tab to merge the cells in a center position that is formatted.

Example 1: By using Convert to Range tab option

Step 1

Deliberate the Excel worksheet. First, open the Excel sheet and create the table one by one from cells A1 to D9 in any cell according to the need and select the whole table as shown below.

Step 2

After selecting it, place the cursor in the ribbon. In the ribbon, there are many tabs included in the top corner. Place the cursor in the Design tab and click on the tab that has many options included. On the Design tab, place the cursor and click on the Convert to Range tab on the Tools group that opens the dialog box. In dialog box, click on the Yes button that will convert to the range from the table as shown below.

       

Step 3

In the sheet, place the cursor in row A and select the cells from A1 to A9 to merge it in a range formatted. After selecting it, place the cursor in the ribbon. In the ribbon, there are many tabs included in the top corner. Place the cursor in the Home tab and click on the tab that has many options included. On the Home tab, place the cursor to the Merge & Center tab that has the drop-down menu. Click on the menu that has many options included then click on the Merge & Center tab to merge the cells in a range as shown below.

Example 2: By using Kutools tab

Step 1

In the sheet, place the cursor in the ribbon. In the ribbon, there are many tabs included in the top corner. Place the cursor in the Ku-tools tab and click on the tab that has many options included. On the Ku-tools tab, place the cursor and click on the Merge & Split tab which has a drop-down menu on the Ranges & Cells group. Click on the menu and select Merge Same Cells tab which will automatically merge the cells in a range formatted as shown below.

The users utilized the easy instances to display how they merge the cells in a range that is formatted with shortcut different approaches by using the Merge & Center tab and Ku-tools tab. The users used the necessary tabs which are included in the ribbon. They have to practice the essential options from the ribbon and modify the data according to the need.

Updated on: 28-Jul-2023

228 Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements