Instructions on how to split cells in Excel 2003 and 2007

Sometimes we have an Excel file available and some cells are combined. So how to separate each cell? Let's read the following article for readers to grasp it!

Before performing the separation:

Instructions on how to split cells in Excel 2003 and 2007 Picture 1

After performing the separation:

Instructions on how to split cells in Excel 2003 and 2007 Picture 2

I. How to split cells in Excel 2003

Step 1: Select a cell to split by left clicking on that cell

Instructions on how to split cells in Excel 2003 and 2007 Picture 3

Note: Cells that have previously merged with multiple cells are split.

Step 2: Right-click the currently selected cell »Select Format Cells

Step 3: In Format Cells window, select Alignment tab »Uncheck Merge Cells (item 1)» Click OK to complete the process of splitting cells in Excel.

Instructions on how to split cells in Excel 2003 and 2007 Picture 4

Step 4: And here is the result after successfully splitting the cell:

Instructions on how to split cells in Excel 2003 and 2007 Picture 5

As you can see, cell STT from 1 cell has been split into 2 cells after performing Steps 1 to 3 above.

II. How to split cells in Excel 2007

Step 1: Select a cell to split by left clicking on that cell

Instructions on how to split cells in Excel 2003 and 2007 Picture 6

Note: Cells that have previously merged with multiple cells are split.

Step 2: Click the Merge & Center button:

Instructions on how to split cells in Excel 2003 and 2007 Picture 7

Then, you will also get the results as shown below:

Instructions on how to split cells in Excel 2003 and 2007 Picture 8