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 …

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 …

To change the size manually, click the chart, and then drag the sizing handles to the size that you want. To use specific height and width measurements, on the Format tab, in the Size group, enter the size …

Right-click over the cells you've chosen and select Format Cells and, in the popup window, click the Border tab. For a continuous line, choose one of the thicker styles from the Line box.

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 …

Select the rows or columns and then select Layout and choose your height and width. Select View > Ruler checkbox, select the cell you want, and then drag the markers on the ruler.

Although Excel offers no direct control for line spacing within a cell, you can use several text alignment strategies to adjust white space or make the text more readable.

Select the cell or cell range that has the text or number you want to format. Click the arrow next to Font and pick another font. To change font size, click the arrow next to the default Font Size and pick the …

You can also click the Increase Font Size or Decrease Font Size (Grow Font and Shrink Font in some earlier versions of Office programs) icons until the size you want is displayed in the Font Size box.