How can we help you?

You can freeze any range of columns and rows or areas so that they are always visible when you move around the sheet. This is useful if you are working with large amounts of data and often scroll through the window.The frozen elements are separated from other elements with a bold line.

If you've already frozen rows or columns and want to freeze the new ones, the previous setting for the same item will be invalidated.

In MyOffice Spreadsheet, you can freeze the following elements:

One or multiple columns: Only the frozen columns are displayed when scrolling the sheet to the right. All the columns to the left are not displayed.

One or multiple rows: Only the frozen rows are displayed when scrolling the sheet down. All the columns above are not displayed.

Columns and rows: Only the frozen columns and rows are displayed when scrolling the sheet to the right and down. All the columns to the left and all the rows above are not displayed.

The screen area where the top left cell is A1 and the bottom right cell is defined by the user.

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

1.Entirely select rows or columns you want to freeze or select any cells in these rows or columns.

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

In the Command menu, select Table > Freeze Selected Rows and Columns. In the opened sub-menu, select Freeze Horizontally to freeze rows or Freeze Vertically to freeze columns.

On the Toolbar, select the Cells section and click editor_freeze_panes_icon Freeze.

On the Toolbar, select the Cells section and click the arrow to the right of the editor_freeze_panes_icon Freeze button. In the opened sub-menu, select Freeze Horizontally to freeze rows or Freeze Vertically to freeze columns.

To simultaneously freeze rows and columns, do the following:

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

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

On the Toolbar, select the Cells section and click Freeze Selected Rows and Columns.

On the Toolbar, select the Cells section, click the arrow to the right of the editor_freeze_panes_icon Freeze Selected Rows and Columns button. In the opened window, select Freeze Selected Rows and Columns.

Right-click the headings of the selected rows and columns and select Freeze Selected Rows and Columns in the context menu.

To freeze an area, do as follows:

1.Select a cell which will be the bottom right cell of the area.

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

On the Toolbar, select the Cells section and click editor_freeze_panes_icon Freeze Selected Rows and Columns.

On the Toolbar, select the Cells section and click the arrow to the right of the editor_freeze_panes_icon Freeze Selected Rows and Columns button. In the opened sub-menu, select Freeze Area.

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

In the Table menu, select Freeze Selected Rows and Columns > Unfreeze All.

On the Toolbar, select the Cells section, click the arrow to the right of the editor_freeze_panes_icon Freeze Selected Rows and Columns button and select the Unfreeze All option in the sub-menu.

Right-click the heading of any row or column and select Unfreeze All in the context menu.

Was this helpful?
Yes
No
Previous
Resize a column or row
Next
Group columns or rows