Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
freeze panes not an option
I can split panes in Excel 2007 but "Freeze Panes" does not highlight as an
option in the View/Window menu. Help. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
freeze panes not an option
You can either split the pane OR freeze the pane - you can't do both
simultaneously. "Chief Pasanga" wrote: I can split panes in Excel 2007 but "Freeze Panes" does not highlight as an option in the View/Window menu. Help. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
freeze panes not an option
Hi,
By "not an option" you mean Freeze Panes is grayed out? First, when you want to freeze panes, it is not necessary to split screen first, in fact that step is a waste of time, go directly to freeze panes. Second, yes you can not have both freeze panes and split screen active at the same time, but Freeze Panes is still active (an option) when split screen is on. Third, if freeze panes is not available check to make sure 1. If the worksheet is Protected. 2. If the workbook protection is on. 3. If you are in Edit mode. If these help, please click the Yes button Cheers, Shane Devenshire "Chief Pasanga" wrote: I can split panes in Excel 2007 but "Freeze Panes" does not highlight as an option in the View/Window menu. Help. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
freeze panes not an option
Maybe it's the same complaint I have. I want to freeze everything above and
to the left of cell 'E4' so that I can scroll all the way to the right and/or down and still see those first 4 columns and top 3 rows, as I was able to do in Excel 2003. Thank you, Bernard "Shane Devenshire" wrote: Hi, By "not an option" you mean Freeze Panes is grayed out? First, when you want to freeze panes, it is not necessary to split screen first, in fact that step is a waste of time, go directly to freeze panes. Second, yes you can not have both freeze panes and split screen active at the same time, but Freeze Panes is still active (an option) when split screen is on. Third, if freeze panes is not available check to make sure 1. If the worksheet is Protected. 2. If the workbook protection is on. 3. If you are in Edit mode. If these help, please click the Yes button Cheers, Shane Devenshire "Chief Pasanga" wrote: I can split panes in Excel 2007 but "Freeze Panes" does not highlight as an option in the View/Window menu. Help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 freeze panes won't freeze top row only | Excel Discussion (Misc queries) | |||
Freeze panes | Excel Discussion (Misc queries) | |||
Excel should have a second 'Freeze Panes' option that works in re. | Excel Discussion (Misc queries) | |||
freeze panes | Excel Worksheet Functions | |||
There is no freeze/unfreeze panes option in the windows menu | Excel Worksheet Functions |