Slider

How to Batch Set the Row Height and Column Width Precisely in Excel

Date:2019-7-9 Author:Cordelia

It's common to adjust the row height and column width in Excel while editing a table, especially when the content is too much to fit in the cell's size.

The most direct way for this situation is moving your mouse to drag the rows or columns, which you should've used for many times before. But if you want to change the settings for the whole table, this method doesn't seem to work.

Taking this table as an example. The size of cells is obviously not suitable for the content. Let's see how to adjust it.

How to Batch Set the Row Height and Column Width Precisely in Excel

1. Row Height

Dragging your mouse to select all the row headers in the left. Make sure they all turn into green.

How to Batch Set the Row Height and Column Width Precisely in Excel

Right click the selected area and choose Row Height in the list.

How to Batch Set the Row Height and Column Width Precisely in Excel

Input the precise number of row height in the window popping out.

How to Batch Set the Row Height and Column Width Precisely in Excel

Now the row height of the whole table has been set to 15.

How to Batch Set the Row Height and Column Width Precisely in Excel

Column Width

Similarly, choose all the columns you want to adjust by selecting the column headers above, and make sure they all turn into green.

How to Batch Set the Row Height and Column Width Precisely in Excel

Right click the selected area and choose Column Width in the list.

How to Batch Set the Row Height and Column Width Precisely in Excel

Set the precise value of column width in the popping out window.

How to Batch Set the Row Height and Column Width Precisely in Excel

Now the column width of the whole tab has been modified to fit the text in it. You can also selectively adjust one or several rows/columns in the same way.

How to Batch Set the Row Height and Column Width Precisely in Excel

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *