microsoft excel training courses - Excel - short cut key

The UK's most regular instructor-led training courses.
Training information: microsoft excel training courses · Excel training london · Microsoft Excel Training
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Excel - short cut key

Tina has attended:
Excel Introduction course

by - delegate Tina [1 post] (2007 Oct 29 Mon, 17:14) Reply

is there a short cut key to freeze panes?

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2009 Jan 9 Fri	Bloomsbury	1	book now	£240	£245
2007	2009 Jan 14 Wed	Bloomsbury	5	book now	£235	£245
2002/XP	2009 Jan 14 Wed	Tooting	0	FULL
2003	2009 Jan 16 Fri	Southwark	0	FULL
2007	2009 Jan 21 Wed	Bloomsbury	3	book now	£240	£245
2003	2009 Jan 21 Wed	Southwark	2	book now	£235	£240
Full Schedule: See all 114 Excel Advanced course dates. Bookings currently available until 31st March 2010.

RE: Excel - short cut key

by - trainer Katie gold contributer [214 posts] (2007 Nov 1 Thu, 16:15) Reply

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

· Crazy Things People Have Done With Excel
· Microsoft Office and the Small Business: Part 1 Excel
· Excel in the Home Office
· Training Budgets In A Bad Economy
· Benefits of learning about Excel charts

Excel tip:

Formst Excel to display leading zeroes

Select the cells that you want to have displaying leading zeroes.

From the 'Format' menu select 'Cells' (Or Right-click on the selected range and and select 'Format Cells').

In the 'Number' tab click on 'Custom' in the 'Category' window.

In the 'Type:' box enter zeroes that correspond to the size of the required number (eg 5 zeroes).

Click OK.

When you enter numbers into these cells, leading zeroes will be displayed.

eg 123 = 00123

View all Excel hints and tips

Rate this page: