Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel training courses - Excel - short cut key

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

microsoft excel training courses - Excel - short cut key

Resolved · Low Priority · Version Standard

Reply Mon 29 Oct 2007, 17:14Delegate Tina said...

Tina has attended:
Excel Introduction course

Excel - short cut key

is there a short cut key to freeze panes?

For upcoming training course dates see: Pricing & availability

Reply Thu 1 Nov 2007, 16:15Trainer Katie said...

RE: 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

Excel articles

· Interesting Things About Charts In Excel 2003
· Microsoft Excel provides the building blocks of shared information
· Customize Your Gridlines And Borders In Excel 2007
· How To Learn From Your Excel Mistakes
· Excel: Save Time With AutoFill

Excel tip:

The dual nature of toolbar buttons

Many toolbar buttons are dual purpose, though the two purposes are often linked in some way. For example, Align Left aligns a cell's contents to the left of the cell. However, hold down Shift and press the Align Left button: Excel aligns the cell contents to the right.
You may respond: So what? Well, you can reduce the number of buttons on your toolbar to make your screen less cluttered and allow more room for, perhaps, some of your own commands. After all, what's the point of an Align Right button when Shift+Align Left does the same thing?

View all Excel hints and tips