Let’s say you have conducted a survey in different areas to know the population of several age groups. In cell A1 you have written “Age Range Area”. You want Excel to split cell into two, to show “Age Range” for Column Headings and “Area” for Row Headings.
First let’s split the Cell A1 into two. Now to split a cell in half in excel 2016 we will use an excel trick. Follow the steps below:
Go to the formula bar and place your cursor between “Age Range” and “Area”.
Hit Alt+Enter, Repeat this until you are satisfied with the result.
Now it looks good. This is a makeshift in excel to split a cell in half diagonally. You can’t actually work on both parts but visually it looks split.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.