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 of the column B header until the column is the width that you want.
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.
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.
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 options you want.
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 column, you don't have to select it first. Point to the separator on the right side of any selected column heading. The pointer becomes a .
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 view the topic.
In the Columns dialog box, adjust the settings under Width and spacing to choose your column width and the spacing between columns. If you want columns of varying widths, deselect the checkbox next to Equal column width.
Data in the cell wraps to fit the column width, so if you change the column width, data wrapping adjusts automatically. If all wrapped text is not visible, it may be because the row is set to a specific height or that the text is in a range of cells that has been merged.
On the Excel menu, click Preferences. Under Authoring, click General . On the Ruler units menu, click the unit of measurement that you want to use. Tip: You can also see the column width by dragging the column separator on the sheet and observing the ScreenTips as you drag.
