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

Change column width or row height to make data more visible by dragging the column or row headers.

Select the cell that contains the data that you want to edit, and then press F2. This starts Edit mode and positions the cursor at the end of the cell contents.

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 Table Design > Resize Table. Select the entire range of cells you want your table to include, starting with the upper-most cell. In the example shown below, the original table covers the range …

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 …

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 …

Changing default formats includes things like changing the font color, style, size, text alignment in a cell, or apply formatting effects. This article shows you how you can apply different formats and also undo …

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.