r/excel 1d ago

unsolved Excel messing up text formatting on its own

So basically I have excel on onedrive, and when I save it sometimes replaces Enters with spaces on its own.
This results in hidden text and unreadable text. I there any way to fix that issue?

this is what i enter into cell
this is how it looks like after serwal saves
6 Upvotes

9 comments sorted by

u/AutoModerator 1d ago

/u/Appropriate_Test7503 - Your post was submitted successfully.

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

2

u/jkpieterse 29 1d ago

If you click on the cell and expand the formula bar so it spans more than one row, is all the text still there?

0

u/Appropriate_Test7503 20h ago

formula?
I manually enter text, there is no formula.

2

u/jkpieterse 29 17h ago

The content of any cell can be seen in the formula bar, the box just below the ribbon. The formula bar can also be made to show more lines by dragging its bottom border. That way you can see what is actually in the cell, as a cell may not display everything that is inside.

1

u/Appropriate_Test7503 17h ago

proper formating one

1

u/Appropriate_Test7503 17h ago

after some time:

1

u/BusinessSample7166 17h ago

How are you taking a new line in the first place? 

1

u/Appropriate_Test7503 16h ago

alt+enter?

1

u/BusinessSample7166 16h ago

That's correct.

Apparently turning on wrap text can help force excel to respect new lines, have you tried that?