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.

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

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

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 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 .

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

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 .

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

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.

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.

2. Change the row height.

Change the height to a specific value

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

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

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

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 .

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

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 .

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

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.

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.

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.