How to Split Cells in Excel: 5 Steps (with Pictures)

How to Split Cells in Excel: 5 Steps (with Pictures)
How to Split Cells in Excel: 5 Steps (with Pictures)

Table of contents:

Anonim

This wikiHow teaches you how to split merged cells into two or more standard cells in Microsoft Excel.

Step

Unmerge Cells in Excel Step 1
Unmerge Cells in Excel Step 1

Step 1. Open the Excel file

Double-click the Excel file that you want to open.

Unmerge Cells in Excel Step 2
Unmerge Cells in Excel Step 2

Step 2. Select the merged cells

Find the cell you want to split, then select the cell by clicking on it.

  • Merged cells take up two or more columns of space. For example, merging cells that are in a column A and B will result in a cell that extends from the column A to B.
  • You cannot unmerge a cell that has not been merged with one or more other cells.
Unmerge Cells in Excel Step 3
Unmerge Cells in Excel Step 3

Step 3. Click the Home tab at the top of the Excel window

Toolbar (toolbar) Home will be opened.

When you have opened the tab Home, skip this step.

Unmerge Cells in Excel Step 4
Unmerge Cells in Excel Step 4

Step 4. Open the "Merge & Center" menu

Click the drop-down arrow icon (drop-down)

to the right of the button Merge & Center in the " Alignment " section of the toolbar. A drop-down menu will be displayed.

Unmerge Cells in Excel Step 5
Unmerge Cells in Excel Step 5

Step 5. Click Unmerge Cells in the drop-down menu

The cells you selected will be split, and the cell values will be added to the leftmost cell.

For example, if there is "Hi" in the merged cell, the word "Hi" will be placed in the leftmost cell after you split the cells

Tips

If you are using Excel in a language that reads from right to left, the split cell values will be placed in the far right cell

Recommended:

How to Freeze Cells in Excel: 9 Steps (with Pictures)

How to Freeze Cells in Excel: 9 Steps (with Pictures)

This wikiHow teaches you how to freeze specific rows and columns in a Microsoft Excel worksheet. By freezing a row or column, certain boxes will remain visible as you scroll through a page containing data. If you want to easily edit two parts of a spreadsheet at the same time, separate spreadsheet panes or windows to make editing easier.

How to Merge Cells in Excel: 4 Steps (with Pictures)

How to Merge Cells in Excel: 4 Steps (with Pictures)

This wikiHow teaches you how to join two or more cells in Excel. This method works on both Windows and Mac versions of Excel. Step Step 1. Open the Excel document Double-click the Excel document to open it in Excel. If you don't have an Excel document yet, open the Excel program and click Blank Workbook .

How to Lock Cells in Excel (with Pictures)

How to Lock Cells in Excel (with Pictures)

Lock cells in an Excel spreadsheet (worksheet) to prevent any changes to the data or formulas in a cell. A locked and protected cell can be unlocked at any time by the user who originally locked it. Follow the steps below to learn how to lock and protect cells in 2010 versions of Microsoft Excel, 2007, and 2003.

How to Draw Animal Cells: 11 Steps (with Pictures)

How to Draw Animal Cells: 11 Steps (with Pictures)

Cells are one of the most basic building blocks of life. All organisms must have cells, both unicellular and multicellular. Animal cells differ from plant cells in several ways, including the absence of vacuoles, chloroplasts, and cell walls.

How to Remove Dead Skin Cells with Sugar (with Pictures)

How to Remove Dead Skin Cells with Sugar (with Pictures)

Sugar granules can exfoliate dead skin cells with just a gentle motion. Sugar also contains glycolic acid which can keep the skin smooth and prevent flaky skin. While sugar isn't a miracle cure for all skin problems, it's hard to beat the benefits of sugar in terms of price and safety for the skin.