Center Wrapped Text Without Left Offset that Occurs Now
When you Wrap Text in a cell in excel and center, the text is distinctly further to the left whether or not there is any wrapping occurring, not centered as it would be if you manually spit the text into two cells and used the built-in centering.
Make wrapped text center without the offset.
This is already supported.
After you wrap text in a cell, click on the “Align Center” button, and the text will align in the middle of the cell
3 commentsComments are closed
where is the " align center" button? this feature its ruining all of my documents because they've been design to be filled in manually.
This is very annoying. I found a temporary solution.
If you change horizontal text alignment to 'centre across selection' from the format cell window it seems to centre the text correctly.
Hello, not exactly.
If you look carefully, all the wrapped cells are not accurately centered. Their text looks moved towards left a little bit, which is disturbing if you're looking for visual simmetry.