How to Adjust Column width in Excel a step by step Tutorial

In this guide, we’ll show you how to adjust the column width in Excel using keyboard shortcuts. Adjusting the column width is essential in a financial model to ensure all necessary data is visible and to improve the overall look of your spreadsheet.

Why Adjust Column Width in Excel?

The column width in Excel should be adjusted to fit the content within the spreadsheet properly.

• Narrow Column Width: If a column is too narrow, cell values can be hidden, displaying as “###”.
• Wide Column Width: If a column is too wide, it can create too much white space, making the spreadsheet look unorganized. Proper column width is also important if you plan to print the spreadsheet.

By default, Excel sets the column width to 8.43 units (equal to 64 pixels). This width can be adjusted in the settings to different units like inches, centimeters, or millimeters.

In financial modeling, it’s best to keep column widths consistent, though there are exceptions. For instance, using a narrow Column A can help navigate between sections of a model more easily. While having varying column widths is not inherently wrong, a model can look unprofessional if columns are noticeably different widths.

Steps to Adjust Column Width in Excel

To adjust the column width—either to increase or decrease it—follow these steps:

1. Select the Column(s) to Adjust: Click on the letter at the top of the column.
2. Open the “Home” Tab: Click on the “Home” tab at the top of Excel.
3. Click on “Format”: In the Home tab, find the “Format” button in the “Cells” group.
4. Select “Column Width”: Click on “Column Width” in the drop-down menu.
5. Enter the Desired Width: Type in the specific width you want and click “OK”.

To adjust all columns, press “Ctrl + A” to select everything, then follow the same steps.

Alternatively, you can right-click on the column letter, select “Adjust Column Width”, and enter the desired width.

How to Adjust Column Width Using Excel Keyboard Shortcut

Using keyboard shortcuts can save time. To quickly open the adjust column width box and set the width, use this shortcut:

Adjust Column Width Shortcut: Alt + H + O + W

Press each key in sequence, not simultaneously.

How to Use Excel Autofit Function

Excel can automatically adjust column widths to fit the content. To use this feature:

1. Open the “Format” box as described earlier.
2. Select “Autofit Column Width” from the cell size group.

Alternatively, you can double-click the boundary line between columns to auto-adjust the width based on the content.

To autofit multiple columns, select all the columns and double-click any of the column boundaries.

Autofit Column Width Shortcut: Alt + H + O + I

Again, press each key one after the other, and the selected columns will automatically adjust to fit the content.

‍