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
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.
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.
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.
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.
In the drop-down list, select column width Enter the desired width, and press OK.
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.
Right-click a column header.
Select column width.
Enter width pixels.
Recommended For You
Published on: Apr 12, 2021-Last edited: 13-04-2023