+ Reply to Thread
Results 1 to 4 of 4

Cell Text Alignment

  1. #1
    Forum Contributor
    Join Date
    07-16-2015
    Location
    Aberdeen, Scotland
    MS-Off Ver
    Excel 2010
    Posts
    121

    Cell Text Alignment

    Hi

    Is there a way to type two words in a cell and force second word below first word, I know all about alignments and wrapping, I can force two words to go above and below each other by creating gap between them and centre align, just wondered if there was an alternative quick way without getting too technical.

    Thanks

    George

  2. #2
    Valued Forum Contributor
    Join Date
    01-08-2011
    Location
    Portsmouth, England
    MS-Off Ver
    Excel 2007 to 2016
    Posts
    456

    Re: Cell Text Alignment

    Type your first word, then Alt-Enter and type your second word
    Excel is a constant learning process and it's great to help each other. If any of us have helped you today, a click on the "reputation" star on the left is appreciated.

  3. #3
    Forum Contributor
    Join Date
    07-16-2015
    Location
    Aberdeen, Scotland
    MS-Off Ver
    Excel 2010
    Posts
    121

    Re: Cell Text Alignment

    AHH

    Great, I thought there was a way

    Thank you for the quick response.

    George

  4. #4
    Valued Forum Contributor
    Join Date
    01-08-2011
    Location
    Portsmouth, England
    MS-Off Ver
    Excel 2007 to 2016
    Posts
    456

    Re: Cell Text Alignment

    My pleasure and thanks for the rep

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 2
    Last Post: 05-24-2013, 10:52 AM
  2. Replies: 1
    Last Post: 02-02-2012, 11:32 AM
  3. Change alignment based on if cell is text or number.
    By Owompa in forum Excel General
    Replies: 4
    Last Post: 07-21-2011, 03:54 PM
  4. cell text alignment vertical - using VBA
    By Dabooj in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-31-2008, 06:05 AM
  5. cell text alignment
    By racudd in forum Excel General
    Replies: 4
    Last Post: 09-29-2006, 10:49 AM
  6. Text alignment in a cell from VBA
    By brucemc in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-06-2006, 02:30 PM
  7. [SOLVED] How do I set text alignment in code.
    By Patch61 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-17-2006, 02:40 PM
  8. Text and Grid Alignment
    By ckrmpls in forum Excel General
    Replies: 0
    Last Post: 08-16-2005, 05:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1