PDA

View Full Version : How to wrap text excel 2007?


Asharenjith
Mar 9, 2011, 08:43 AM
How to wrap text excel 2007? Data is in multiple raws , I just need to make it in one raw

BrookW97
Mar 26, 2011, 03:30 AM
Your data is either all in one cell or in multiple cells & rows. See answers for either option.

If its all in one cell just appears to be in multiple rows-its easy:
To wrap text, right click, choose the Alignment tab and check the box wrap text.

However, if data is in multiple rows & more than one cell, try this (maybe first save a copy of original in case a step messes up). Copy all of the cells you want to combine. Next, in a new cell (and before you do this, make sure you have free columns to the right of the new cell-as many as you have rows)... right click and choose "paste special". On the box that comes up, check the box "transpose" on bottom right then click "OK".
Now your text should all be in one row.