Freeze columns, rows, or area

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.

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.

•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.

•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.

•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.

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 in one of the following ways:

•On the Home tab, in the Cells group, click the arrow to the right of the  Freeze button. In the sub-menu that opens, select  Freeze horizontally to freeze rows or  Freeze vertically to freeze columns.

•On the Page layout tab, click the arrow to the right of the  Freeze button. In the sub-menu that opens, select  Freeze horizontally to freeze rows or  Freeze vertically to freeze columns.

•When working in macOS, select the Table > Freeze selected rows and columns command from the command menu. In the sub-menu that opens, select Freeze horizontally to freeze rows or 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/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  Group.

•On the Home tab, in the Cells group, click the arrow to the right of the  Freeze button. In the sub-menu that opens, select  Freeze selected rows and columns.

•On the Page layout tab, click  Freeze.

•On the Page layout tab, click the arrow to the right of the  Freeze button. In the sub-menu that opens, 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  Freeze button. In the sub-menu that opens, select  Freeze area.

•On the Page layout tab, click the arrow to the right of the  Freeze button. In the sub-menu that opens, select  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  Freeze button. In the sub-menu that opens, select  Unfreeze all.

•On the Page layout tab, click the arrow to the right of the  Freeze button.In the sub-menu that opens, select  Unfreeze all.

•When working in macOS, select the Table > Freeze selected rows and columns > Unfreeze all command from the command menu.

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