Do you find that you frequently have to resize the columns in your worksheets? Did you know that you can easily set a default column width so that you no longer have to resize your columns?
Follow the steps below to learn how:
- Click on the Home tab.
- In the Cells group, click on Format.
- Click on Default Width.
- Key in the default column width.
- Click on OK.
To define the default column width for all new workbooks and worksheets, create a workbook template and a worksheet template and then base your new workbooks and worksheets on those templates.