Forum Discussion

JMorris94's avatar
JMorris94
Copper Contributor
Aug 23, 2021

Text Alignment Issue

So I've used Excel for years to make charts for games I do with friends, but Saturday night I noticed an issue for the first time that I've never had through the many versions/iterations of excel over the years

 

When I started out (and essentially teaching myself excel) when I wanted to push a new line of text down a row in the same cell, I just used the space bar until the portion of text I wanted to push down, was pushed down.  The thing is, when I did this, excel didn't consider the spaces as their own characters and would still center both lines of text (top and bottom)

 

On Saturday night though, for the first time ever, I noticed this happened to one of my sheets (and proceeded to see the same problem not only in all other sheets for that file, but in another file/workbook entirely as well) You can see how the team name is pushed to the left by the spacing, and then the number of votes below it is pushed right, when before both were centered just fine. As stated, before through many years and versions of excel, this method of mine never had issue or created this problem.

 

 

Anyone have any idea on why this is happening and also any fix?  The only abnormal thing I can think of was that, that same night I copy-pasted some google doc data into the excel files on a separate sheet that had emojis, but I don't think that would affect other sheets or cause this? 

 

I know there's a way to just basically force the text onto a new line in the cell without the spacing, but seeing as I've done countless sheets with my lazy-space method for years, I wouldn't have the time or desire to go in and fix all of them.

 

Additional Info: I use excel on a Mac (but haven't had this issue before on a Windows or Mac) and my current version of Excel is 16.43

2 Replies

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor

    JMorris94 Can't tell why this happened to you last Saturday, but the fix would be to us line feeds (Alt-Enter) when you want the text to go to the next line within a cell, rather than using spaces.

     

    Make sure that the cells where you use line feeds are formatted to wrap text and centered to achieve what you describe.

    • JMorris94's avatar
      JMorris94
      Copper Contributor

      Riny_van_Eekelen yeah I'll definitely be doing that moving forward since I have no choice lol, and yeah, I always made sure to wrap text and center align

       

      I just hope there's some sort of fix or correction for my old method since there's no way I'd be able to edit the years worth of files and sheets (but I guess shame on me lol for never growing up and learning the correct method and using my lazy space method haha)

Resources