Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel freeze pane

Excel freeze pane

ResolvedVersion 2003

Fri 2 May 2008, 17:00 Delegate Peter said...

Peter has attended:
Excel Introduction course

Excel freeze pane

how do you make a freeze pane

Sun 4 May 2008, 16:13 Trainer Cress said...

RE: Excel freeze pane

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

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Repeating headings on spreadsheets that print on more than one page

By default when you print a spreadsheet out and it prints on more than one page, the headings at the top and the side of the spreadsheet don't appear on all the pages following page 1.

To get Excel to repeat headings on all pages when printing, go to File - Page Setup - Sheet, then select the rows to repeat at the top of pages, and the columns to repeat at the side of pages by clicking on the red arrows at the right side of the two boxes under the 'Print titles' area. Then click OK.

If you view your spreadsheet in Print Preview, you should see the headings being repeated on each page.

View all Excel hints and tips

Excel freeze pane

Excel freeze pane

RE: Excel freeze pane

Excel articles

Excel tip:

Repeating headings on spreadsheets that print on more than one page