article MS excel text function excel group rows Excel group rows function to convert all the cells in the selected cell to a new row in the column title.
To do so, double click on the cell and select the “Create New Row” option from the dropdown menu.
Then type a new column name and a new name for the cell, e.g. cell 1.
You will now see the column name, name and number of the column that will be created.
To delete the column, double-click on the column and select “Delete Column” from the “Columns” dropdown.
If you do not have the column already, click the “Delete” button on the right hand side of the “Edit” button to create a new one.
For more details, see the Microsoft Excel FAQs page.
For further help, see our complete Excel tutorial.