View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default locked rows on top and bottom

You can freeze rows on top and lock any cells; but freezing bottom rows is
not possible.

If this post helps click Yes
--------------
Jacob Skaria


"TPearls" wrote:

I am using Excel 2003.
I would like to have 2 rows at the top of my excel sheet frozen and 7 at the
bottom. In between I would like to have 40 rows, but only 10 shown at a time
(so there would be a scroll bar for just those rows). Is this possible?
Thanks