How to Autofit Column Width to Show all Contents

– How to Setup Column Width

Contents in a cell sometimes are too long and some parts will be hidden. You can use wrap text command to show all the text. If you do not want to wrap text and show all the contents in the cells, you can use autofit command to adjust the column width to show cell contents. Please follow the steps below:

Step 1: Highlight the columns to adjust width;

Step 2: Double click when the cursor turns to a black cross;

Step 3: The contents in the cells will appear.

Alternatively, please use the commands from Ribbon.

Step 1: Select columns that you need to adjust column width;

Step 2: Click the "Home" Tab from the Ribbon;

Step 3: Click "Format" in the Cells area, and select "Autofit Column Width" from the drop-down list.

Leave a Reply