Freeze columns, rows, or area

Application: Spreadsheet Education

Locking columns, rows and areas is used when working with large amounts of data. When you scroll the sheet to the right and/or down, the frozen row, column or area is always displayed on the screen. The frozen element is separated from the other elements of the sheet by a bold line.

If you have already frozen rows or columns and want to freeze the new ones, the previous setting for the identical element will be no longer valid.

When working in MyOffice Spreadsheet. you can freeze:

–One or several columns: If you scroll the sheet to the right, only the frozen columns are displayed, and all columns to the left are hidden from the screen.

column_freeze

–One or several rows: If you scroll down the sheet, only the frozen rows are displayed, and all rows above them are hidden from the screen.

row_freeze

–Columns and rows at the same time: When you scroll the sheet to the right and down, only the frozen columns and rows are displayed, and all columns that are to the left and rows that are above are hidden from the screen.

cols_rows_freeze

–The area of the screen where the upper-left cell is cell A1 and the bottom right cell is the cell specified by the user.

area_freeze

To freeze one or several columns or one or several rows, follow these steps:

1.Select the desired columns or rows in their entirety or select any number of cells located in these columns or rows.

2.Freeze columns or rows using one of the following methods:

•On the Home tab, in the Cells group, click the arrow to the right of the t_home_freeze_default Freeze button and select t_home_freeze_rows Freeze horizontally to freeze rows, or t_home_freeze_columns Freeze vertically to freeze columns.

•On the Page layout tab, click the arrow to the right of the t_home_freeze_default Freeze button and select t_home_freeze_rows Freeze horizontally to freeze rows, or t_home_freeze_columns Freeze vertically to freeze columns.

•If columns or rows are selected in their entirety, right-click the headings of the selected columns or rows and run the Freeze selected rows and columns command from the context menu.

To freeze both rows and columns at the same time, follow these steps:

1.Select any number of cells located in the columns or rows you want to freeze.

2.Freeze columns or rows in one of the following ways:

•On the Home tab, in the Cells group, click t_home_freeze_default Group.

•On the Home tab, in the Cells group, click the arrow to the right of the t_home_freeze_default Freeze button and select Freeze selected rows and columns.

•On the Page layout tab, click t_home_freeze_default Freeze.

•On the Page layout tab, click the arrow to the right of the t_home_freeze_default Freeze button and select Freeze selected rows and columns.

To freeze an area, follow the steps below:

1.Select the cell that will be the bottom right cell of the area.

2.Freeze the area in one of the following ways:

•On the Home tab, in the Cells group, click the arrow to the right of the t_home_freeze_default Freeze button and select t_home_freeze_area Freeze area.

•On the Page layout tab, click the arrow to the right of the t_home_freeze_default Freeze button and select t_home_freeze_area Freeze area.

To unfreeze all rows and columns in the document, do one of the following:

–On the Home tab, in the Cells group, click the arrow to the right of the t_home_freeze_default Freeze button and select t_home_unfreeze Unfreeze all.

–On the Page layout tab, click the arrow to the right of the t_home_freeze_default Freeze button and select t_home_unfreeze Unfreeze all.

–Right-click the heading of any row or column and run the Unfreeze all command from the context menu.

Was this helpful?

Yes