Excel freeze pane

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

Resolved · Medium Priority · Version 2003

Excel freeze pane

Peter has attended:
Excel Introduction course

by - delegate Peter [1 post] (2008 May 2 Fri, 17:00) Reply

how do you make a freeze pane

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course				List price £225
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 May 19 Mon	Bloomsbury	0	FULL
2003/XP	2008 May 20 Tue	Tooting	0	FULL
2003/XP	2008 May 20 Tue	Bayswater	1	book now	£195	£205
2003/XP	2008 May 22 Thu	Bloomsbury	7	book now	£188	£215
2003/XP	2008 May 29 Thu	Southwark	4	book now	£207	£215
2003/XP	2008 Jun 3 Tue	Bayswater	5	book now	£198	£215
Full Schedule: See all 169 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: Excel freeze pane

by - trainer Rich platinum contributer [610 posts] (2008 May 4 Sun, 16:13) Reply

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

· Microsoft Excel Training: Not Just for Newbies Anymore
· An Introduction to Microsoft Excel: Top Features for the Excel Novice
· 3 Reasons why Your Small Business Office Needs Microsoft Excel Training
· 3 Reasons Why Excel Training Courses For Employees Can Improve Your Business
· How to Create Better Excel Spreadsheets: Part Four

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

Excel tip:

Generate randon numbers

Some types of analysis require you to use randomly generated numbers. You can also use randomly generated numbers to quickly populate an Excel spreadsheet. There's an easy function you can use to do this automatically. Here are a few of the ways you can use it:

Type =RAND() in a cell to generate a number between 0 and 1.
Type =RAND()*100 to generate a number between 1 and 100.

View all Excel hints and tips

Institute of IT Training - Accredited Training Provider

secure online payments - visa - mastercard

Mini sitemap. These are the main areas of our web site. Full sitemap.

Training by application

Main information pages

Excel freeze pane

Related articles

Excel tip:

Generate randon numbers