How to change the size of rows, columns, cells equally in Word, Excel

You spend a lot of time editing the width and height of columns and rows of tables in Word and Excel. The manual editing process makes the column widths and heights unequal. In this article, share to you how to edit the size

You spend a lot of time editing the width and height of columns and rows of tables in Word and Excel. The manual editing process makes the column widths and heights unequal. In this article, share to you how to edit equal size rows, columns, cells in Word, Excel.

How to change the size of rows, columns, cells equally in Word, Excel Picture 1How to change the size of rows, columns, cells equally in Word, Excel Picture 1

1. Resize rows, columns, cells equally in Word

For example, if you have a table of data, you want to change the size of the row and column so that the text content and size are equal:

How to change the size of rows, columns, cells equally in Word, Excel Picture 2How to change the size of rows, columns, cells equally in Word, Excel Picture 2

Method 1:

Resize the lines equally

Select the whole table -> right click and select Distribute Columns Evenly:

How to change the size of rows, columns, cells equally in Word, Excel Picture 3How to change the size of rows, columns, cells equally in Word, Excel Picture 3

Result of all columns in the table of equal width:

How to change the size of rows, columns, cells equally in Word, Excel Picture 4How to change the size of rows, columns, cells equally in Word, Excel Picture 4

Change the height of the line equally in Word

Similarly change the column width, to change the height of the line you choose Distribute Rows Evenly:

How to change the size of rows, columns, cells equally in Word, Excel Picture 5How to change the size of rows, columns, cells equally in Word, Excel Picture 5

So with two very simple operations, you resize the row and column of the table equally:

How to change the size of rows, columns, cells equally in Word, Excel Picture 6How to change the size of rows, columns, cells equally in Word, Excel Picture 6

Method 2:

Change the column width

Select the table -> right click, select Table Properties -> dialog box appears, click the Column tab in the Preferred width field, enter the width needed for the columns in the table -> click OK:

How to change the size of rows, columns, cells equally in Word, Excel Picture 7How to change the size of rows, columns, cells equally in Word, Excel Picture 7

In case you have changed the column width but after clicking OK , the column widths do not change -> make changes to the table width before changing the column width:

How to change the size of rows, columns, cells equally in Word, Excel Picture 8How to change the size of rows, columns, cells equally in Word, Excel Picture 8

Next you change the width of the column in the table:

How to change the size of rows, columns, cells equally in Word, Excel Picture 9How to change the size of rows, columns, cells equally in Word, Excel Picture 9

Changing the height of the line does the same thing in the Row tab :

How to change the size of rows, columns, cells equally in Word, Excel Picture 10How to change the size of rows, columns, cells equally in Word, Excel Picture 10

Finally, click OK, and you have to change the table row and column size equally:

How to change the size of rows, columns, cells equally in Word, Excel Picture 11How to change the size of rows, columns, cells equally in Word, Excel Picture 11

2. Resize column rows equally in Excel

For example, there is a data table to change the row and column size in an equal table:

How to change the size of rows, columns, cells equally in Word, Excel Picture 12How to change the size of rows, columns, cells equally in Word, Excel Picture 12

Method 1:

Resize equal columns:

Move above the column header, when the mouse cursor moves down arrow -> drag and drop select the columns to be resized -> move the mouse into the boundary between any 2 columns when the mouse pointer changes 4-way arrow, hold left mouse button drag right (increase column width) or drag left (decrease column width) until you see the content displayed on the table as appropriate:

How to change the size of rows, columns, cells equally in Word, Excel Picture 13How to change the size of rows, columns, cells equally in Word, Excel Picture 13

As a result, you have resized the columns equally:

How to change the size of rows, columns, cells equally in Word, Excel Picture 14How to change the size of rows, columns, cells equally in Word, Excel Picture 14

Resize equal cell rows in Excel

Similarly, change the width of the column, but hold the left mouse button to drag it upwards (reduce the line height) or drag it down (increase the line height). in Excel:

How to change the size of rows, columns, cells equally in Word, Excel Picture 15How to change the size of rows, columns, cells equally in Word, Excel Picture 15

Method 2:

Resize columns equally

Select all columns to be resized -> go to Home tab -> Format -> Column Width:

How to change the size of rows, columns, cells equally in Word, Excel Picture 16How to change the size of rows, columns, cells equally in Word, Excel Picture 16

The dialog box displays the size to change -> click OK:

How to change the size of rows, columns, cells equally in Word, Excel Picture 17How to change the size of rows, columns, cells equally in Word, Excel Picture 17

Change the height of the row -> do the same thing only you choose Row Height:

How to change the size of rows, columns, cells equally in Word, Excel Picture 18How to change the size of rows, columns, cells equally in Word, Excel Picture 18

Enter the size to change the height of the row -> click OK:

How to change the size of rows, columns, cells equally in Word, Excel Picture 19How to change the size of rows, columns, cells equally in Word, Excel Picture 19

As a result, you can change the size of rows, columns, cells equally without spending a lot of time:

How to change the size of rows, columns, cells equally in Word, Excel Picture 20How to change the size of rows, columns, cells equally in Word, Excel Picture 20

So you can customize the size of columns, rows, cells equally in Word, Excek quickly, right? The operation is extremely simple but gives you a clear and scientific presentation. Good luck!

5 ★ | 1 Vote