Hello everyone,
I want to insert two rows in one cell in microsoft exel.
I have to handover my assignment. Before that I want to insert my data in to excel sheet.
I tried it as following image. I merged 6 cells and I insert one row and when I press 'Enter' key it goes to another cell.
Therefore anyone knows please give me a solution.
Creating a cell with 2 rows means merging 2 rows in 1 column. First, select 2 rows by pressing SHIFT+Down.
Click the Merge & Center button to merge the cells and setting the text alignment to Center.
If you do not want to center the text inside the cell, click on the down arrow beside it to display the dropdown list and then choose Merge Cells.
This will only merge the cells but does not set any text alignment.
The procedure is just the same when merging 4 rows and 2 columns like the one in your image. Like in the image below using the words “test and test”, put the words inside any cell within the highlighted 4-rows and 2-columns.
Click the Merge & Center button above.
To set the texts’ cell alignment, click the Top Align, Middle Align, or Bottom Align button above.
While typing in the specific merged row not press "Enter" only you need to press "Alt+Enter" then u r able to enter data in the same merged space
