How to equalize line, column, and cell sizes in Excel

After creating a table on Word or creating a table on Excel, manipulating the width and height of the columns, the rows in the table are necessary to create a uniform layout. However, many people do not know how to do it when editing, so the width and height of the columns are not equal. Therefore, users should use the tool to resize cells in Word tables, or on existing Excel. The following article will show you how to resize the table in Excel.

1. How to adjust the size of Word table cells equally
2. Line breaks in Excel
3. Guidance on how to align Excel correctly

Instructions to equalize size in Excel tables

We will handle the data table below to adjust the size of cells, rows and columns equally.

How to equalize line, column, and cell sizes in Excel Picture 1

Method 1: Adjust the size manually

1. Change the column size equally

Move the mouse to the top of the column headers and select the columns to resize. Move your mouse over the boundary line between the 2 columns until the mouse pointer changes to a 4-way arrow, then hold down the right mouse button to increase the column width, or drag left to reduce the column width.

Users adjust to size so that the columns are equal.

How to equalize line, column, and cell sizes in Excel Picture 2

2. Change the line size equally

To change the line width, hold down the left mouse button and drag it upward to reduce the line height or drag it downwards to increase the line height. Adjust the size of the lines equally depending on the content entered in the table.

How to equalize line, column, and cell sizes in Excel Picture 3

Method 2: Enter the size directly

1. Change the column size equally

Users black out all columns that need to be resized and then click on the Home tab , then click on Format and click Column Width .

How to equalize line, column, and cell sizes in Excel Picture 4

Display the small dialog box to enter the size you want to change for the column and click OK.

How to equalize line, column, and cell sizes in Excel Picture 5

The result will be the size of the columns evenly in the table.

How to equalize line, column, and cell sizes in Excel Picture 6

2. Change the height of the row

We also black out the entire Excel table, click on the Home tab, select Next Format and then click the Row Height .

How to equalize line, column, and cell sizes in Excel Picture 7

You enter the size you want to change for each row and click OK to apply.

How to equalize line, column, and cell sizes in Excel Picture 8

Immediately the height of the rows in the table will be adjusted to the same size, exactly the size entered.

How to equalize line, column, and cell sizes in Excel Picture 9

Note , if the user does not know the size of the row and column height, click and hold the left mouse button on the vertical line at the top of the column header to see the current size of the column. Click and hold the left mouse button on the horizontal line in the row title to see the size.

How to equalize line, column, and cell sizes in Excel Picture 10

So you will have 2 ways to adjust the column size, line, and cells equally in Excel table. After the adjustment is complete, the layout will be equal, the content is presented clearly and scientifically.

See more:

1. How to set the default font and font size on Excel
2. How to reduce image size in Word 2007, 2010, 2013, 2016
3. How to reduce Word file size

I wish you all success!