Thứ Ba, Tháng Hai 11, 2025
spot_img
HomeFinanceHow to size rows, columns, and cells equally in Excel

How to size rows, columns, and cells equally in Excel

After creating a table in Word or creating a table in Excel, adjusting the width and height of the columns and rows in the table is necessary to create a uniform table 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 cell resizing tool in the Word table, or available in Excel. The article below will guide you how to resize a table in Excel.

Instructions for changing equal sizes in Excel tables

We will process the data table below to size cells, rows, and columns equally.

Excel data table

Method 1: Manually resize

1. Resize columns equally

Move the mouse to the top of the column headers and select the columns that need to be resized. Move the mouse to the boundary line between the two columns until the mouse pointer turns into a 4-way arrow, then hold down the mouse and drag to the right to increase the column width, or drag to the left to decrease the column width.

Users adjust the size so that the columns are equal.

Adjust column size

2. Resize the cell lines equally

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

Adjust line size

Method 2: Enter dimensions directly

1. Resize columns equally

The user highlights all the columns that need to be resized and then clicks Home tabselect continue Format and press select Column Width.

Xem thêm  10 best programs to install on a new gaming PC

Adjust column size

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

Enter the column size

The result will be evenly sized columns in the table.

Columns are equal

2. Change the row height

We also highlight the entire Excel table, click on the Home tab, and select next Format then click Row Height.

Change item size

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

Enter row size

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

Row sizes are equal

Noteif the user does not know how to enter dimensions for row and column heights, 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.

See table dimensions

So you will have 2 ways to size columns, rows, and cells equally in Excel tables. After adjusting, the table layout will be even and the content will be presented clearly and scientifically.

See more:

Wishing you success!

RELATED ARTICLES

LEAVE A REPLY

Please enter your comment!
Please enter your name here

- Advertisment -
Google search engine

Most Popular

Recent Comments