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 equal size rows, columns, cells in Word, Excel.
How 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 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 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 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 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 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 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 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 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 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 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 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 13
As a result, you have resized the columns equally:
How to change the size of rows, columns, cells equally in Word, Excel Picture 14
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 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 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 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 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 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 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!
You should read it
- MS Excel 2007 - Lesson 10: Modify columns, rows and cells
- How to handle cells, columns, rows in a spreadsheet in Excel
- Complete tutorial of Excel 2016 (Part 6): Change the size of columns, rows and cells
- How to convert columns into rows and rows into columns in Excel
- How to adjust the size of Word table cells equally
- Change the width of columns and the height of rows in Excel
- How to Freeze Cells in Excel
- Add rows and columns - Delete rows and columns - Align rows and columns evenly in the Word table
- How to move rows and columns in Excel
- How to equalize line, column, and cell sizes in Excel
- How to add columns, delete columns, add rows, delete rows in Word 2007, 2010, 2013, 2016
- How to quickly Add and Delete rows and columns in Excel
May be interested
How to write exponentials, square meters, cubic meters, index under chemical formulas in Word
How to do automatic table of contents in Word 2013, 2016
How to insert a background image in Word
How to insert page numbers and page numbers in Word
How to draw a table in Excel
How to use Track Changes in Word