Take a Guess to Win Windows 10 Pro Key!
previous arrow
next arrow
Slider

How to Change the Default Column Width in Excel

Date:2019-7-31 Author:Cordelia

When you open a new Excel file, the cells present in front of you have their own default data of width. If you have a certain need and don’t want to adjust the width of each cell one by one, you can change the default width of columns.

Click Home tab, find Format in the Cells section and select Default Width… in the drop-down menu.

How to Change the Default Column Width in Excel

Input the width you like and click OK to confirm it.

How to Change the Default Column Width in Excel

You can see the width of all the columns have already changed.

How to Change the Default Column Width in Excel

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *