How to Split Cells in Excel: 5 Steps

Table of contents:

How to Split Cells in Excel: 5 Steps
How to Split Cells in Excel: 5 Steps
Anonim

This article explains how to split two or more Microsoft Excel cells that have previously been merged.

Steps

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

Step 1. Open the Excel document to edit

Double-click the icon of the Excel file you want to open.

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

Step 2. Select the area of the Excel sheet made up of joining two or more cells

Find the cell you need to split, then click it with the mouse to select it.

  • The merge area occupies an area of the sheet equal to two or more columns, based on the number of cells that have previously been merged. For example when joining two cells belonging to columns TO And B. of the sheet you will get a single cell that will occupy both the column TO is the column B..
  • Remember, it is not possible to split a cell that has not yet been merged with one or more cells on the sheet.
Unmerge Cells in Excel Step 3
Unmerge Cells in Excel Step 3

Step 3. Click the Home tab

It is one of the tabs that characterize the Excel ribbon located at the top of the page. A toolbar will appear.

Skip this step if the card Home is already visible.

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

Step 4. Open the drop-down menu of the "Merge and align to center" function

Click the down arrow icon

Android7dropdown
Android7dropdown

located on the right of the button Merge and center align located within the "Alignment" group of the Excel ribbon. A small drop-down menu will appear.

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

Step 5. Click on Split Cells

It is one of the items listed in the menu that appeared. The selected cells will be split and the value they contain will be displayed left aligned.

Recommended: