Thread: Stationary Row
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default Stationary Row

Select cell A6
Goto the menu WindowFreeze Panes

To undo it:
Goto the menu WindowUnfreeze Panes

--
Biff
Microsoft Excel MVP


wrote in message
...
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.