Ask Experts Questions for FREE Help!
 

Free Answers in 3 Easy Steps

Register Now
3 Steps
 


Ask QuestionsprogressAnswer QuestionsprogressBuild ReputationprogressBecome an Expert
 
At Ask Me Help Desk you can ask questions in any topic and have them answered for free by our experts. To ask questions or participate in answering them you must register for a free account. By registering you will be able to:
  • Get free answers from experts in any of our 300+ topics.
  • Accept money for answers that you provide.
  • Communicate privately with other members (PM).
  • See fewer ads.
  View Answers    Answer this question    Ask a question  
 

Asharenjith
Mar 9, 2011, 07: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.