Excel 07 - Freeze and unfreeze pane

Where in excel 07 , one can find buttons for freezing and unfreezing ?

Thanks

 

Replies (12)

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

 

Originally posted by :CA.Srinivasan N
" 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.....

Originally posted by :Praveen Kumar
" 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/

 

 
"

 

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.

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
20 November 2026
Charted Accountant

Cothas Coffee Co.

Bengaluru

CA

View Details
Company
02 November 2026
Audit Executive

SRJP & Co LLP

Kochi

CA Inter

View Details
Company
Featured ARTICLESHIP 18 November 2026
Articles

Saini Pati Shah & Co LLP, Chartered Accountants

Mumbai

CA Foundation

View Details
Company
Featured ARTICLESHIP 31 October 2026
CA Articleship

apricus india

Navi Mumbai

CA Inter

View Details
Company
16 November 2026
Indirect Tax Associate

Sekhri Kanodia & Associates

Mumbai

B.Com

View Details
Company
21 November 2026
Asst. Manager / Deputy Manager

Aco Perfumes & Cosmetic Pvt Ltd

Mumbai

CA

View Details
Company
ARTICLESHIP 17 November 2026
Vacancy for Articleship

Promptitude Accounting Services Private limited

Bengaluru

B.Com

View Details
Company
16 November 2026
Assistant Article

ZAK & Co. Chartered Accountants

Bengaluru

CA Inter

View Details