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.
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:
Method 1:
Resize the lines equally
Select the whole table -> right click and select Distribute Columns Evenly:
Result of all columns in the table of equal width:
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:
So with two very simple operations, you resize the row and column of the table equally:
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:
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:
Next you change the width of the column in the table:
Changing the height of the line does the same thing in the Row tab :
Finally, click OK, and you have to change the table row and column size equally:
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:
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:
As a result, you have resized the columns equally:
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:
Method 2:
Resize columns equally
Select all columns to be resized -> go to Home tab -> Format -> Column Width:
The dialog box displays the size to change -> click OK:
Change the height of the row -> do the same thing only you choose Row Height:
Enter the size to change the height of the row -> click OK:
As a result, you can change the size of rows, columns, cells equally without spending a lot of time:
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
Maybe you are interested
Instructions for quickly aligning Excel printed pages, printing to fit the paper, without losing columns
Excel - Convert columns to rows in Excel
How to delete rows and columns in Excel with mouse or key
Instructions on how to break columns in Word simply and quickly
Column order in Excel is reversed, why and how to handle it?
Excel does not allow inserting additional columns and rows [FIXED]