Wednesday, 13 February 2013

How to use Excel's Freeze Panes -feature

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):

No comments:

Post a Comment