Freeze Row and Column / Lock Rows and Columns In Excel

To save an place of a worksheet visible even if you scroll to choice place of the worksheet, mount happening the View bank account, where you can Freeze Panes to lock specific rows and columns in place, or you can Split panes to make sever windows of the linked worksheet.

 

Freezing panes versus splitting panes

When you under panes, Microsoft Excel keeps specific rows or columns visible along with you scroll in the worksheet. For example, if the first choice in your spreadsheet contains headers, you might asleep that argument to make certain that the column headers remain visible as you scroll all along in your spreadsheet.

 

 

A solid pedigree out cold clash 1 indicates that the argument is asleep to keep column headers in place considering than you scroll.

Splitting panes is a variation concerning freezing panes, in that taking into account you split panes, Excel creates either two or four cut off worksheet areas that you can scroll within, even though rows or columns in the non-scrolled place remain visible.

 

 

 

 

Freeze rows or columns

Before you choose to freeze rows or columns in a worksheet, it’s important to consider the following:

  • You can under on your own rows at the peak and columns concerning the left side of the worksheet. You cannot out cold rows and columns in the center of the worksheet.
  • The Freeze Panes command is not closely when you regarding in cell editing mode (that is, you’re speaking entering a formula or data in a cell) or following a worksheet is protected. To dissolve cell editing mode, press Enter or Esc.

 

Freeze the top row and the first column at the same time

To freeze the top row and the first column at the same time, click the View tab > Freeze Panes > Freeze Panes.

 

 

Freezing top row and first column

Freeze the top row

Freezing top row

Notice that the border under row 1 is a little darker than other borders, meaning that the row above it is frozen.

 

The first row is locked when you click Freeze Top Row

 

Freeze the first column

If you’d rather freeze the leftmost column instead, click the View tab > Freeze Panes > Freeze First Column.

Freezing first column

Now, the line to the right of column A is a little darker than the other lines, meaning that the column to its left is frozen.

The first column is locked when you click Freeze First Column

Unfreeze rows or columns

  • On the View tab > Window > Unfreeze Panes.

    Unfreeze Panes

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Share This Post

14 comments

  • very cool post, i actually like this web site, carry on it

  • Wonderful work! That is the kind of info that are meant to be shared around the internet. Disgrace on the search engines for no longer positioning this put up upper! Come on over and consult with my web site . Thank you =)

  • You really make it seem so easy with your presentation but I find this matter to
    be actually something that I think I would never understand.
    It seems too complex and very broad for me. I am looking forward for your next
    post, I’ll try to get the hang of it!

  • Hey there! Do you use Twitter? I’d like to follow you if that would be okay.
    I’m definitely enjoying your blog and look forward to new updates.

  • I am genuinely thankful to the owner of this web page
    who has shared this great paragraph at here.

  • Everyone loves it when individuals come together and share ideas.

    Great website, stick with it!

  • I am curious to find out what blog system you’re using?

    I’m experiencing some minor security problems with my latest blog and I’d
    like to find something more safe. Do you have any recommendations?

  • Howdy! This blog post could not be written much better!
    Looking through this post reminds me of my previous
    roommate! He constantly kept preaching about
    this. I am going to send this post to him. Pretty sure he will have a
    good read. Thank you for sharing!

  • I do believe all the ideas you have offered in your post. They are very convincing and can certainly work.
    Nonetheless, the posts are very brief for newbies. Could you please lengthen them a bit from subsequent time?
    Thank you for the post.

  • Hello there, just became aware of your blog through Google, and found that it is truly
    informative. I am going to watch out for brussels. I’ll appreciate if you continue this in future.

    A lot of people will be benefited from your writing.
    Cheers!

  • This piece of writing will help the internet visitors
    for setting up new website or even a blog from start to end.

  • Greetings! This is my first comment here so I just wanted to give
    a quick shout out and say I truly enjoy reading your posts.
    Can you recommend any other blogs/websites/forums that cover
    the same topics? Appreciate it!

  • continuously i used to read smaller posts which also clear their motive, and that
    is also happening with this paragraph which I am reading
    here.

  • Everything is very open with a very clear description of
    the issues. It was definitely informative. Your website is very helpful.
    Thanks for sharing!

Leave a Reply

Your email address will not be published.