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

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

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

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

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

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

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.

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

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 .

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

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

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

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 .

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

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

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

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.

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

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.

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

2. Change the row height.

Change the height to a specific value

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

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

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

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

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

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

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 .

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

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

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

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 .

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

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

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

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.

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

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.

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

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.

Update 19 May 2020
Category

System

Mac OS X

Hardware

Game

Tech info

Technology

Science

Life

Application

Electric

Program

Mobile