Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why is Computer Freezing With Excel? | Excel Discussion (Misc queries) | |||
Excel program keeps freezing | Excel Discussion (Misc queries) | |||
Have you had a problem with Auto Filter freezing? | Excel Discussion (Misc queries) | |||
Freezing panes | Excel Discussion (Misc queries) | |||
Freezing one cell | Excel Worksheet Functions |