Static left hand side column and static header row.. how?

Im trying to design a custom organiser in excel and one thing is bugging me. What I want is a column down the left and a row across the top that never move.

When I use freeze panes I cant get it exactly as I want it. Its pretty much like a website with frames.. with the left hand column and the header staying static.

Like so..

http://i114.photobucket.com/albums/n...tore/excel.jpg


Can anyone put me out of my misery???

If row 1 is you your static row and column A is your static column, place your cursor cell B2 and choose Freeze Panes. This will give you the desired result.

Originally Posted by no dice

If row 1 is you your static row and column A is your static column, place your cursor cell B2 and choose Freeze Panes. This will give you the desired result.

Row 1 will only stay static if the data is moved up and down..

I need row 1 to stay static if the sheet is being moved up and down OR left or right.. as in truly static no matter what way I move the sheet.

Sorry for the confusion

Ah... gotcha. Sorry, we've just passed my level.