Change the width of columns and the height of rows in Excel

The default column widths and row heights in Excel may not match the data you enter. You want to change the width, height of rows and columns so that data is displayed fully on cells in Excel.

The following article shows you some ways to change the width of columns, the height of rows in Excel.

1. Change the width of the column.

Change width by specific value

1. Select one or more columns you want to change the width.

Change the width of columns and the height of rows in Excel Picture 1

2. Select the Home tab , in the Cells section, select Format -> Column Width .

Change the width of columns and the height of rows in Excel Picture 2

3. In the Column Width dialog box, enter the width value for the column as you like. Then click OK .

Change the width of columns and the height of rows in Excel Picture 3

Note: You can change the width of the column quickly by, select one or more columns to change the width, right-click the title of the selected columns and select Column Width , and enter the width value. in the Column Width dialog box.

Change the width of columns and the height of rows in Excel Picture 4

Change the column width to automatically match the content in the column

1. Select one or more columns for which you want to change the width.

2. In the Home tab, select Format -> AutoFit Column Width .

Change the width of columns and the height of rows in Excel Picture 5

The column will automatically change the width to match the content in the column.

Change the width of columns and the height of rows in Excel Picture 6

Change the width of all columns in the sheet

1. Select the icon in the following image to select (highlight) all columns in a sheet. You can press Ctrl + A .

Change the width of columns and the height of rows in Excel Picture 7

2. Place the cursor between any 2 column headers to appear the cursor icon as shown below:

Change the width of columns and the height of rows in Excel Picture 8

3. Click and drag the appropriate column widths and release the mouse pointer, all the other columns have equal width and equal to the width you just adjusted.

Change the width of columns and the height of rows in Excel Picture 9

You can also change the width of each column by placing the mouse pointer on the header line with the next column, then moving left or right the title to expand or narrow the width of the column.

Change the width of columns and the height of rows in Excel Picture 10

2. Change the row height.

Change the height to a specific value

1. Select one or more rows you want to change the height.

Change the width of columns and the height of rows in Excel Picture 11

2. Select Home -> Format -> Row Height .

Change the width of columns and the height of rows in Excel Picture 12

3. In the Row Height dialog box, enter the value to change the column height and click OK .

Change the width of columns and the height of rows in Excel Picture 13

Change the row height to match the content in the row

1. Select one or more rows to change height.

2. Select Home -> Format -> AutoFit Row Height .

Change the width of columns and the height of rows in Excel Picture 14

The result after automatically changing the height to match the content in the row:

Change the width of columns and the height of rows in Excel Picture 15

Change the height of all rows in the sheet

1. Select the icon shown below to select (highlight) all rows in a sheet. You can press Ctrl + A .

Change the width of columns and the height of rows in Excel Picture 16

2. Place the cursor between any 2 row headers to bring up the cursor icon as shown below:

Change the width of columns and the height of rows in Excel Picture 17

3. Click and drag to adjust the appropriate row height and release the mouse pointer, all other rows have the same height and the height you just adjusted.

Change the width of columns and the height of rows in Excel Picture 18

You can also change the height of each row by placing the mouse pointer on the header line with the row below (or the row above), then moving up or down the title to expand or collapse. narrow row height.

Change the width of columns and the height of rows in Excel Picture 19

Above are the ways to change the width, height of rows and columns in Excel, when necessary you can quickly change the width and height to fit your data. Good luck.