Comments on: How to freeze rows and columns in Excel

When working with large datasets in Excel, you may often want to lock certain rows or columns so that you can view their contents while scrolling to another area of the worksheet. This can be easily done by using the Freeze Panes command and a few other features. Continue reading →

Table of contents

Comments page 2. Total comments: 44

  1. Thank you so much for your life-saving tutorial. This had helped me with my job tremendously.

  2. Thanks for your help!
    It worked

  3. Thank you so much. It's very helpful and easy to understand your advice.

  4. Good tips for freeze rows and column at same time.
    Thanx

  5. Love this site. Always helps me.

  6. The freeze panes only freezes the top row now (excel 2016) so the program is getting worse.

    1. You have to use Freeze panes instead of freeze first row and coloumn.

  7. How would i freeze the 1st columns or row for an entire workbook without going through each page to do so individually?

  8. SO HELPFUL!

  9. Hi,

    thanks for the explanation.

    However, how would I freeze multiple columns (or the furthest right column) as well as the top row?

    Thank you.
    Andrea

  10. THANK YOU.

  11. Hello and thanks for the tips.

    Is there any way to send a command from cmd or power shell to freeze first row?

  12. hello,

    need some help regarding only fixing any fixed row and columns of a sheet, is it possible to do so?

    1. Hello, Shuvo,
      Thank you for contacting us.

      I'm sorry but your task is not entirely clear.Could you please describe it in more detail?

      Thank you.

  13. Thank you, clear instructions and staight to the point

  14. Thank you, clear and straight to the point.

  15. How can I freeze first row and first column at a time?

    1. Dude, i had the same Question too. what you have to do is select the
      B2 and click freeze,("make sure it's not in unfreeze" if yes click it back again") this works for me.

  16. Where would we be without freeze panes, thanks for your tips, it's definitely a good refresher.

Post a comment



Thank you for your comment!
When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to
your query. We cannot guarantee that we will answer every question, but we'll do our best :)