Increase Cell Margins - sometimes the text tab isn't in format options

[crobaseball]

Hi, I'm looking to increase the size of the margins in my cell, particularly the vertical. i.e. - I want there to be more white space between the rows. When I select Format cells, sometimes the text tab is there to be able to change those margins, but many, many times, it's not. Is there something with the formatting which changes whether the text tab will come up? Or is there another setting which turns this on?

 

[crobaseball]

Hi, I'm looking to increase the size of the margins in my cell, particularly the vertical. i.e. - I want there to be more white space between the rows. When I select Format cells, sometimes the text tab is there to be able to change those margins, but many, many times, it's not. Is there something with the formatting which changes whether the text tab will come up? Or is there another setting which turns this on?

Should have thought of this earlier: You can do it with a macro.

Sub AutoFitAndAddSevenPoints()
  Dim R As Range
  Selection.EntireRow.AutoFit
  For Each R In Selection.EntireRow.Rows
    R.RowHeight = R.RowHeight + 7
  Next
End Sub