The Freeze Panes is an excellent feature - However when reviewing large files
Excel should be capable to Freeze panes both on a Column and a Row (
Horizontally / Vertically ) Today you can only choose one option.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions

Actually, it DOES work on both. Select cell C4 and then Window | Freeze
Panes and you'll see horizontal AND vertical lines appear.

"Lawrence Crook" wrote:

The Freeze Panes is an excellent feature - However when reviewing large files
Excel should be capable to Freeze panes both on a Column and a Row (
Horizontally / Vertically ) Today you can only choose one option.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions

It does work both horizontally and vertically together. Select,
for example, G10, and then Freeze Panes.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Lawrence Crook" <Lawrence wrote
in message
...
The Freeze Panes is an excellent feature - However when
reviewing large files
Excel should be capable to Freeze panes both on a Column and a
Row (
Horizontally / Vertically ) Today you can only choose one
option.

----------------
This post is a suggestion for Microsoft, and Microsoft responds
to the
suggestions with the most votes. To vote for this suggestion,
click the "I
Agree" button in the message pane. If you do not see the
button, follow this
link to open the suggestion in the Microsoft Web-based
Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions