Search

How to change the Column width in Excel worksheet

 

If you are new to spreadsheet concepts like Row, Column and Cell, please visit following link to learn the terms Row, Column and Cell in Excel worksheet before reading the tutorial lesson.

Column width in Excel is a value based on the number of characters that will fit into column width. If you are using Excel default Calibri font with font size 11, the default width of a column in Excel worksheet is 8.43 (64 Pixels). If you change the default font type or size, the default Column width also will change in new worksheets.

Following are the values related with Column width in Excel 2019.

Minimum MaximumDefault
0 (For hidden Column) 255 8.43 (for default font Calibri, Size 11)

If you try to increase the Column width beyond 255, Excel will show below dialog box.

Excel maximum possible Column width is 255

Two methods for changing the Column width in Excel worksheet are explaind below.

Method 1 - How to change Column width by clicking and dragging on boundary gridline

To change the Column width of a single Column by clicking and dragging on Column boundary gridline, follow these steps.

Step 1 - Select the Column you want to change its height by clicking on Column letter. Place the mouse pointer on left-side or righ-side gridline of the Column letter until the mouse pointer turns to a double-sided arrow. You need to place the mouse pointer on left-side or right-side gridline depending on to left or right direction you want to change the Column width. In this example, Column letter C and right-side gridline are selected.

Now click on the right-side gridline of Column letter, as shown below.

 

Column letter gridline is clicked to change the width

 

Step 2 - Drag the mouse till the desired width is reached and then drop the mouse to change the Column width. As you drag, Excel will keep displaying the changing Column width as tooltip message.

Column letter gridline is clicked to change the width

 

An animation about how to change the Column width of a single Column by drag and drop is copied below.

Single Column width change by drag and drop animation

.

Similarly, you can change the width of multiple Columns simultaneously by click, drag and drop. Select multiple Columns and then click, drag and drop on left-most or right-most gridline of the Columns selection for changing the width of multiple Columns simultaneously.

An animation about how to change the Column height of multiple Columns by drag and drop is copied below

Multiple Column width change by drag and drop animation

 

Method 2 - How to change Column width by entering the exact Column width value

Sometimes it is difficult to select the exact Column width by using drag and drop method described above, because the Column width value keep changing as you drag. Follow below steps to change single Column width by entering the exact Column width value.

Step 1 - Right-click the the Column you want to change the column width and click the "Column Width" to open "Column Width" dialog box from the context menu, as shown in below image.

Right-click the Column and select Column width from menu

You can open the "Column Width" dialog box also from Excel Ribbon > "Home" Tab > "Cells" > "Format" as shown below.

Open Column width dialog box from Excel Ribbon

Step 2 - Enter exact value for Column width in Column width dialog box and click "OK" to change the Column width, as shown below.

Enter Column width value in Column width dialog box

 

Similarly, you can change the width of multiple Columns simultaneously by typing-in the Column width value. Select multiple Columns and then right-click on any Column in the selection. Click the "Column Width" from the context menu and type-in the Column width value in dialog box. Click "OK" button.

 

Related Tutorials
• Important Excel Worksheet Navigation keys
• Excel Cursor and Mouse Pointer Shapes
• Row, Column and Cell in Excel worksheet
• How to change the Row height in Excel worksheet
• Excel AutoFit Row Height
• Excel AutoFit Column Width
• How to hide or unhide Rows in Excel worksheet
• How to hide or unhide Columns in Excel worksheet
• Maximum rows and columns in Excel Worksheet
• What is Active Cell in Excel and How to identify Active Cell
• What is Range in Excel Worksheet and How to form a Range Address
• Examples of Range Addresses in Excel worksheet
• Types of Ranges in Excel Worksheet
• How to select Range in Excel worksheet
• How to select Multiple Range in Excel worksheet
• What is Group mode in Excel, How to exit Group edit mode
• How to select all worksheets to Excel group
• How to select Ranges from different worksheets using Excel Group edit mode
• How to hide or show Excel Worksheet Row and Column headings (Column Letter and Row Number)
• How to hide or show Excel Worksheet Gridlines
• How to change the color of Excel worksheet Tabs
• How to change the color of Excel Gridlines
• How to change the default font and size in Excel
• How to Move or Copy entire worksheet within an Excel workbook
• How to Move or Copy entire worksheet to another Excel workbook