How to freeze rows in Excel | Freeze Column in Excel

How to Freeze row and column in Microsoft Excel? is one of the most used and useful while working on large data as well as while making a dashboard. To freeze panesfreeze rowsfreeze columns and freeze cells you can follow the tutorial below.

How to freeze rows in Excel?

  • Select a cell for which every row or column preceding that cell will freeze.

    A CHEATSHEET that Solve your EXCEL Problems
    • eBook • Get Excel VBA Automation Course and Outlook Course as FREE • Lifetime Access
  • Go to View Tab

    how to freeze rows and columns at the same time in excel 2013


  • Then click on the options you want to select.

    how to freeze both rows and columns in excel

    Excel Power Users Ebook

    Be Smart at Excel | New Skills for New JOB

    This eBook will help you to get Excel Skills & Boost your career

    Finally, you will notice a dark line indicating that you have selected frozen row and frozen column.

    how to freeze panes in excel 2007

    • Get Excel VBA Automation Course and Outlook Course as FREE • Lifetime Access • eBook

Note that under the Freeze Panes command, you can also choose

“Freeze Top Row,” which will freeze the top row that’s visible in your spreadsheet. Top row will also become the header row if you have headers in the topmost row of the spreadsheet. 

“Freeze First Column,” which will keep the leftmost column visible when you scroll horizontally.

So with this blog, you must have learn how to freeze row and column in excel as well as how to freeze row and column simultaneously. To learn more about how to remove password from excel or you can learn text to column in Excel 

Found this interesting? Check out this blog on Excel Security

I hope you found our article useful. Further, if you any doubts or questions regarding this article, feel free to post them in the comment section below. Want to learn more smart tricks in excel?