You can readjust the size of rows and columns in an Excel spreadsheet. You can also freeze a row or column so you can view it alongside data elsewhere in the worksheet.
In this article, you will learn the steps to adjust the sizing of columns and row, then freeze a pane in an Excel worksheet.
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.
The selected row is formatted to reflect the entered row height.
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.
The selected column(s) are formatted to reflect the entered column width.
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.
The selected row/column is frozen, allowing you to scroll through the data while keeping the row/column in view.