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)
7 comments on “How to freeze top rows always on top in Excel 2013?
  1. Ina says:

    My brother suggested I might like this web site.
    He was entirely right. This post actually made my day.
    You can not imagine just how much time I had spent for this info!


    My web page getting your ex back

  2. Ruthie says:

    Hello, i think that i saw you visited my web site thus i came to “return the
    favor”.I am trying to find things to enhance my site!I
    suppose its ok to use a few of your ideas!!

    my homepage :: Text Your Ex Back Review – Ruthie -

  3. Jerilyn says:

    Fine way of telling, and pleasant article to obtain information regarding my presentation subject matter,
    which i am going to deliver in academy.

    Have a look at my page; last minute hotel las vegas specials

  4. Myrtis says:

    I do trust all of the concepts you’ve presented for your post.

    They are really convincing and will definitely work. Nonetheless, the posts are too
    brief for novices. May just you please lengthen them
    a little from next time? Thanks for the post.

    my web site … treating gout home remedy

  5. 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.

  6. Jerold says:

    I do not even know how I ended up here, but I thought this
    post was good. I do not know who you are but definitely you’re going to
    a famous blogger if you aren’t already ;) Cheers!

    My page: site (Jerold)

  7. Sebastian says:

    I visit everyday a few web sites and sites to read content,
    but this blog offers feature based writing.

    my page; teds woodworking package free download

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>