Excel 07 - Freeze and unfreeze pane

Hi Anil...

Freeze Pane option is in "View".

The attached file should help..

Hi

The Freeze panes option comes under Window menu. You have to select the Cell which needs to be the master cell or the Row/Column for freezing.

Screen shots in attached file

Sir...

You right when it comes to Excel2003... But in Excel 2007 its under View Menu. Please correct me if I am wrong.

Thanks in advance..

Thank you very much sir. It is clear.

Regards,

Anil.

Hi Skand,

You are right. However even in Excel 2007 you can use the Alt+W option to activate window menu though it appears it the extended menu toolbar in View.

Rgds

Hello Sir...

Thanks for the information  :-)

u can download file format convertor by which u can have similar menu option as in previuous versions of excel along with menu of excel 2007 with  all other things remianing same.

Hey...you can all the shortcuts related to MS Excel in my file 'Excel Shortcuts - Useful for Articles'.........

There are some trial version softwares available on net

by them u can insert office 2003 toolbar in office 2007

https://www.accmsoft.com/office-2007/classic-style-menus-toolbars/

Type this key combinations....

ALT+W+F+F

You will get freeze panes.....

You may download Free Addins Office Menu-2003 for Office-2007 from this forum's  Files section or from below page.

https://in.geocities.com/shahshaileshs/menuaddins



Shailesh

Simply type this combination and you will find freeze panes.

ALT + W + F for freeze panes and ALT + W + F again for unfreeze panes.