To change the width of one column, drag the boundary on the right side of the column heading until the column is the width that you want. To change the width of multiple columns, select the columns that …

To increase the width of multiple consecutive columns, select the columns you want to change. Click the header boundary of any selected column and drag to the right, like in the picture below.

To shrink the contents of a cell so that they fit in the current column width, on the Home tab, click the Format button, click Format Cells, and then select Shrink to Fit.

On the Layout tab, in the Cell Size group, click in the Table Column Width box, and then specify the options you want. To make the columns in a table automatically fit the contents, select your table.

If the data you paste has more columns than the table, the extra columns don't become part of the table—you need to use the Resize command to expand the table to include them.

If you’re new to touch devices, learning a few gestures will help you take maximum advantage of the touch capabilities. Moving around in a file ... Making a Selection ... Working with Columns or Rows

Select the boundary of the column or row you want to move and drag it to the width or height you want. Select the rows or columns and then select Layout and choose your height and width.

Change the width of columns Click and drag across the column headings for the columns that you want to change. Column separator Column headings Note: If you have to change the width of only one …

On the Layout tab, in the Cell Size group, click in the Table Column Width box, and then specify the options you want. To make the columns in a table automatically fit the contents, select your table.

For more information about using the AutoFit command, click Microsoft Excel Help on the Help menu, type Change column width in the Office Assistant or the Answer Wizard, and then click Search to …