Question

Gauri is creating a worksheet with details of her 4 friends. she makes a separate column for each friend and writes about him or her in the cell and then she uses Autofit and Wrap Text features. Write the steps to Autofit columns

Answer 1

The following steps can be followed to do Autofit of columns in MS Excel 2013.

*Open the Excel spreadsheet to set up autofit of columns.

*Click on the top left corner of the worksheet between Row A and Column 1 to select the full worksheet.

*Click the Home tab at the top of the Excel spreadsheet.

*Click the Format option in the Cell section.

*In the dropdown list, select the AutoFit Column Width option.