How to Merge Cells in Excel


How to Merge Cells in Excel

Do you want to spruce up your report? Spreadsheets don’t have to be boring, disorganized, and hard to understand. Instead, you can learn how to merge cells in Excel to make your spreadsheet layout attractive.

How to merge cells in excel

Microsoft excel is the searched after spreadsheet system that permits you to put together your data in rows and columns. This system gloats of a consolidation cells include that will empower you to join data from various cells into a solitary cell in succession or segment.

You can sort out and control the data by blending the rows and columns to suit your report. In addition, Excel permits you to unmerge the cells.

Figuring out how to combine cells in excel is simple. In the event that you need an efficient and alluring spreadsheet, at that point follow the means laid out underneath.

Reasons for Merging Cells

merging cells gives you an efficient record, yet it additionally tweaks your spreadsheet giving it a spotless look. You ought to figure out how to join cells in excel to focus your title over all columns in the given archive or report. Likewise, merging sorts out and joins a few areas under a solitary heading. In addition, in the event that you incidentally combine rows and columns, at that point you will part or unmerge them. It is insightful to gain proficiency with the ropes of merging first in light of the fact that consolidated cells can be part. Subsequently, merging cells arranges your report making it simple to peruse and comprehend

Merge Options

There are four primary merge options available in Excel.

  • Merge & Center: This alternative merged cells and aligns text at the center while retaining the top and left most data.
  • Merge Across: This option combines cells in columns without changing their alignment.
  • Merge Cells: It is the simplest method of merging the selected cells
  • Unmerge Cells: It is the opposite of merging because it unmerges or splits the cells.

Let’s get started on how to merge cells in Excel

Method 1: Merge & Center Option in Excel

The Merging command is located on the Excel Home Tab.

  • First, highlight the cells to be merged by clicking on the first cell to be highlighted, hold down the Shift Key, and then click on the last cell range.
  • Afterward, maneuver to the Merge & Center button located under the Home Tab.
  • Click on the Merge & Center to merge your preferred cells. However, a warning window appears, cautioning you that proceeding with the merging process will not only discard other values, but it will also retain the left-values only.
  • Click OK to proceed if you are comfortable with such changes.

How to Merge Columns in Excel

It is easy to merge columns in Excel. Select the multiple columns you wish to join and repeat the above process.

  • The first step is to highlight the two columns you want to merge. For instance, you may want to combine the “First Name” and “Last Name” like in the example below.
  • Take note that selecting the Merge & Center button will provide you with one large cell that has only one value.
  • Click on the Merge & Center drop-down menu and choose Merge Across. Instead of a single warning, Excel will give you several warnings depending on the number of rows selected.
  • Click OK for each row to get a newly merged column, as shown below.

How to merge columns in excel

Method 2: Merging Multiple Cells using the Format Method

Another easy method to merge cells is using the format menu.

  • Highlight the multiple cells to be merged.
  • Then, On the Home Tab, click on “Alignment”.
  • Alternately, Right Click on the selected text.
  • From the menu, click on Merge Cells. In both options, a Format Cells window will be displayed.
  • Locate the Alignment Tab and check on the “Merge Cells” option.
  • Then click OK to combine your multiple cells into a single cell.

Disadvantages of Using the Merge Cells on Excels

Albeit 53% of excel clients use the Merge Cells Feature, merging cells makes various data issues. Most importantly, it is hard to reorder data. Furthermore, it is difficult to feature a solitary section that contains numbers as data. Thirdly, the alternative of Autofill is crippled, which makes it trying to save money on time on Excel. Finally, since merged cells are not like the first cells, you can’t utilize basic Excel highlights, for example, COUNTIFS and SUMIFS. Consequently, the ideal choice to counter these issues is utilizing the “Middle Across Selection” merging choice.

How to Merge Cells without Losing Data

Method 1: Center Across Selection

Center Across Selection does not modify and combine cells. Instead, it only aligns the relevant text at the center. Therefore, when merging cells, you don’t lose any functionality such as copy, paste, or Autofill.

  • The first step is to select the text you want to join across.
  • Next, click on the Alignment Tab in Alignment Group Dialogue and locate the Format Cells found in the dialog box.
  • Alternatively, press CTRL+1 to launch the Alignment Group Dialogue box.
  • After that, a dialog box will appear, click on the Horizontal Menu, locate, and select the “Center Across Selection” option.
  • After clicking OK, the text will appear merged just like in the “Merge Cells”.

Notwithstanding, the main contrast is that the cells are unblemished, including their usefulness. Kindly note that this alternative just works for flat gatherings. Thusly, you’ll have to merge cells vertically. Likewise, guarantee that you get cells together with single passages since data from different sections might be fruitless to emerge.

how to merge across

Method 2: Concatenation Formula

The Concatenation formula is the best option for merging cells if you don’t want to lose your data. What’s more, this formula is the best for joining multiple cells such as “First Name” and “Last Name” into a single cell. However, a new cell will be created for the result.

  • First of all, select cell “C2” and apply the CONCATENATE formula (A2,” ” B2) to get the desired results.
  • A2 refers to the first cell to be merged, whereas B2 is the last cell to be merged.
  • The space between the first name and the last name is represented by the two quotations (“) marks.

how to merge cells using concatenation formula

Method 3: How to Merge cells using Ampersand (&) Operator

The Ampersand (&) Operator is similar to the Concatenation formula. However, whereas ampersand uses “&” operator function, the latter use the CONCATENATE function.

  • First of all, select Cell 2 titled “Full Name”.
  • After that, apply the formula =A2&“ “&B3 to give the desired result as illustrated below.

How to Unmerge Cells In Excel

If you need to split the previously merged cells, then you can unmerge them.

  • Select the merged cells 
  • Click on “Unmerge Cells” on the Merge & Center Ribbon under the Home toolbar.

Notwithstanding, unmerging cells consistently place the data on the upper left cell leaving the wide range of various cells clear. Likewise, data, when lost during merging, can’t be recuperated in the wake of unmerging the cells. In any case, unmerging tackles the immense spaces in your spreadsheets brought about by merging rows and columns.

Limitations of Merging Cells using Excel

In any case, Excel’s essential shortcoming is that solitary the upper-left estimation of cells is held while all other data is disposed of. In spite of the fact that data from one cell is held, the substance of at least two cells can’t be merged. Subsequently, just the data from the upper-left will be kept in the wake of merging.

Besides, Excel just merges cells that structure a rectangular shape. For example, it is conceivable to consolidate data from cells C1, C2, D1, and D2. Notwithstanding, it is difficult to merge cells from C1, C2, and B1 as it were. Ultimately, the sort order doesn’t work on the generally merged cells.

So, Excel is the best spreadsheet system to present or report data. Particularly, figuring out how to merge cells modifies your report giving it a clean, exceptionally coordinated, and straightforward look.

Remember that when utilizing Excel, just data in the top and the furthest left cell is utilized. Data from different cells is consequently erased. Albeit merged data can be part, it is fitting, in this manner, to back up significant data for future reference.

In case you’re searching for a software organization you can trust for its respectability and genuine strategic approaches, look no farther than SoftwareKeep. We are a Microsoft Certified Partner and a BBB Accredited Business that thinks about bringing our clients a solid, fulfilling experience on the software items they need. We will be with you previously, during, and after all the deals.