All TalkersTech Sections

How To Freeze Selected Rows In Excel

Last Updated : Apr 23, 2022

How To Freeze Selected Rows In Excel

In this article we will show you how to freeze selected rows in excel, MS Excel is a spreadsheet tool that allows you to store data in the form of tables. Data analysis on an Excel spreadsheet is fairly simple.

It allows us to modify data in cells. A cell is formed by the intersection between a row and a column.

In Excel, a row is a horizontal arrangement of cells. Columns, on the other hand, are vertical cell groupings.

A worksheet is a single-entry page of cells. Worksheets, by default, are labeled with tabs. Worksheets include data that is connected.

Each worksheet may have an excessive amount of data that extends beyond the confines of the page.

If we wanted to see the rest of the data, we'd have to scroll down the worksheet using the vertical scroll bars on the sides of the spreadsheet.

This scrolls all of the text from the first row to the rows we want to see. However, such events are not always desirable.

Do you need to rapidly navigate that massive spreadsheet? Freeze panes can help by allowing you to see your column and row titles while scrolling across your document.

Step By Step Guide On How To Freeze Selected Rows In Excel :-

  1. The first worksheet will be loaded after Opening Excel. Choose the rows you wish to freeze. To do this, move the cursor to the left-most side of the rows you want to highlight.
  2. The rows that will be frozen are those immediately above the last selected row. For example, to freeze all of the top ten rows, select the eleventh row.
  3. In my situation, I chose the first three so that the first two rows can be frozen.
  4. On the Excel ribbon, at the top, select the View tab.
  5. Then, under the window group of command icons, choose the freeze panes command.
  6. Note- Freezing panes in Excel allows you to freeze one or more rows and/or columns so they stay stable while scrolling across the database.
  7. Freezing panes is useful when the dataset is huge and particular areas of the data must be viewed at all times.
  8. This is revealed by selecting the View tab from the ribbon. You can now navigate across the worksheet without having to worry about the freeze rows shifting.
  9. Only the frozen rows remain in their set place, while the other rows scroll up and down.
  10. The rows that you freeze will remain visible or fixed even when you scroll down the entire spreadsheet. For example, in the sample below, the top two rows do not scroll with the rest of the worksheet.

Conclusion :-

Freezing panes in Excel allows you to freeze one or more rows and/or columns so they stay stable while scrolling across the database.

Freezing panes is useful when the dataset is huge and particular areas of the data must be viewed at all times. I hope this article on how to freeze selected rows in excel helps you.

LATEST ARTICLES