pane freeze

Public Schedule Face-to-Face & Virtual Instructor-Led Training - View dates & book

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

Pane freeze

resolvedResolved · Low Priority · Version 2010

Sid has attended:
Excel Introduction course
Excel Intermediate course

Pane freeze

i would like to know how to freeze/unfreeze a pane

RE: pane freeze

Hi Sid

Thank you for your question

First select the cell that is immediately below the last row you want frozen and immediately to the right of the last column you want frozen.

Then go to the View ribbon and click on freeze panes in the window group

To unfreeze go to the View ribbon and click on unfreeze panes in the window group

Regards

Stephen

Tue 19 Jul 2011: Automatically marked as resolved.


 

Excel tip:

Finding cells that have data restrictions

Click anywhere on the worksheet.
On the Edit menu, click Go To.
Click Special.
Click Data validation.
Click All.

View all Excel hints and tips


Server loaded in 0.07 secs.