This will determine which panes will be frozen and how they will appear on the spreadsheet. The first step is to decide which columns and rows you would like to freeze.

There are several steps that can be taken to freeze multiple panes in an Excel spreadsheet. You can also use the keyboard shortcut: Alt, W, F. This will both horizontally and vertically freeze the area you selected. A drop-down menu will appear and you will select the option “Freeze Panes”. Then, go to the View tab and select “Freeze Panes” from the “Window” section of the ribbon. To do this, you need to first select the cell to the right and below the cell you want to be your split between the frozen and non-frozen area.

Choose Freeze First Column or Freeze First Row.You can freeze panes vertically and horizontally simultaneously in Microsoft Excel.

Select Freeze Cells to view the freeze options.

The following section shows you how to freeze and unfreeze rows and columns in the OpenOffice spreadsheet program, LibreOffice Calc. In our example below, when we scroll down in the workbook, row 1 remains visible, while rows 2 and 3 are hidden. To test, scroll down or to the right in the workbook.

Depending on your choices, you now see a border around a section of rows or columns indicating they are locked in place.

For our example, we chose to lock row number one.

From here, you may select the row(s) or column(s) to lock.

At the top of the window, click View in the menu bar.

Navigate to Google Sheets and create a new spreadsheet, or open an existing one.

The following sections show you how to freeze and unfreeze rows and columns in Google Sheets.

Select Unfreeze Panes from the drop-down menu.

Open a spreadsheet with frozen rows or columns.

In our example below, when we scroll down the page, row 1 remains visible, while rows 2 and 3 are hidden. To test, scroll down or to the right in the spreadsheet.

Depending on your choice, the top row or the first column is now locked in place.

Select Freeze Top Row or Freeze First Column from the drop-down menu.

In the View section, to the right, click Freeze Panes.

At the top of the screen, click the View tab.

Open an existing Excel spreadsheet or create a new one.

The following sections show you how to use freeze panes in Microsoft Excel.

Freeze both columns and rows in excel