• 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

    Hui...

  • 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

kedenham

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.


Kate
 

oldchippy

Active Member
Hi,


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


http://www.bettersolutions.com/excel/EDO113/NE215138332.htm


or put a Watch window like this


http://www.mrexcel.com/Excel_Watch_Window_training.html


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
 
Top