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
You should read it
- How to split cells, combine cells in Excel
- How to split 1 cell into 2 cells in Excel - Split cells in Excel
- Merge cells in Excel
- Instructions on how to create diagonal lines in Excel box
- How to color formula cells in Excel automatically
- Complete tutorial of Excel 2016 (Part 5): Basics of cells and ranges
- How to calculate and color blank cells in Excel
- How to split cells, combine cells (cells) in Word table
- How to Lock Cells in Excel
- How to merge and split cells in Word
- How to merge cells in Excel - Instructions to merge cells in Excel 2010, 2013, 2016
- Instructions on how to split and merge cells in Word
May be interested
14 Excel tips to help you work faster
How to fix date format errors in Excel
Restore Word and Excel files that unfortunately have not been saved
The leading zero format in Excel number ranges is easy
How to convert data from columns to rows in excel is extremely simple
How to hide and show the rows and columns in Excel is extremely simple.