– How to Autofit Column Width to Show all Contents
You can always drag columns to make them wider or narrow, however, sometimes you may need to set to a fixed width. Please follow steps below to adjust the column width:
Step 1: Click the column header to select the columns;
Step 2: Right-click, and select "Column Width" from the list;
Step 3: Enter column width number in the box, e.g., 12;
Step 4: Click "OK" at the bottom.
Alternatively, please refer to the commands in the ribbon.
Step 1: Click the column header to select the columns;
Step 2: Click the "Home" Tab from the Ribbon;
Step 3: Click the "Format" in the Cells areas, and select "Column Width" from the drop-down list.
Step 4: Enter column width number in the box, e.g., 12;
Step 5: Click "OK" at the bottom.