Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   Display text vertically and not horizontally in 1 cell (Excel) (https://www.askmehelpdesk.com/showthread.php?t=7760)

  • Feb 12, 2005, 04:03 PM
    iKwak
    Display text vertically and not horizontally in 1 cell (Excel)
    How would you display a line of text to show vertically after each text in one cell? For example:


    Total
    Activity
    Cost


    And not Total Activity Cost (in one cell)?
    Thank you in advance.
  • Feb 13, 2005, 01:16 PM
    walt17
    Format cells in Excel
    Type the desired text. Press Enter key. Then select the cell and right click.
    Select: "format cells". A box will come up giving you a lot of formatting options. Select: "alignment", then "wrap text".
    Experiment with the format cells feature. You can do a lot there. If you select a group of cells the same formatting will be applied to all of them.
  • Feb 14, 2005, 05:55 PM
    iKwak
    Thanks.
    I also found out that you can press Alt+Enter to wrap the text. :cool:

  • All times are GMT -7. The time now is 07:35 PM.