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 .
May 05 2014 10:05 AM
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.