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

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 …

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 …

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.

In the Standard toolbar, click Copy . Select any cell in the column where you want to copy the width. On the Edit menu, click Paste Special, select Column Widths, and then click OK. …

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 …

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 …

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.

Click the cell with the hyperlink and on the Home tab, click Cell Styles. Depending on which style you want to change, right-click Followed Hyperlink or Hyperlink and pick Modify.

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, …