+ Reply to Thread
Results 1 to 9 of 9

Why wouldn't I be to Center Align?

  1. 05-22-2018, 05:02 PM #1
    LAPIII
    LAPIII is offline
    Registered User
    Join Date
    05-22-2018
    Location
    Virginia
    MS-Off Ver
    2016
    Posts
    6

    Why wouldn't I be to Center Align?

    I attached the Excel worfbook with the content that I can't Center Align.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 05-22-2018, 05:05 PM #2
    teylyn
    teylyn is offline
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Why wouldn't I be to Center Align?

    Hello,

    can you explain your problem in a bit more detail? I can center text in your workbook just fine. Select the cells and click the Center icon in the Home Ribbon.
    center.jpg
    Microsoft MVP
    http://www.teylyn.com
    Twitter: http://twitter.com/IngeborgNZ
    Reply With QuoteRegister To Reply
  3. 05-22-2018, 05:07 PM #3
    sandy666
    sandy666 is offline
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Cool Re: Why wouldn't I be to Center Align?

    Why not?
    Or I misunderstood something
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 05-22-2018, 05:57 PM #4
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,969

    Re: Why wouldn't I be to Center Align?

    I also had no problems centering your data?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
  5. 05-23-2018, 09:08 AM #5
    LAPIII
    LAPIII is offline
    Registered User
    Join Date
    05-22-2018
    Location
    Virginia
    MS-Off Ver
    2016
    Posts
    6

    Re: Why wouldn't I be to Center Align?

    I have no idea why I count center text, in Excel 2016.

    Excel.PNG
    Reply With QuoteRegister To Reply
  6. 05-23-2018, 09:12 AM #6
    CK76
    CK76 is offline
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    MS365 Apps for enterprise
    Posts
    5,938

    Re: Why wouldn't I be to Center Align?

    You are center aligning vertically. But not horizontally.

    0.JPG
    ?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
    ― Robert A. Heinlein
    Reply With QuoteRegister To Reply
  7. 05-23-2018, 09:12 AM #7
    sandy666
    sandy666 is offline
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Why wouldn't I be to Center Align?

    see picture in post#2
    Reply With QuoteRegister To Reply
  8. 05-23-2018, 09:17 AM #8
    LAPIII
    LAPIII is offline
    Registered User
    Join Date
    05-22-2018
    Location
    Virginia
    MS-Off Ver
    2016
    Posts
    6

    Re: Why wouldn't I be to Center Align?

    Now I see. I was middle aligning and I needed to Center Align. Thanks all!
    Reply With QuoteRegister To Reply
  9. 05-23-2018, 09:18 AM #9
    sandy666
    sandy666 is offline
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Why wouldn't I be to Center Align?

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Center Align text across different rows (alternative to merging)
    By Eliamme in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 08-11-2017, 07:03 AM
  2. [SOLVED] Help request to align the picture center in web layout
    By mso3 in forum Word Formatting & General
    Replies: 4
    Last Post: 10-15-2015, 09:59 AM
  3. [SOLVED] Align a date in center
    By mukeshbaviskar in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-28-2013, 07:18 AM
  4. Find last row with data and autofit, bold and center align
    By daillest319 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-24-2012, 11:32 AM
  5. Center Align Image
    By shapper in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-20-2008, 04:52 AM
  6. Align to the left or to the right (or center)
    By kaokao1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-05-2006, 11:09 PM
  7. Center Align
    By John 3:16 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-15-2005, 05:10 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1