How To Change Column Width in Excel

Follow these steps show to change the width of a column in Excel.

The default size of an Excel row is 15, with the default font of Calibri and default font size of 11 points. The default column width for all the columns is 8.38. If you set the column width to 0, the column will be hidden. In Excel, you can change any column widths or row heights in your worksheets to improve the readability and appearance of data. Follow these steps show to change the width of a column in Excel.

How to Change Column Width in Microsoft Excel

Option one

To change the width of columns, position the mouse pointer on the right boundary of a column heading until it turns into a double-sided arrow. Drag left or right until the column is the width that you want.

How to Change Column Width in Microsoft Excel

Option two

To change the width of multiple Column select the Columns of interest and Drag left or right until the column is the width that you want.

How to Change Column Width in Microsoft Excel

To change width of all Columns on the sheet, select the entire sheet by pressing Ctrl + A or clicking The Select All button, and then Drag left or right until the column is the width that you want.

How to Change Column Width in Microsoft Excel

Option three

To set the column width to a specific value, select the column whose width you wish to change, and then go to the Home tab in the Cells group and click Format.

How to Change Column Width in Microsoft Excel

In the drop-down list, select column width Enter the desired width, and press OK.

Change Column Width in Microsoft Excel

To do this for all columns,

Select an area by clicking in one cell, and dragging the highlighted portion to span the entire width of the section you’d like to resize and then click home tab in the Cells group and click Format. In the drop-down list, select column width. Enter the desired width, and press OK.

Alternatively

Right-click a column header.
Select column width.

How to Change Column Width in Microsoft Excel
Enter width pixels.