excel training courses - Freeze Panes

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

Resolved · Low Priority · Version Standard

Freeze Panes

Cindy has attended:
Excel Introduction course

by - delegate Cindy [1 post] (2007 Mar 1 Thu, 15:16) Reply

How do I Freeze panes?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2002/XP	2008 Aug 29 Fri	Tooting	0	FULL
2003	2008 Sep 2 Tue	Bloomsbury	3	book now	£210	£215
2003	2008 Sep 4 Thu	Bayswater	4	book now	£195	£205
2007	2008 Sep 4 Thu	Bloomsbury	0	FULL
2003	2008 Sep 9 Tue	Bloomsbury	4	book now	£207	£215
2002/XP	2008 Sep 9 Tue	Tooting	0	FULL
Full Schedule: See all 138 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: Freeze Panes

by - trainer Tracy platinum contributer [586 posts] (2007 Mar 2 Fri, 10:28) Reply

Hi Cindy,

To freeze panes you are freezing everything to the left of your cursor and everything above you cursor. So if you want to keep rows 1 and 2, click on the row heading 3 and go into Window and down to Freeze Panes. If you wanted to keep column A click in the column heading B and go to Windows, Freeze Panes. If however, you wanted to do both rows 1 and 2 and column B, all you would need to do is put your cursor in cell B3.

Good luck and I hope that helps

Tracy

· Creating Smarter, Customized Invoices for your Small Business with Microsoft Excel
· 5 Microsoft Excel Charts for Creating Stunning Business Documents
· MS Excel: Excel At Making The Most Of Your Christmas
· Microsoft Excel Training Course
· What's Better Than the Help Function in Excel? Microsoft Training