- #How can i freeze first two rows in excel how to#
- #How can i freeze first two rows in excel windows#
You can also use the Freeze Panes menus to freeze columns. Note that the number in brackets after Up to current row reflects the current row selected. To freeze more than one row in Google Sheets, you can select either 2 rows to freeze the top two rows, or Up to current row (row) to freeze up to the row that you have selected. In the Menu, click View > Freeze > 1 row.Īs you scroll down, the top row remains in place.Ĭlick View > Freeze > No rows to remove the freeze. Step 2: Go to View tab > select Freeze Panes >.
#How can i freeze first two rows in excel how to#
In our example, we want to freeze rows 1 and 2, so well select row 3. How to Freeze Multiple Rows Step 1: Select any cell in the row right below the last row you want to freeze. To remove the pane freeze, select Unfreeze Panes from the Freeze Panes menu. Select the row below the row(s) you want to freeze. Columns and rows: Select the rows and columns, then View > Freeze Panes. If you scroll down, these rows will remain in place. Select the first cell of data (for the area you wish to scroll through, not frozen) Go to the View tab In the Window group, select Freeze Panes. First column: View > Freeze Panes (Windows only) > Freeze First Column. First, to freeze the column, select the column which. In the Ribbon, select View > Freeze Panes > Freeze Panes. Freeze Row can be accessed from the View menu tabs Window section from the drop-down list of Freeze Panes. All rows above, or all columns to the left of. Position your cursor in the row you wish to freeze. Select the row below, or the column to the right of the row or column that you want to be in the frozen region. You might want to freeze more than one row. To remove the pane freeze, select Unfreeze Panes from the Freeze Panes menu. In the Ribbon, select View > Freeze Panes.Īs you scroll down in your worksheet, you will see that the top row remains visible regardless of how far you scroll down. In a large worksheet with headings, you might want to make sure that the top row repeats when scrolling, so you can always see it.
#How can i freeze first two rows in excel windows#
This tutorial will demonstrate how to make the top row stay visible in Excel and Google Sheets. From the View tab, Windows Group, click the Freeze Panes drop down arrow Select either Freeze Top Row or Freeze First Column Excel inserts a thin line to show.