How to set the minimum value of excel row height, and set it automatically if there are too many rows to be displayed?

Method 1: set the line height directly, align the thread head-right click-line height-enter the number.

Method 2: Use automatic adjustment to select columns. If there is a lot of data, directly click the Select All button (intersection of rows and columns)-Format-Automatically adjust row height.