how to freeze first two rows in excel 2010

There are various ways to freeze cells in excel. Freeing in excel will turn some cells (rows and / or columns) to be stagnant and these cells would not change if you move left or right or scroll up or down. In this post we are going to help you on how to freeze rows or columns in excel. But don’t worry we are here to help you out. All of this happens because your header or first row is not fixed and keeps changing as you scroll down. If you are using a 15-inch laptop to do this, then as soon as you go to the 25 th row or later you lose the context of which column is for which subject. Now, you have to collate their marks in every subject in an excel. Panes.Just assume you are school teacher and have around 90 students in a class which is divided into various sections. You highlight a column, and then choose to freeze Note: You can also freeze frames to the left if The cells above the row you highlighted will be frozen. In Excel 2011, select the Window menu, and then Freeze Panes. Select Freeze Panes from the 'Window' group. Highlight the row below the rows you wish to keep visible.The screen will split at the point where you highlighted the row. In Excel 2011, select the Window menu, and then Split. In Excel 20, from the View tab on the Ribbon,.Highlight the row below the rows you wish to remain visible.Note: This option allows you to scroll through the Rows of a Microsoft Excel spreadsheet visible as you scroll You have two options for keeping the labels in the first few Information here may no longer be accurate, and links may no longer be available or reliable. This content has been archived, and is no longer maintained by Indiana University.

How to freeze first two rows in excel 2010