How to change the column width and row height, including how to use the AutoFit feature, in your Excel worksheet.

If you can’t see all the data in a cell, changing the row height or column width can help: To increase the width of a single column, such as column B in the picture below, drag the boundary on the right side …

To change the width to a specific measurement, select a cell in the column that you want to resize. On the Layout tab, in the Cell Size group, click in the Table Column Width box, and then specify the …

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 …

If you have a worksheet with data in columns that you need to rotate to rearrange it in rows, use the Transpose feature. With it, you can quickly switch data from columns to rows, or vice versa.

If Excel displays ##### in a cell after you apply currency formatting to your data, the cell probably isn't wide enough to display the data. To expand the column width, double-click the right boundary of the …

If a chart that you create does not display the worksheet data on the axis that you want, you can quickly change the way that data is plotted.

If your data is in an Excel table, the Transpose feature won’t be available. You can convert the table to a range first by using the Convert to Range button on the Table tab, or you can use the TRANSPOSE …

Cause: The default cell reference style (A1), which refers to columns as letters and refers to rows as numbers, was changed. Solution: Clear the R1C1 reference style selection in Excel preferences.

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.