microsoft excel training courses - Excel - short cut key

Hi Tina,

Thanks for your question.

There is no shortcut for Freeze Panes, pressing [F6] can only switch between panes when window are already frozen.

Alternatively, you can record a macro.

1) Click on the cell you wish to freeze
2) Tools menu > Macro > Record New Macro
3) Name it: "Freeze"; assign a shortcut letter e.g. CTRL+Q
4) Click OK
5) Window menu > FreezePanes
6) Tools menu > Macro > Stop Recording

This assigns CTRL+Q to freeze pane wherever necessary.

Hope this is helpful.

Katie