JJ in LA -

In Excel 2007, on the View ribbon, if the worksheet does not have any frozen
panes, the three Freeze Panes options are Freeze Panes (both rows and
columns), Freeze Top Row, and Freeze First Column.

If the worksheet does have a frozen pane or panes, the three Freeze Panes
options are Unfreeze Panes, Freeze Top Row, and Freeze First Column.

- Mike

http://www.MikeMiddleton.com



"JJ in LA" wrote in message
...
Only the 3 options listed above have any effect. How do you make the Rows
and Columns option work together? Clicking on Freeze Panes only opens up
the
three choices and nothing else

"Jon Peltier" wrote:

On the View tab, find the Freeze Panes dropdown (in the Windows group).
The
first option, Freeze Panes, freezes the rows above the active cell and
the
columns to the left of the active cell.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"Darlene" wrote in message
...
the options in 2007 are difference from 2003...2003 will allow you to
chose a
column of cell...
2007 only gives you 3 options:
1-freeze top column
2-freeze first column
3-unfreeze

does anyone know 2007 freeze frame, additional options for freezing the
second column from the top?
Darlene