Font height for Normal, Subscript and Superscript text

test123 1

Hi, I'm trying to determine how the height of a font is determined for Normal text, Subscript and Superscript text.
Specifically for Excel.
What I'm trying to achieve is to set the same row height in Excel for all the above cases (see image attached).

I'm using a professional font editor and the parameters available include: Typo, Ascender, Typo Descender, Typo Line Gap, Win Ascent Win Descent, Subscript y offset, Superscript y offset.

Have spent a long time changing setting but with no luck (in trying to get the row height to be the same).

I presume there are typography standards and this may assist in understanding how the row height in Excel is determined. By a formula or otherwise.

Please help as I have spent a long time trying to figure this out.

It may help if the question is directed to someone involved with the nuts and bolts design of Excel.

Edit: This is a similar query for reference.
https://learn.microsoft.com/en-us/answers/questions/257675/excel-row-height-logic-calculation.html

Viorel 112.5K

What I'm trying to achieve is to set the same row height in Excel for all the above cases

Maybe you can do something like this:

Range("A1:A4").EntireRow.AutoFit  
  
Dim h As Double  
h = 0  
Dim r As Range  
For Each r In Range("A1:A4").Rows  
    If h < r.RowHeight Then h = r.RowHeight  
Next  
  
For Each r In Range("A1:A4").Rows  
    r.RowHeight = h  
Next

Ceasar Chen_MSFT 4,391 Reputation points

2022-09-27T01:39:06.673+00:00

Hi, @test123
You can refer to the answer of Viorel-1.
test123 1 Reputation point

2022-09-27T12:58:45.977+00:00

Hi, thanks but this has nothing to do with setting row heights, manually or with Visual Basic.
It is a typography question and I need to know how Excel sets the row height, when it gets information from a font file.
test123 1 Reputation point

2022-09-28T00:28:58.237+00:00

Hi, this is a similar query for reference:

excel-row-height-logic-calculation.html
Ceasar Chen_MSFT 4,391 Reputation points

2022-10-03T09:35:52.077+00:00

Is your problem solved?