freezing frames
 

For some reason I can't freeze frames properly. I know how to freeze frames
generally, but whenever I do, it still freezes the first 14 rows instead of
just the top row. I have unprotected the entire worksheet and unfroze the
entire worksheet.

I'm using XP Home with Excel 2000 9.0

Thanks,

Bob

freezing frames
 

Assume you mean freeze "Panes".
Select a cell in column A just below where you want the
freeze to occur. That would be cell A2 to freeze row 1.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"Bob Griendling"
wrote in message
For some reason I can't freeze frames properly. I know how to freeze frames
generally, but whenever I do, it still freezes the first 14 rows instead of
just the top row. I have unprotected the entire worksheet and unfroze the
entire worksheet.
I'm using XP Home with Excel 2000 9.0
Thanks,
Bob

freezing frames
 

See if this old post helps:

http://tinyurl.com/2qdzt

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Bob Griendling" wrote in message
...
For some reason I can't freeze frames properly. I know how to freeze frames
generally, but whenever I do, it still freezes the first 14 rows instead of
just the top row. I have unprotected the entire worksheet and unfroze the
entire worksheet.

I'm using XP Home with Excel 2000 9.0

Thanks,

Bob

freezing frames
 

To Freeze Panes(not frames), you have to select a cell one row below and one
column right of where you wish to Freeze.

If you select A1 your Freeze will come at mid-window. You don't want that.

To freeze row 1 select A2

To freeze row 1 and column A select B2


Gord Dibben MS Excel MVP

On Sat, 1 Jul 2006 17:21:47 -0400, "Bob Griendling" wrote:

For some reason I can't freeze frames properly. I know how to freeze frames
generally, but whenever I do, it still freezes the first 14 rows instead of
just the top row. I have unprotected the entire worksheet and unfroze the
entire worksheet.

I'm using XP Home with Excel 2000 9.0

Thanks,

Bob

freezing frames
 

"Just below"....That was my problem; I was highlighting the row I wanted to
freeze. Thanks, guys.

Bob
"Jim Cone" wrote in message
...
Assume you mean freeze "Panes".
Select a cell in column A just below where you want the
freeze to occur. That would be cell A2 to freeze row 1.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"Bob Griendling"
wrote in message
For some reason I can't freeze frames properly. I know how to freeze
frames
generally, but whenever I do, it still freezes the first 14 rows instead
of
just the top row. I have unprotected the entire worksheet and unfroze the
entire worksheet.
I'm using XP Home with Excel 2000 9.0
Thanks,
Bob