Where in excel 07 , one can find buttons for freezing and unfreezing ?
Thanks
Skand Kamat
(Student)
(197 Points)
Replied 31 May 2009
Hi Anil...
Freeze Pane option is in "View".
The attached file should help..
CA CS CMA Srinivasan N
(ACA, ACS, CWA Inter)
(1172 Points)
Replied 31 May 2009
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
Skand Kamat
(Student)
(197 Points)
Replied 31 May 2009
| 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..
CA CS CMA Srinivasan N
(ACA, ACS, CWA Inter)
(1172 Points)
Replied 01 June 2009
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
CA.Nikhil Gupta
(PRACTICE)
(768 Points)
Replied 01 June 2009
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.
Ankit Bhandari
(Article Assistant)
(71 Points)
Replied 01 June 2009
Hey...you can all the shortcuts related to MS Excel in my file 'Excel Shortcuts - Useful for Articles'.........
PRAVEEN KUMAR
(MBA (Finance) B.Com.(P))
(3443 Points)
Replied 02 June 2009
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/
GaUrAv
(C.A. and MOS)
(574 Points)
Replied 03 June 2009
Type this key combinations....
ALT+W+F+F
You will get freeze panes.....
Shailesh
(accounts & Excel VBA)
(342 Points)
Replied 06 June 2009
| 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
GaUrAv
(C.A. and MOS)
(574 Points)
Replied 15 June 2009
Simply type this combination and you will find freeze panes.
ALT + W + F for freeze panes and ALT + W + F again for unfreeze panes.
CAclubindia
