I'm working with applying formats to an income statement report depending on the line. That way I can make summaries bolded and in a larger font. When I set the Rows height to Optimal, it gives me the format shown below that doesn't increase the height of the larger font rows.
If I check Allow Growth in the row height settings, it looks like all rows become the same height as shown below, rather than based on the font size. Can someone explain what Optimal row height is actually doing? What are my options here? Create a formula that sets the row height based on the font size?
Thanks!
