• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Backwards freeze panes


New Member
Hi -

I was wondering if its possible within excel to do a 'backwards' freeze pains - so that the cells at the bottom stay the same if you scroll up and down?

Have been told Windows Split may help but I'm not sure how this works.



Active Member

You can't freeze the bottom rows, but what you can do is split panes like this


or put a Watch window like this


or open another Window of the same workbook so that you have 2 versions of the same workbook open at the same time then go to Arrange and pick Vertical or Horizontal