How can you resize the column?

To resize the column, first modify the width of one column, then drag the right-hand border of the column header to the desired width. The alternative option is to pick Format from the home tab, and then choose ‘AUTOFIT COLUMN WIDTH’ under the cell part of Format. The cell size will be formatted when you click this.