Freeze panes using shortcut keys

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

Thank u

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

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...

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.