Forum home » Delegate support and help forum » Microsoft Excel Training and help » Freeze Pane

Freeze Pane

ResolvedVersion 2003

Wed 14 Apr 2010, 14:43 Delegate Kadri said...

Kadri has attended:
Excel Advanced course

Freeze Pane

Hi,

how can I only freeze one row (heading row)?
When I select the row and go Window\Freeze Pane it freezes about half of the page.

Thanks

Wed 14 Apr 2010, 16:54 Trainer Anthony said...

RE: Freeze Pane

Hi Kadri, thanks for your query. The trick lies in the positioning of the active cell. Excel will freeze every cell above and to the left of where the active cell currently is. Try setting the active cell to B2 and then using Freeze Panes.

Hope this helps,

Anthony

Wed 14 Apr 2010, 16:54 Trainer Anthony said...

Will be marked as resolved in 5 days

Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.

Wed 21 Apr 2010: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Screen Splitters in Excel

Screen splitter icons can be set from the ribbon bar, or dragged from the scroll bars. The icon just above the up arrow on the right scroll bar controls the horizontal splitter; the icon to the right of the right arrow on the bottom scroll bar controls the vertical splitter.

These icons can be double-clicked to split the screen at the top left of the cell currently in use.

View all Excel hints and tips

Freeze Pane

Freeze Pane

RE: Freeze Pane

Will be marked as resolved in 5 days

Excel articles

Excel tip:

Screen Splitters in Excel