Share via

Excel: Cell does automatic text formatting and opens in the middle of text in new Excel version

Anonymous
2023-02-06T11:42:31+00:00

Hello,

I have this very annoying problem, that happens since a change of system. We had Excel professional before and now we only have Office 365.
We have always used an open point list with a macro that automatically added formatting and a new date in blue. So it looked like in Screenshot 1 after formatting.

Now, when I open the cell the format completely changes automatically. Not only that, but it adds multiple blank rows. Leading to Screenshot number 2.

https://learn-attachment.microsoft.com/api/attachments/0a728590-4620-441f-a9fd-dbe4f83a0be1?platform=QnA"https://learn-attachment.microsoft.com/api/attachments/a8cc9bce-ae97-4bcd-a6d0-82718a9d7079?platform=QnA" rel="ugc nofollow">

Does someone have an idea why this is happening and if can somehow fix it?

Best regards,
Volker

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-02-07T06:20:01+00:00

    Hi VolkerGust,

    Greetings! Thank you for posting to Microsoft Community.

    It could be line feed in your text which will add multiple rows. You should manually delete them.

    For the position issue you can change them from Home>Alignment to adjust them. It would be helpful to check on it if you can share us a file.

    Feel free to share any update.

    Best Regards,

    Snow Lu

    Was this answer helpful?

    0 comments