Stationary Row

M

ma740988

Lets assume row 5, column A contains some important title. How do I
keep a row 5 stationary such that when the user scrolls down rows 6
through XX (where XX is some number up to max) will slip under (or at
least so it seems) row 5?

I've seen this done but I'm not sure how to do this.
 
T

T. Valko

Select cell A6
Goto the menu Window>Freeze Panes

To undo it:
Goto the menu Window>Unfreeze Panes
 
Top