Is there a way to set row heights in a sheet back to standard?

tbreychak

I am trying to create a report to add to a dashboard. The sheet I am pulling from previously had several rows expanded due to large comments and the wrap text feature. To pull into my report, and for view of leadership, I would like the rows to be standard for a cleaner feature. Any ideas?

Shanky Paul

Did you tried disabling the wrap text feature? Go to the original sheet, select the full column that has large comments and disable the "Wrap Text" feature by clicking on it. This will ensure that the text remains in a single line, and rows will not expand automatically.

tbreychak

@Shanky Paul I have and the rows did not revert to their original size. What I did instead was zip up the rows in groups in my report. I lose the aggregate data for presentation but show the highlights instead.

Thanks!