Alignment Issues In Excel

  1. AUTiger1's Avatar
    Posts : 62
    Windows 10
       #1

    Alignment Issues In Excel


    Alright folks, I don't know why this is happening but here's the problem. If I insert a new row in Excel is takes the format of the other cells in that row just like I want it to, except when I go to type in it. I type in the new row of cells and the formatting is off until I hit enter to finish typing, then it goes back to it's proper formatting.

    For example, if I have a cell with a center alignment, if I type in that cell it doesn't show a center alignment, it shows no alignment at all until I finish typing and hit enter and then it goes back to a center alignment. I don't know why it's doing this on this file when it hasn't previously done it. I added a couple of screenshots to show what I'm talking about because it's hard to explain.Alignment Issues In Excel-screenshot-127-.pngAlignment Issues In Excel-screenshot-128-.png
      My Computer

  2. SoFine409's Avatar
    Posts : 1,406
    Win10 Pro
       #2

    Hi AUTiger1. I think that’s probably what it’s supposed to do. It’s aligned left to give you the maximum amount of space to let you see what you’re typing during imput and then when you hit return it picks up the formatting.
      My Computers

  3. AUTiger1's Avatar
    Posts : 62
    Windows 10
    Thread Starter
       #3

    SoFine409 said:
    Hi AUTiger1. I think thatís probably what itís supposed to do. Itís aligned left to give you the maximum amount of space to let you see what youíre typing during imput and then when you hit return it picks up the formatting.
    No. It doesn't always do that though. That's why it's so annoying when it does. If I have something in a center alignment and type in it then it stays in a center alignment. It's annoying when it doesn't because well, my OCD. LOL!

    EDIT: See here, how my new typing is in a center alignment? That is what I want all the time, but it doesn't always do that and I don't know why.

    Alignment Issues In Excel-screenshot-129-.png
      My Computer

  4. AUTiger1's Avatar
    Posts : 62
    Windows 10
    Thread Starter
       #4

    Another update, it just recently started doing this. It doesn't do it all the time. Sometimes within the same workbook on the same page on the same row it will do it on like cell C but not A. It legit is not making a lick of sense to me why it is so random and why it just popped up out of nowhere.
      My Computer


  5. Posts : 2,098
    Windows 10
       #5

    The indicator is not selected in the 2nd and 3rd sheet so it would be whatever the default is, looks to be different.

    In your first or second or third image we can't tell what you have done, whether the formatting is the same as the previous/next row/none, or the particular cell you have indicated either, or what the default sheet formatting is, whether you copied a line/cell format and so on.

    Also we don't know what the cell formatting was when typing something in.

    In the 2nd image you maybe typing that in left justified due to the default.
    and in the 3rd the cell happened to be centre justified when typing in with a differing default.
      My Computer

  6. AUTiger1's Avatar
    Posts : 62
    Windows 10
    Thread Starter
       #6

    Helmut said:
    The indicator is not selected in the 2nd and 3rd sheet so it would be whatever the default is, looks to be different. In your first or second or third image we can't tell what you have done, whether the formatting is the same as the previous/next row/none, or the particular cell you have indicated either, or what the default sheet formatting is, whether you copied a line/cell format and so on.
    Also we don't know what the cell formatting was when typing something in.
    In the 2nd image you maybe typing that in left justified due to the default.
    and in the 3rd the cell happened to be centre justified when typing in with a differing default.
    It's all centered. I highlighted the rows and centered them when I created the workbook way back when. But then every now and then when I type in insert a new row (which is supposed to assume the current formatting) the cell it doesn't assume the center alignment until I'm done typing and hit enter. Its not a major issue, just trying to figure out why it happens.
      My Computer



 

  Related Discussions
Our Sites
Site Links
About Us
Windows 10 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 10" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd
All times are GMT -5. The time now is 14:20.
Find Us




Windows 10 Forums