ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Consider space in centering (https://www.excelbanter.com/excel-discussion-misc-queries/258660-consider-space-centering.html)

Eric_NY

Consider space in centering
 
In centered text, I'd like Excel to consider extra spaces on the left or
right. In text consisting of multiple lines, this would allow one line to be
forced off-center.

But Excel seems to ignore spaces in centering text. Is there any other way
to do this - possibly a character that Excel would consider in centering
text, but which is invisible on display. (Word can do this using a
non-breaking space.)

Any suggestions? Thanks.

Pete_UK

Consider space in centering
 
You can enter a non-breaking space character by holding down the Alt
key and typing 0160 on the numeric keypad.

Hope this helps.

Pete

On Mar 11, 5:26*pm, Eric_NY wrote:
In centered text, I'd like Excel to consider extra spaces on the left or
right. In text consisting of multiple lines, this would allow one line to be
forced off-center.

But Excel seems to ignore spaces in centering text. Is there any other way
to do this - possibly a character that Excel would consider in centering
text, but which is invisible on display. (Word can do this using a
non-breaking space.)

Any suggestions? Thanks.




All times are GMT +1. The time now is 11:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com