Resizing and Freezing Rows and Columns

To change the height of a row(s), click the appropriate number(s) in the row header.

Example shown here: number 2 to expand the height for Row 2 .

To change the height of the selected row(s), click the Format button on the Home tab.

From the Format menu list, select the Row Height option.

In the Row height field, a default height number appears for the selected row(s). You change the height of the selected row(s) by entering a larger or smaller number.  

Example shown here: " 20 " in the Row height field

Click OK.

To change the width of a column, click the appropriate letter in the column header.

Example shown here: the letter A to expand the width of Column  .

To change the width of the selected column(s), click the Format button.

From the Format menu list, select the Column Width option.

In the Column width field, a default width number appears for the selected columns(s). You change the width of the selected column(s) by entering a larger or smaller number.  

Example shown here: " 12 ". Column width field.

Click OK.

The Freeze Panes option in Excel allows you to compare data in large datasets. The function allows you keep an area of a worksheet visible while you scroll to another area of the worksheet.

To freeze panes, click the appropriate number or letter in the selected row or column header.

Example shown here: letter A to freeze Column A .

Click the View tab.

To freeze the selected column, click the Freeze Panes button on the Home tab.

From the Freeze Panes menu, you can select the appropriate action for how you want to freeze the selected row/column(s).  

Example shown here: Freeze First Column from the list.