I want to keep the two top rows always on top in my Excel file. How can I do that in Microsoft Excel 2013?
Yep, most of the time working with table, we want to keep one or more row on top for easily tracking or viewing. It is not only on paper work but also on Microsoft Excel sheet. These row can be your data sheet header or not. Microsoft Excel provide a function named Freeze Panels for you to freeze top rows.
To freeze your two top rows, you can do a simple trick follow these simple steps to freeze top rows:
Step 1. Look at the left edge of Excel window, you can see a column with increasing numbers. This indicates your row number. Move your mouse over the number three and then click left mouse button. This action will select all of the third row.
Step 2. Then, move to the Ribbon bar, try to find the VIEW tab at the right side. Click on VIEW tab of Ribbon Bar to see all the commands in it. Click on button Freeze Panels at the right side of tab VIEW.
Step 3. In the drop-down list box, we have three options to choose. It includes Freeze top row and Freeze First Column for fast action. This is also the frequent action users always do with Excel sheet. The third option is Freeze Panels, that is what you need. Click on that option.
Step 4. After that, you can see a darken line below second row. This indicates that the first two rows are freeze and always on top when you scrolling down.
That’s so damn easy, right!