Show the top left cell that you always want to see (probably A1).

Select the cell in the row under the last row you want frozen and to the right
of the last column you want frozen.

Then Window|Freeze Panes

For instance, if I always wanted to see Rows 1 and 2 and columns A and B, I
would make sure I could see A1 first.

Then select C3, then window|freeze panes.

morisn wrote:
>
> Hello. I've seen this before but cannot figure out how to do it myself.
> I would like to have a way to leave the title bar of an Excel 2002
> spreadsheet fixed in the same position as I scroll down the rest of the table
> without using the split bar above. I don't know if this requires macros or
> not, but have tried the help feature and search in the MS knowledge base
> without success.
> Anyone can help?
> Thanks
> Oscar M.

--

Dave Peterson