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

How to Autofit the Column Width with the Content in Excel

Date:2019-10-9 Author:Cordelia

Everyone who often use Excel should have encountered a situation that the entered text is so long that exceed the cell’s border. So how to autofit the column width to make it correspond with the length of characters? Here are 2 commonly used methods.

Method 1: Wrap Text

1. Select the cells you want to adjust.

How to Autofit the Column Width with the Content in Excel

2. Go to Home tab and click Wrap Text in Alignment section.

How to Autofit the Column Width with the Content in Excel

3. Then the content in the cells will fit the column width and wrap text automatically.

How to Autofit the Column Width with the Content in Excel

Method 2: AutoFit Column Width

1. Select the cells you want to autofit width.

How to Autofit the Column Width with the Content in Excel

2. Find Cells section in Home tab, click AutoFit Column Width in the list.

How to Autofit the Column Width with the Content in Excel

3. Then the column width of selected cells will fit the length of characters automatically.

How to Autofit the Column Width with the Content 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 *