Change Column Width in MS Excel 2013

How to change or edit column width in MS Excel 2013?


To change the column width follow the options given below.
Option 1:
Step 1: Mouse hover and keep the mouse pointer in between the line on the column header, it will change into double headed arrow.
Step 2: Drag the mouse pointer towards left /right to decrease or increase the width of the column.
column width ms excel 2013
Option 2:
Step 1:
Select the required column header for which you wish to adjust the column width.
Step 2: Right click on the selected column header and select Column Width.
column width1 ms excel 2013
Option 3: Under HOME tab, select CellsFormatColumn Width.
column width3 ms excel 2013
In the Column Width dialog box, enter the required width and click OK.
column width2 ms excel 2013
Selected column will be adjusted with the width you provided.column width output ms excel 2013

Related Topics