Set Column Width In Excel

The post demonstrates how to set column width manually in excel.

Suppose you have some numeric value to set column width in excel, how would you make certain columns in excel of the same width.

We could enter manually the width of any column or columns in excel of what we desire.




As you could see above in the pic, select any column or columns for which you want to set the width manually, right click and click option Column width.

You will get a box in which you can enter the width of your choice as shown below, I have manually set up the column width as 15.

Click OK after entering the dimension, Column width is set to that particular dimension now.

Hope this helped.

Share The Knowledge

Random Posts

Leave a Reply