To resize the column you have to 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.

Hover your arrow over the border between the column or row labels. Then click and drag the border to widen or narrow the size of each cell. The columns to the right or rows below will adjust to make room for your .

The Format button in the cells group under the Home tab can also be used to adjust widths and heights. Simply select the cells that need to be adjusted, then click on the Format button and choose either Row Height or Column Width. Type in your desired number, and the cells will adjust.

If several columns or rows in your table need to be adjusted to accommodate your data, Excel can automatically adjust the spreadsheet.

Select all of the columns or all of the rows that contain your data. Then, hover over the border until your arrow becomes a double arrow. Double click on the border, and all of the rows or columns will automatically adjust to fit the data.

To adjust an entire worksheet with both rows and columns, type Control A to select the entire worksheet. Then, double click with a double arrow on any column or row border.