How to Freeze a Row in Excel

How to Freeze a Row in Excel / freeze rows and columns in excel

Freeze Top Row in Excel

1. Open Your Excel Spreadsheet
2. Navigate to the “View” tab on the ribbon at the top of the screen.
3. Freeze Panes: In View tab go to “Window” group.
4. To freeze the top row: View > Freeze Panes > Freeze Top Row

This will keep the top row (Row 1) visible as you scroll down through the rest of your spreadsheet, you also have an option for freeze top columns

Freeze Multiple Rows

First Select Rows which you want to freeze

To freeze multiple rows: Select the row below the rows you want to freeze > View > Freeze Panes > Freeze Panes

If you want to freeze more than just the top row, you can use the “Freeze Panes” option:

1. Select the Row Below: Click the row number on the left side of the Excel sheet to select the entire row that is directly below the rows you want to freeze. For example, if you want to freeze the first 5 rows, you should select row 6.
2. Freeze Panes:
3. To freeze multiple rows: > View > Freeze Panes > Freeze Panes

Follow above steps to get to know How to Freeze a Row in Excel

Freeze First Column

View > Freeze Panes > Freeze First Column

Unfreezing Panes

If you need to unfreeze the rows at any point, follow these steps:

To unfreeze: View > Freeze Panes > Unfreeze Panes

Now you know ‘How to Freeze a Row in Excel’

https://excelbasics.fun/how-to-remove-duplicates-in-excel/(opens in a new tab)

https://img4v.com/marathi-fonts-style-converter/