How to make the height of excel tables consistent
1. The operation steps are as follows: 1. First open Excel, and you can see that the row heights are uneven; 2. Then click to select all the table areas where the row height needs to be modified; 3. Then in the format, click the row height option; 4. Click the row height to pop up the dialog box as shown in the figure; 5. Next, change the row height value to 20 (according to your own needs), and click OK; 6. Finally, you can read and see that the row height of the table has been modified to a uniform row height of 20.
2. Extended data: set the width of multiple rows and columns to the same value in Excel: click the format - column - column width on the single column of the menu type; The column width dialog box pops up. We record the value of this column width, for example, 20. Click Remove; Then we need to set the default width of the table. Click Format - Column - Standard Column Width on the menu bar; Note that the standard column width is clicked here, not the column width above.
3. The standard column width dialog box pops up. We set the value to 20, and then click OK to set the default width of the table.