Excel intro

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

Resolved · Low Priority · Version Standard

Excel intro

Lia has attended:
Excel Introduction course

by - delegate Lia [2 posts] (2008 Mar 6 Thu, 09:34) Reply

How do I use freeze and unfreeze of window panes?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 8 Mon + 9 Tue	Bayswater	2	book now	£495	£495
2003	2008 Sep 18 Thu + 19 Fri	Bloomsbury	1	book now	£495	£495
2003	2008 Sep 25 Thu + 26 Fri	Southwark	3	book now	£475	£495
2003	2008 Oct 6 Mon + 7 Tue	Bayswater	4	book now	£475	£485
2007	2008 Oct 13 Mon + 14 Tue	Bayswater	3	book now	£475	£495
2003	2008 Oct 23 Thu + 24 Fri	Southwark	4	book now	£475	£485
Full Schedule: See all 44 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Excel intro

by - trainer Rich platinum contributer [713 posts] (2008 Mar 9 Sun, 10:58) Reply

Hi

If you go to Window and Freeze Panes then it will freeze the first row and a few columns. If you scroll down or across these will always be set. If you have a list of 5000 rows and you are on row 3904 then you might want to see what the values relate to and you can because the headings are still visible. If you want just the headings to freeze then click on the little rectangle just above the right hand scroll bar and drag it onto the sheet just below the column headings. This will freeze them

thanks
Rich

· How to check for and reduce errors in Microsoft Excel
· Compare Different MS Excel Training Methods
· How to Create Better Excel Spreadsheets: Part One
· Crazy Things People Have Done With Excel
· Advanced level training: Microsoft Excel and the Web

Please browse our web site to find out more about
excel-courses and other Microsoft training courses.

Excel tip:

Quickly copy a formula across sheets

Suppose you have a formula in cell Sheet1!B2, say =A1*5%, that you wish to copy to cell B2 on Sheet2, Sheet3 and Sheet4. Instead of using copy and paste, try this: (1) Select Sheet1!B2. (2) Group Sheet1 with the worksheets Sheet2, Sheet3 and Sheet4 by holding down Ctrl and clicking on the tabs of the sheets to group them. (3) Press the F2 key, then immediately press Enter to copy the formula in Sheet1!B2 across the grouped sheets.

Remember to ungroup the sheets afterwards! Right-click on any tab and choose Ungroup Sheets to do that.

View all Excel hints and tips