How to split 1 cell into 2 cells in Excel - Split cells in Excel
Depending on different purposes, you want to split a cell into two cells to enter two different data in one cell and still be able to calculate normally as other cells.
How to split 1 cell into 2 cells in Excel - Split cells in Excel Picture 1
The following article guides you through the steps to split a cell into two in Excel.
Step 1: Right-click the cell in question and select Format Cells .
How to split 1 cell into 2 cells in Excel - Split cells in Excel Picture 2
Step 2: The Format Cells dialog box appears , select the Border tab and select the diagonal from the top down or from the bottom to match your requirements as shown below. Then click OK .
How to split 1 cell into 2 cells in Excel - Split cells in Excel Picture 3
Step 3: Now the cells you split have split into two cells divided by diagonal lines.
How to split 1 cell into 2 cells in Excel - Split cells in Excel Picture 4
You only need to enter data for the upper half cell and press Alt + Enter to enter data for the lower half.
You use the Space key (spacebar) to adjust the data accordingly into small cells.
How to split 1 cell into 2 cells in Excel - Split cells in Excel Picture 5
So with a simple trick, you can split a cell into two in Excel suitable for the purpose of use. Good luck!
You should read it
- How to split cells, combine cells in Excel
- Instructions on how to create diagonal lines in Excel box
- Instructions on how to split cells in Excel 2003 and 2007
- How to merge and split cells in Word
- Complete tutorial of Excel 2016 (Part 5): Basics of cells and ranges
- Merge cells in Excel
- How to split cells, combine cells (cells) in Word table
- How to name, comment and protect cells in Excel
- Instructions on how to split and merge cells in Word
- Format Excel 2007 spreadsheet
- How to indent the line in Excel
- How to color formula cells in Excel automatically
May be interested
Attach document to word file - Attach file in word
Presentation of beautiful Word documents - Presentation beautifully in Word
Delete a Table in Word - Delete a Table in Word
How to use comments, notes (comments) in Word
How to cancel the print job immediately
Synthesis and function of functions in mathematical and trigonometric functions