Row Height

[madayaang]

Greetings to all Excel Forum users,

Why do row heights unit change (normal view 15.00 vs page layout view .21)?

Is there a way to adjust the row height automatically?

In the attached file, please adjust
all rows in Sheet1 that has numbers in column A.

Desired Row height values are in sheet "Ref".

example : Sheet1
Row6 ColumnA 40 = Rowheight will be .18
Row10 ColumnA 120 = Rowheight will be .59
Row71 ColumnA 1200 = Rowheight will be 5.45

Many thanks in advance. MadayaAng

[madayaang]

Attaching the below: Thanks.

[Thom7890]

They probably want you to use a data filter to expose all the 40s at once and change the heights that way - quick and easy. Then expose all the 120s etc.

[madayaang]

Thanks Thom7890, that is actually what im doing. Just wonder if there is a way somehow, because my number of rows per value could range between 100-500. Cheers.