ExcelFreezePanes shoud work horizontially and vertically together

[Guest]

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/com...dg=microsoft.public.excel.worksheet.functions

 

[Guest]

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

 

[Chip Pearson]

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


in message
news:[email protected]...