*NEVER* invoke "Freeze Panes" when the cell in the "A1 Position" is
selected.

Picture a newly opened sheet.
The top, left cell is A1.

Click in A6, then,
<Window <Freeze Panes

You'll see that rows 1 to 5 are frozen ... all well and good!

Now, unfreeze them:
<Window <Unfreeze Panes

Click in A6.

Using the scroll bar on the right, scroll down 5 rows so that A6 is in the
"A1 Position" (top left).

Then:
<Window <Freeze Panes

You see what happens?
That's probably your problem.

Unfreeze the panes.

With A6 in the "A1 Position", click in A7, then freeze panes.
All should be OK now, *BUT* you'll notice that you *can't* display above Row
6.

This is a good procedure to keep headers and/or logos hidden so that more
screen real estate can be utilized,
And at the same time, *allows* these rows to still print (truly hidden rows
*don't* print).

Don't forget ... *never* invoke Freeze Panes when the cell in the A1 screen
position is selected!
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------


"lexiacsi" wrote in message
...


"Gord Dibben" wrote:

The rule for freezing panes is.....

Columns to left of and rows above the selected cell will be frozen.

Do not select row 1 to freeze row 1. As you have seen, it will freeze
panes
in mid-window.

Select A2 to freeze row 1

Select B2 to freeze row 1 and column A


Gord Dibben Excel MVP

On Wed, 30 Mar 2005 13:59:05 -0800, emilyp

wrote:

I've tried highlighting the row I would like to freeze, usually just
the
first row, but it always freezes it after the 16th row. Any
suggestions!?
This is really frustrating!