Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   How to wrap text excel 2007? (https://www.askmehelpdesk.com/showthread.php?t=560842)

  • Mar 9, 2011, 08:43 AM
    Asharenjith
    How to wrap text excel 2007?
    How to wrap text excel 2007? Data is in multiple raws , I just need to make it in one raw
  • Mar 26, 2011, 03:30 AM
    BrookW97
    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.

  • All times are GMT -7. The time now is 12:35 AM.