Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   Multi line cells in excel (https://www.askmehelpdesk.com/showthread.php?t=51685)

  • Jan 2, 2007, 02:19 AM
    Capuchin
    Multi line cells in excel
    Hey guys, any idea how to have multiple lines in a single cell in excel?

    I'm trying to make my table look a little neater, but it makes some of my comments overlap into following cells - is there any way to make the rows higher and to have 2 lines of text in a cell?

    Thanks in advance - Cap
  • Jan 2, 2007, 02:24 AM
    Curlyben
    Erm how about a simple WRAP TEXT ;)
  • Jan 2, 2007, 02:25 AM
    Capuchin
    Where's that button?

    Edit - Found it. Rep++
  • Jan 2, 2007, 02:27 AM
    Curlyben
    RIGHT click the cell > Format Cells > Aligment Tab > Text Control near the bottom
  • Jan 2, 2007, 08:22 AM
    ScottGem
    You can FORCE a linebreak using Alt+enter

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