This excel command enters a new line within a cell. To separate words in excel within a cell, we use Alt+Enter Command. It does not split the cell but draws a diagonal line in the cell. Go to the border tab and select the diagonal border line.Right click on A1 and choose format cells or you can use CTRL+1 excel shortcut to format cell.Now to split a cell in half in excel 2016 we will use an excel trick. You want Excel to split cell into two, to show “Age Range” for Column Headings and “Area” for Row Headings.įirst let’s split the Cell A1 into two. In cell A1 you have written “Age Range Area”. Let’s say you have conducted a survey in different areas to know the population of several age groups. The fact is, you can’t split a cell diagonally into two in excel but you can make it look like it is split as shown in above image.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |