How to decrease the text line spacing ?

[kareem2]

Hello,
I have a text box that I filled with a few lines and shapes (yes shapes inside a shape)
I searched in excel for "line spacing"
and even googled it
but it's like only Word has the option to modify interline spacing

any help please ? does it need a vba ??
thank you very much !

 

[rlv01]

For the standard Excel textbox, I do not think there any property to allow adjusting line spacing. You can of course do it crudely by inserting blank lines; but my impression is you are looking for more control than that.

 

[Peter_SSs]

Try this

• Select the text within the TextBox
• Right click the selected text & choose Paragraph ..
• Experiment with the 'Spacing' options on the 'Indents and Spacing' tab

For example, with this text box

and following the above steps I chose 'Line Spacing' - Exactly - 8 pt (it was 13.2 originally)
This is the result. Is that the sort of thing you are after?