+ Reply to Thread
Results 1 to 2 of 2

How do I align selected text?

  1. #1
    Registered User
    Join Date
    03-22-2017
    Location
    London, England
    MS-Off Ver
    2007
    Posts
    1

    How do I align selected text?

    I need to input, in the same cell, 2 lines: the first- left justified, while the second has to be centered. I've tried to select only the 2nd line and justify it but the Alignment options are inactive while text is selected. Is there any way at all to do that?

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,410

    Re: How do I align selected text?

    Welcome to the forum!

    Not natively, no. Whether or not there is a way to do it with VBA, I don't know, but the easiest way to achieve your goal is to split the cell contents over two rows or settle for one type of justification for all of it.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

+ 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. VBA excel to word insert footer (Text - Left align) & (Page number - Right align)
    By Richavlaues in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-23-2017, 06:22 PM
  2. [SOLVED] How do I align text left the horizontal axis labels and wrap text them?
    By rs1aj in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 02-11-2015, 03:52 AM
  3. Align msgbox text and Bold & underline certain text
    By alexnkc in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-22-2013, 11:01 PM
  4. I need your help to align text in textbox and to control the text box line color
    By Osama Zedan in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-05-2012, 08:04 AM
  5. Align text in cell acording to the text it contains
    By AlecsV in forum Excel General
    Replies: 1
    Last Post: 08-25-2012, 11:50 AM
  6. move and align rows based on user selected key columns in two workbooks
    By reteptnarg in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-14-2010, 01:08 AM
  7. Need to align text around a symbol???
    By guillemot in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-18-2006, 12:43 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