MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Freeze panes using shortcut keys


Posted by RajaGopal on December 26, 2001 8:42 PM

How do i freeze panes using keyboard short cut keys .Please guide me


Posted by Jacob on December 26, 2001 8:59 PM

Hi

I'm not sure if there is a shortcut already set up to do this, but you can take a look in the Excel help contents under keyboard shortcuts.

We can however do this with vb.

Make a macro and addign it a shortcutkey

then in the module code put this

sub freezeit()
ActiveWindow.FreezePanes = True
end sub

This will freeze the panes whereever the current selected cell is whenever you activate the shortcut.

Hope this helps

Jacob

Posted by RajaGopal on December 26, 2001 9:10 PM

Thank u

Yea there is no shortcut defined already anyways will try ur option Jacob

Posted by More Beer!!! on December 26, 2001 10:10 PM

Macro works, but can't undo...

Jacobs macro will work, but I don't think you can "undo" it if you click in the wrong spot, or if you change your mind later. You can, however, create a button on your taskbar that will let you freeze the panes and then unfreeze them by clicking this button.
Here is how you create such a button:

1) Right click on the toolbar and then click customize
2) Click the Commands tab
3) Under Categories, click Window & Help
4) Click and Drag the Freeze Panes Icon onto your toolbar
5) Hit close and you're done...

Posted by Jim on December 27, 2001 5:37 AM

I just use alt-w-f

It's quick and I find it easier than fiddling with shortcut buttons and no VBA needed. It's also the same to unfreeze. But everyone has their favourite way I guess.