Is there any way to modify the spacing within cells in Excel (2010)? I have never found any settings to affect this within the normal Excel controls. However, I am wondering if it can be done through some kind of programming such as VBA.
Specifically, I am referring to the spacing settings which are managed by the Paragraph box in MS Word.
The settings there are grouped into three sections:
• General alignment -- this section is a non-issue because Excel's alignment settings include all the options found in Word and even more
• Indentation -- although Excel does have indentation settings which affect the left margin of text, I have never found anything to alter the right margin or create first-line indentation or hanging.
• Spacing -- as far as I know, there are no options to change the inter-line settings in Excel. Changing the font type and/or size affects the inter-line spacing slightly but customizing the spacing is not possible.
I have very little understanding of VBA but does it have the capability to affect the formatting of text within cells in the ways mentioned above? As stated initially, I am mostly interested in being able to make changes in the third category: inter-line spacing.