This blog is about Microsoft Excel and includes tutorial videos demonstrating how to get things done easily using Excel. And this blog also proves you that Microsoft Excel simply is the best part of Microsoft Office and maybe the most powerful software ever made.
It is sometimes annoying when scrolling in big Excel table because you may not know what data the current row or column should contain. E.g. when each row represents one person's data, it is difficult to analyse data if you have scrolled so that you cannot see the name column and don't know to who current row belongs and what is the title of the current column.
Excel has (of course :-)) a solution for this. It is a feature called Freeze Panes and with it you can make selected topmost rows and leftmost columns always visible.
Following example video demonstrates the feature (Tip: If you have difficulties to see the video, try to maximise it from lower right corner):
