How to freeze top rows always on top in Excel 2013?

I want to keep the two top rows always on top in my Excel file. How can I do that in Microsoft Excel 2013?

nguyen's answer

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.

freeze-top-rows-on-top-excel-2013 step 1 image

 

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.

freeze-top-rows-on-top-excel-2013 step 2 image

 

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.

freeze-top-rows-on-top-excel-2013 step 3 image

 

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.

freeze-top-rows-on-top-excel-2013 step 4 image

That’s so damn easy, right!

Let's stay in touch!
Sign up here and you'll receive even more tech and gadget help right to your inbox, along with exclusive news and industry updates.
Category: Microsoft Office   (Answered Hai Nguyen)
Tag:
Previous:
Next:
One comment on “How to freeze top rows always on top in Excel 2013?
  1. Glenda says:

    Upper management to a great degree has even been relegated to a role of a figurehead trying
    to find out its real purpose – all the while giving it large raises and bonuses.

    o How do you design for a group and evaluate the use of groupware
    - social dynamics. The GNOME HIG is a standard set of rules that all GNOME apps should follow to be
    more intuitive, easy to use, and easy to understand.

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>