To resize the column, you should change the width of one column and then drag the boundary on the right side of the column heading till the width you want. The other way of doing it is to select the Format from the home tab, and in Format you have to select “AUTOFIT COLUMN WIDTH” under cell section. On clicking on this, the cell size will get formatted.
Sandhya Answered question April 18, 2023
- Select the columns that you want to change.
- Under Cell Size, click Column Width.
- In the Column width box, type the value that you want and click OK.
Sandhya Answered question April 18, 2023