microsoft excel courses in london

microsoft excel courses in london - Freeze row

Resolved · Low Priority · Version Standard

Freeze row

Catherine has attended:
Excel Introduction course

by - delegate Catherine [1 post] (2007 Feb 12 Mon, 16:24) Reply

How do I freeze a row at the top of my worksheet to be able to scroll down the rest of the worksheet when it is a long one?
Thanks

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Dec 11 Thu + 12 Fri	Bayswater	3	book now	£525	£545
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	7	book now	£450	£475
2003	2009 Jan 22 Thu + 23 Fri	Southwark	4	book now	£475	£485
2003	2009 Jan 29 Thu + 30 Fri	Bayswater	5	book now	£450	£485
2007	2009 Feb 5 Thu + 6 Fri	Bloomsbury	7	book now	£450	£475
2003	2009 Feb 19 Thu + 20 Fri	Southwark	8	book now	£275	£399
Full Schedule: See all 33 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Freeze row

by - trainer Tracy platinum contributer [586 posts] (2007 Feb 13 Tue, 12:11) Reply

Hi Catherine,

To freeze your data at the top of your worksheet you need to highlight the row below the row you want to freeze then you go into the menu bar Window - Freeze Panes. By doing this you can scroll down leaving the title in place.

Good luck

Tracy

· Microsoft Excel Training Courses or Consultants: Which Is Better For Your Company?
· MS Excel: Excel At Making The Most Of Your Christmas
· Excel Course Tips and Tricks to Liven Up Your Excel Spreadsheets
· Advanced Excel Training - takes you to the next level
· Creating Smarter, Customized Invoices for your Small Business with Microsoft Excel

Excel tip:

Freeze Rows and Columns to keep lables displayed

You can freeze rows and columns in your worksheet so they don't move.

This allows you to keep row and column labels displayed on your screen as you move through a large worksheet.

Click below and/or to the right of the cell(s) you want to freeze. (NB. Excel freezes ALL the rows above and ALL the columns to left of the selected cell)

Click on the 'Windows' menu and selct 'Freeze Panes'.

Lines appear in your worksheet. The required rows and columns are frozen and remain on your screen as you move through your worksheet.

To unfreeze rows and columns, click on 'Window' menu and select 'Unfreeze Panes'.

View all Excel hints and tips

Rate this page: