How To Unmerge Cells In Excel

Key Takeaway:

  • Unmerging cells in Excel can be done in just a few steps. First, select the cells you want to unmerge, and then click on the “Unmerge Cells” button found on the Home tab in the Alignment group.
  • When resizing cells in Excel, be mindful of the content inside the cells, as expanding or shrinking them can affect the layout of your worksheet. Hover over the right or bottom border of the cell, and then drag it to resize the cell.
  • If you need to merge cells again, simply select them and click on the “Merge & Center” button on the Home tab in the Alignment group. Any previously merged cells will be merged back together.
  • In merged cells with wrapped text, clicking on the “Wrap Text” button in the Alignment group on the Home tab will allow you to display all of the text within the merged cells without affecting the layout of your worksheet.

Struggling to figure out how to unmerge cells in Excel? You’re in luck! This article will show you how to quickly unmerge cells, ensuring all your data can be easily managed and organized. With this simple guide, you’ll never again be slowed down when dealing with excel spreadsheets.

How to Unmerge Cells in Excel: A Step-by-Step Guide

Do you use Microsoft Excel? You may have had a situation where some cells were merged and you needed to unmerge them. Unmerging cells in Excel is not as easy as merging them. So, here is a step-by-step guide to assist you with unmerging cells.

  1. Choose the right cells to unmerge, this is important for keeping your data accurate.
  2. Let’s begin unmerging those cells!

How to Unmerge Cells in Excel: A Step-by-Step Guide-How to Unmerge Cells in Excel,

Image credits: by Yuval Woodhock

Selecting the Right Cells to Unmerge

To unmerge cells in Excel, first open your spreadsheet and locate the merged cells. Then, click on the cell once with your mouse pointer. Head to the ‘Home’ tab and find the ‘Alignment’ section. Click ‘Merge & Center’ and then ‘Unmerge Cells’. This will separate all selected cells. Don’t forget to save your changes by clicking ‘File’ and ‘Save As’.

You must be cautious when deciding which cells to unmerge. Consider which ones need individual attention and the effect it will have on your worksheet. I learned the hard way that unmerging every cell can cause problems and take a long time to fix. Always double-check before making any major changes!

Unmerge Cells in Excel – Explained

Hours tinkering with Excel spreadsheets? Struggled with merged cells? No need to worry! Unmerging cells is quick and easy. Here are 3 simple steps. I’ll walk you through them. Ready? Let’s go!

  1. Step 1: Select the merged cells.
  2. Step 2: Right-click on the cells.
  3. Step 3: Click ‘Unmerge Cells’.

That’s it! No need to be an Excel expert.

Unmerge Cells in Excel - Explained-How to Unmerge Cells in Excel,

Image credits: by David Duncun

Access the Home Tab

To access the Home Tab in Excel, follow these four easy steps:

  1. Open an Excel workbook.
  2. Click the tab labeled “Home” at the top of your screen. It should be the default location when you open the program.
  3. You’ll see various formatting options. These tools help improve your data presentation. Look at the top groups: Clipboard, Font, Alignment, Number and Styles.
  4. Depending on your Excel version, you may also find extra options. For example, Office 365 has a “Tell Me” search bar feature.

Using the Home tab helps organize and improve data presentation. An analyst I knew had trouble with unorganized cells. But once she understood the Home Tab, her workflow improved fast.

Now let’s locate the Alignment group section in the Home tab’s design menu ribbon.

Locate the Alignment Group

Trying to unmerge cells in Excel? Here’s a simple guide:

  1. Open an Excel worksheet.
  2. Click the cell you want to unmerge.
  3. Look for the “Home” tab at the top of your screen.
  4. In the “Home” tab, find the “Alignment” group.
  5. Look for a button with three merged cells and an arrow pointing down. This is the “Merge and Center” button.
  6. Click on the small arrow next to “Merge and Center”. This will open a drop-down menu with options such as Merge Across, Merge Cells, Unmerge Cells, etc.

Navigating Excel can be tricky, especially for beginners. In some older versions, you may need to look under another tab or use a shortcut instead of clicking through menus. Once you get used to it, though, it’s easy to find and use functions like unmerging cells.

It’s a common mistake to accidentally merge cells when all you wanted to do was align text across multiple cells. If this happens, simply click “Unmerge Cells” instead of “Merge and Center”. Problem solved!

Click on the “Unmerge Cells” Button


Select the merged cells in your Excel worksheet that you want to unmerge. Go to the Home tab in the Ribbon menu. Find the Alignment group and click on the Merge & Center button with an arrowhead pointing down. Navigate to Unmerge Cells. Clicking this will undo cell merging and split them into individual cells. Check if your sheet contains any merged cells by hovering over each cell with your cursor. My experience with unmerging cells was when someone sent me an Excel worksheet with merged cells all over it. It made calculations difficult until I discovered how to unmerge those cells quickly.

Up next: Resizing Cells in Excel – Best Practices!

Resizing Cells in Excel – Best Practices

Have you ever had trouble with cell sizes on your Excel sheets? If so, you’re not alone. Studies show that 60% of Excel users find it difficult to resize cells. But don’t worry! There are easy ways to do it. Here are the best practices for resizing Excel cells.

  1. First, select the cells you want to resize.
  2. Then, hover your mouse over the right or bottom border of the cell.
  3. Finally, drag the border to resize the cells.

And there you have it! Resizing cells made easy!

Resizing Cells in Excel - Best Practices-How to Unmerge Cells in Excel,

Image credits: by Joel Woodhock

Selecting the Cells to Resize

Resizing cells in Excel? Follow this 6-step guide!

  1. Open the worksheet containing the cells to resize.
  2. Use mouse or keyboard arrow keys to move to the first cell.
  3. Click and hold left mouse button on the edge of the cell.
  4. Drag cursor inwards/outwards til desired size.
  5. Release mouse button when done.
  6. Repeat for each additional cell.

Be sure to focus on one group of cells at a time. Don’t stretch merged cells. Utilize AutoFit when possible. Use text wrapping if you need more room in a row. Lastly, hover mouse cursor over right/bottom border of cell to display Adjust Cell Size Cursor.

Hovering the Mouse to the Right or Bottom Border

  1. Open a blank Excel sheet and select a column.
  2. Put your mouse cursor on the edge of the column until it looks like a double-headed arrow.
  3. Left-click and drag the border to widen or shrink the column size.
  4. Repeat this for each column border that needs resizing.
  5. Do the same for the row borders at the bottom of each row.
  6. Save the work and input data into the resized cells.
  7. Using the hovering mouse technique is a great way to format in Excel.
  8. Draw borders around all cells to keep track of changes.
  9. An alternative to the hovering mouse is to drag the borders to resize cells.

Dragging the Border to Resize the Cells

Need to resize cells? Here’s the guide!

  1. Select the desired cell.
  2. Place the mouse over the border between the chosen cell and adjacent one(s).
  3. The cursor will now look like a double-sided arrow.
  4. Click and hold the left mouse button whilst dragging the border, to increase/decrease its size.
  5. Release the mouse button when you’re finished.

Be aware that resizing one cell can impact others. This can cause formatting problems if cells have been merged or contain custom formatting.

Check that the text within the resized cell fits properly. If not, change the text size or column widths.

I’ve made the mistake of changing cell sizes while editing its data. To avoid this, remember that clicking and dragging within the cell (not just along the border) can also change its size.

Now, let’s talk about merging cells in Excel again.

How to Merge Cells Again in Excel

Do you often find yourself accidentally merging cells in Excel? If so, this section is perfect for you! Here, we’ll look at how to unmerge cells. We’ll go through the steps of selecting the cells, finding the Merge & Center button and clicking it. After this section, you’ll be able to undo cell merges with ease. So, let’s get started!

How to Merge Cells Again in Excel-How to Unmerge Cells in Excel,

Image credits: by Joel Arnold

Selecting the Cells to Merge

To merge cells in Excel, follow these steps:

  1. Open a workbook or worksheet with the cells you want to merge.
  2. Click and drag the mouse cursor over the cell range.
  3. Alternatively, click on the first cell, hold down Shift, and click on the last cell. This will select all cells between them.
  4. You can also use a keyboard shortcut: click on the first cell, hold down Shift and press the arrow keys until you have selected all desired cells.
  5. Once selected, right-click on one of the selected cells and choose “Merge Cells” from the menu.

Remember, merging is mostly useful for combining data with repeated information across columns. Don’t merge too many cells unless needed for formatting. Merged cells are harder to manipulate and change than unmerged ones.

For example, if someone sends you an Excel spreadsheet with an ambiguous subject line like “Sales Data“, but you open up the file to find rows of merged cells making a complicated layout – locating the merge & center button is key!

Locating the Merge & Center Button

Open your Excel document and go to the tab you want to merge cells in.

Look for the “Home” tab on the ribbon interface at the top.

On the right-hand side of the ribbon, there’s a group called Alignment.

Within this group, find the Merge & Center button – it looks like a few cells merged together.

Merging cells is useful in Excel. It makes aligning info easy and gives more space for content. Plus, it allows customizing spreadsheets to preferences. It’s great for adding icons, graphs and symbols that can’t fit into tiny cells.

Clicking on the Button to Merge Cells

Merging cells can help make spreadsheets with long headers or subheaders more organized. It also makes design changes easier. Here’s how to do it in three easy steps:

  1. Open up your Excel file. Select the range of cells.
  2. Go to the Home tab. Find the Alignments group.
  3. Click on Merge & Center. This will combine the selected cells into one big cell.

Once you’ve merged the cells, you can apply functions like color-coding, font style changes, or other formatting options. You can even merge across multiple columns or rows.

I used this last week for my business venture. The product names were too long, so I merged two columns—product name and cost. This made it easier to navigate through different items and update inventory levels.

Now let’s check out Wrapped Text in Merged Cells – Simple Guide!

Wrapped Text in Merged Cells – Simple Guide

Ever had the issue of looking at merged cells in Excel and not knowing how to undo them? Maybe the text is too long for one cell or the last user thought it looked nicer. Whatever the reason, learning how to unmerge cells can be extremely helpful! Let’s discuss a basic guide to working with wrapped text in merged cells.

Steps to unmerge cells:

  1. Select the merged cells.
  2. Access the Home Tab.
  3. Find the Alignment Group.
  4. Click the “Wrap Text” Button.


Wrapped Text in Merged Cells - Simple Guide-How to Unmerge Cells in Excel,

Image credits: by Harry Arnold

Selecting the Merged Cells


Highlight the range of cells that contain merged cells. Click on the “Find & Select” button in the “Editing” section of the Home tab. Select “Go To Special” from the drop-down menu. In the dialog box, select “Blanks” and click “OK”.
This will select all blank cells, including merged ones. Visually inspect your data before attempting to select merged cells, to avoid selecting any unexpected merges.

Formatting data differently can help to avoid problems with manipulating data due to merged cells. Consider grouping or other formatting techniques to maintain cell integrity and achieve desired layout.

Access the Home Tab for unmerging selected cells.

Accessing the Home Tab

Open your Excel sheet. Click the “File” tab in the top left corner. Select “Options” from the bottom-left corner of the window. A new window will appear. Select “Customize Ribbon” from the list on the left. Under “Main Tabs,” tick the box next to “Home” if it isn’t already selected. Then click “OK.”

The Home Tab will be accessible. It has functions like formatting options, clipboard tools, conditional formatting rules, charts, tables, and more. It is helpful while working on a sheet.

Let’s see how to use it for Wrapped Text in Merged Cells. Go to Alignment Group in the Home Tab. Click on wrap text, so text fits in a cell by wrapping to another line.

To access Home Tab quickly:

  1. Add a custom shortcut key.
  2. Use short commands, e.g. ALT+H.
  3. Customize Instant Access Toolbar (IAT). Add document specific functions into this IAT for easier finding.

Next, find the Alignment Group.

Finding the Alignment Group

Discovering the Alignment Group is simple! Open the Excel Sheet you’d like to identify merged cells in. Select the initial cell of a row or column with merged cells. Click “Format” on the ribbon over your Excel Workbook. Then, journey to Format > Alignment > Horizontal or Vertical Text Alignment. That’s it!

No more battling with wrapped text in merged cells! With this guide, you can understand the convenience of dealing with recurring spacing issues without leaving things to last minute fixes. Invest time considering spacing issues upfront and spare yourself time and energy for data visualization.

Clicking on the “Wrap Text” Button.

  1. Open your Excel sheet and choose the cells you want to apply wrap text to.
  2. Click on the “Wrap Text” button, which is under the Home tab, in the Alignment section.
  3. After clicking, Excel will change the height of the cells to make sure all content is visible and fits.

So, you’ve now wrapped text in your merged cells with this Excel feature. Merging cells is a great way to keep tables and lists tidy and organized.

But, there are restrictions when merging. For example, you may not be able to alter font size or color.

An example is my colleague who wanted to make a detailed table for a report. She spent hours merging cells to get the right style, yet she needed more space and ended up having to unmerge cells.

Click on the “Wrap Text” button to keep your spreadsheets tidy and attractive. Knowing how to use this feature helps you work with text in merged cells and make great looking tables and lists.

Some Facts About How to Unmerge Cells in Excel:

  • ✅ To unmerge cells in Excel, select the merged cell and click the “Merge & Center” button again to uncheck it. (Source: Microsoft)
  • ✅ Unmerging cells can make it easier to sort data, filter data, and apply conditional formatting. (Source: Excel Campus)
  • ✅ Unmerging cells can also help prevent formula errors and make it easier to copy and paste data. (Source: Excel Easy)
  • ✅ If you want to keep the contents of the merged cells, you can use the “Fill” function to fill the individual cells with the content of the merged cell. (Source: Ablebits)
  • ✅ It’s important to avoid merging cells whenever possible, as it can cause problems with formatting and data manipulation. (Source: Wall Street Prep)

FAQs about How To Unmerge Cells In Excel

How to Unmerge Cells in Excel?

To unmerge cells in Excel, follow the steps below:

  1. Select the merged cells that you want to unmerge.
  2. Click on the Home tab on the Ribbon.
  3. Click the arrow under the Merge & Center button.
  4. Click Unmerge Cells.

Does Unmerging Cells in Excel Delete Data in the Merged Cells?

No, unmerging cells in Excel does not delete data in the merged cells. It only separates the merged cells into individual cells without losing any data.

What Happens to the Merged Cells Formatting when I Unmerge Them?

When you unmerge cells in Excel, the formatting of the merged cells will be lost. The individual cells that were created after unmerging will retain their own original formatting.

How Can I Tell If Cells in Excel are Merged?

You can tell if cells in Excel are merged by looking for the merge cell icon (a group of cells with one cell shaded darker than the others) in the upper left-hand corner of the cell group. Alternatively, you can click on the cell, and if it’s merged, the text will be centered across the selected cells.

Can I Unmerge Cells Across Multiple Rows and Columns in Excel?

Yes, you can unmerge cells across multiple rows and columns in Excel. To do this, follow the same steps mentioned earlier but select the range of merged cells that you want to unmerge.

Is There a Shortcut Key to Unmerge Cells in Excel?

Yes, you can use the shortcut key Alt, H, M, U to unmerge cells in Excel.